Create New Sheets from Filtered List
I have one more question if you don't mind. I would like to also transfer the
last row that contains the total for each column from the master sheet to the
other sheets. How do I do that?
"Gord Dibben" wrote:
You have to change the named range "DataBase" parameters.
Specifically..........in Sheet1 go to InsertNameDefine and change the
"DataBase" range from
=Sheet1!$A$1:$G$43 to whatever you desire.
Then the code line Set rng = Range("DataBase") will act upon your range.
No need to edit the macro.
Gord Dibben MS Excel MVP
On Sun, 13 Apr 2008 11:22:01 -0700, Koo30lau
wrote:
I am using a macro from Contextures.com to create a new sheet for each rep. I
can run the macro but it only shows data up to column G in each rep new sheet
and the data I am entering on the master spreadsheet goes to column BG. How
can I fix the macro so all of the columns get copied to each rep sheet?
|