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?

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

On Sun, 13 Apr 2008 11:22:01 -0700, Koo30lau
<(E-Mail Removed)> 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?

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 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
>
> On Sun, 13 Apr 2008 11:22:01 -0700, Koo30lau
> <(E-Mail Removed)> 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?
>
>

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 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
>
> On Sun, 13 Apr 2008 11:22:01 -0700, Koo30lau
> <(E-Mail Removed)> 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?
>
>