Recent content by mleosu

THANKS

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...

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...

works like a charm! thanks for all your help!

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

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...

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.

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.

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

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...

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...

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!

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...

ok - i get it. thanks

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