I was wondering if there is a way to do the following automatically:

I have a workbook with 15+ worksheets. Sheet 1 is a template where the
users copy from a spreadsheet in another workbook and paste the information
onto this worksheet template. The worksheet template stays the same with the
first row containing header information. The rest of the spreadsheets
contain header information on the first 2 rows and a formula on the 3rd row.
Each formula is different on these spreadsheets and the number of columns
will vary.

Is there a way to take the information contained on the template worksheet
and copy it to the existing worksheets based on the formulas in each
worksheet. For example, on the template worksheet I have 500 rows of
information, not including the header. I want to take these rows and apply
them to the existing formulas in the remaing worksheets and then delete any
duplicates that exist in each worksheet.


Thanks

difficult you'd have to loop through each sheet, identify each column then
copy those columns for each row.
how will you identify duplicates?

"LostInNY" <(E-Mail Removed)> wrote in message
news:0BE7D561-F17A-4CAB-BC6A-(E-Mail Removed)...
> I was wondering if there is a way to do the following automatically:
>
> I have a workbook with 15+ worksheets. Sheet 1 is a template where the
> users copy from a spreadsheet in another workbook and paste the
> information
> onto this worksheet template. The worksheet template stays the same with
> the
> first row containing header information. The rest of the spreadsheets
> contain header information on the first 2 rows and a formula on the 3rd
> row.
> Each formula is different on these spreadsheets and the number of columns
> will vary.
>
> Is there a way to take the information contained on the template worksheet
> and copy it to the existing worksheets based on the formulas in each
> worksheet. For example, on the template worksheet I have 500 rows of
> information, not including the header. I want to take these rows and
> apply
> them to the existing formulas in the remaing worksheets and then delete
> any
> duplicates that exist in each worksheet.
>
>
> Thanks

Patrick-

The duplicates are identified by values in the first 4 columns for each
spreadsheet.

"Patrick Molloy" wrote:

> difficult you'd have to loop through each sheet, identify each column then
> copy those columns for each row.
> how will you identify duplicates?
>
> "LostInNY" <(E-Mail Removed)> wrote in message
> news:0BE7D561-F17A-4CAB-BC6A-(E-Mail Removed)...
> > I was wondering if there is a way to do the following automatically:
> >
> > I have a workbook with 15+ worksheets. Sheet 1 is a template where the
> > users copy from a spreadsheet in another workbook and paste the
> > information
> > onto this worksheet template. The worksheet template stays the same with
> > the
> > first row containing header information. The rest of the spreadsheets
> > contain header information on the first 2 rows and a formula on the 3rd
> > row.
> > Each formula is different on these spreadsheets and the number of columns
> > will vary.
> >
> > Is there a way to take the information contained on the template worksheet
> > and copy it to the existing worksheets based on the formulas in each
> > worksheet. For example, on the template worksheet I have 500 rows of
> > information, not including the header. I want to take these rows and
> > apply
> > them to the existing formulas in the remaing worksheets and then delete
> > any
> > duplicates that exist in each worksheet.
> >
> >
> > Thanks
>

If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"LostInNY" <(E-Mail Removed)> wrote in message
news:0BE7D561-F17A-4CAB-BC6A-(E-Mail Removed)...
>I was wondering if there is a way to do the following automatically:
>
> I have a workbook with 15+ worksheets. Sheet 1 is a template where the
> users copy from a spreadsheet in another workbook and paste the
> information
> onto this worksheet template. The worksheet template stays the same with
> the
> first row containing header information. The rest of the spreadsheets
> contain header information on the first 2 rows and a formula on the 3rd
> row.
> Each formula is different on these spreadsheets and the number of columns
> will vary.
>
> Is there a way to take the information contained on the template worksheet
> and copy it to the existing worksheets based on the formulas in each
> worksheet. For example, on the template worksheet I have 500 rows of
> information, not including the header. I want to take these rows and
> apply
> them to the existing formulas in the remaing worksheets and then delete
> any
> duplicates that exist in each worksheet.
>
>
> Thanks