Search results for query: *

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.

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

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

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

problem fixed

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?