Create New Sheets from Filtered List

K

Koo30lau

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?
 
G

Gord Dibben

You have to change the named range "DataBase" parameters.

Specifically..........in Sheet1 go to Insert>Name>Define 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
 
K

Koo30lau

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create sheet with records for each rep in filtered list 3
NEED HELP! Macro loop 7
Macro to Compile Data from Different Sheets 2
Macro to Combine Data from Multiple Sheets with Cell References 4
need to automate 8
Checking for a minimum of 5 rows 2
Use loop to filter, copy/paste to new sheet; run through entire li 1
Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names 2

Top