| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create New Sheets from Filtered List
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create New Sheets from Filtered List
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create New Sheets from Filtered List
Thanks so much for your quick response. You are a saint.
"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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create New Sheets from Filtered List - help on macro | Excel Programming | |||
| create a master list from other sheets | Excel Worksheet Functions | |||
| Need to create a list of sheets from a list of names in column a | Excel Programming | |||
| Create New Sheets from Filtered List using Template | Excel Programming | |||
| create a list from 2 sheets | Excel Worksheet Functions | |||
Linear Mode
