Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mleosu

    copy sheets with variable sheetnames

    THANKS
  2. mleosu

    copy sheets with variable sheetnames

    well, before i reconstruct my code - which yes, i am sure it could be reduced quite a lot - i just thought about establishing variable names for the main workbook and the new workbook (since neither will ever be constant) - this will help me go between the 2 at all times without using thier...
  3. mleosu

    copy sheets with variable sheetnames

    I have some code that copies data and pastes it into new sheets - where the sheet names are variable depending on the data copied into them. Another thing about the code is that the number of new sheets will not always be the same - i could be from 1 new sheet to 4 new sheets. I want to move...
  4. mleosu

    Help with Dynamic Named Ranges

    works like a charm! thanks for all your help!
  5. mleosu

    Help with Dynamic Named Ranges

    oops = that should be COUNTA('Pivot Tables(2)'!$A:$A),
  6. mleosu

    Help with Dynamic Named Ranges

    okay - here is the new sheet http://farm1.static.flickr.com/215/501332917_a1de51ed69_o.jpg this is the offset i have written: =OFFSET('Pivot Tables (2)'!$A$3, 0, 0, COUNTA(Sheet1!$A:$A),8) =OFFSET( Sheet1!$A$1, <-starts at begining of pivot table 0, <-will start w/ header rows(didnt...
  7. mleosu

    Help with Dynamic Named Ranges

    OF COURSE - if I move my pivot tables to be side by side - then i can keep using the vLookup and include the entire columns so it will grab everything - then i wouldnt need the dynamic named ranges - right? but i want to learn them anyways - so i will be back after i move the tables.
  8. mleosu

    Help with Dynamic Named Ranges

    Okay - thats what I thought after I looked at the counta, i will work on moving the pivot tables to not stack. and i will work on the offset formula and come back. thanks.
  9. mleosu

    Help with Dynamic Named Ranges

    by the way. what is the differene between columns over and width?
  10. mleosu

    Help with Dynamic Named Ranges

    Let's see if I got this close to right... Here is the offset formula I entered: =OFFSET('Pivot Tables'!$J$3, COUNTA('Pivot Tables'!$J:$J), 0, 0, 8) Here is a picture of my worksheet (http://farm1.static.flickr.com/189/501266952_44010a846d.jpg) - notice though that there is another pivot table...
  11. mleosu

    Help with Dynamic Named Ranges

    From my preivous thread about GetPivotData (http://www.tek-tips.com/viewthread.cfm?qid=1368354&page=1) I found I need to use dynamic named ranges - and looked at http://tek-tips.com/faqs.cfm?fid=1331 for instructions. I followed them, but I guess I am totally confused by them to. I keep...
  12. mleosu

    Excel - Confused about GetPivotData Function

    Oh - I didnt realize that about the Excel versions... that will be a problem since our office ranges from Excel 97 to 2003!! Thanks so much, I'll look into the dynamic name ranges!
  13. mleosu

    Excel - Confused about GetPivotData Function

    I have several pivot tables that I use to summarize the data I need and then, currently, I am using vlookups to transfer the pivot table data to reports. This creates error sometimes - becuase the pivot tables can change each time I run the report - so I have to make sure that the vlookup is...
  14. mleosu

    duplicate results for code

    ok - i get it. thanks
  15. mleosu

    duplicate results for code

    when you hit save on the menu bar (or ctrl+s - however you save normally.
  16. mleosu

    duplicate results for code

    works - thanks. i need to read more about Application.EnableEvents!
  17. mleosu

    duplicate results for code

    To save space here - I have uploaded my code in documents to the web for viewing This is the before save macro that calls the errorcheck macro and the sendmail macro: http://docs.google.com/Doc?id=ddp638t3_2hmsqx3 This is the ErrorCheck Macro: http://docs.google.com/Doc?id=ddp638t3_4ftjq4w...
  18. mleosu

    duplicate results for code

    I have a beforesave event that checks to see if any changes were made to the spreadsheet, to check for errors, and to save and send an email. For some reason - the part of the code that is for saving and emailing is running twice - so 2 message boxes are shown and 2 emails are sent. I dont...
  19. mleosu

    Run macro on save

    problem fixed
  20. mleosu

    Run macro on save

    okay - i included in the code that if all fields were empty then save is allowed - now i get the error (Compile Error in Hidden Workbook: This Workbook) What the heck does that mean?

Part and Inventory Search

Back
Top