MichaelATO
06-25-2005, 12:22 AM
Hi
I have attached a work in progress file that mimics very closely the work file. The file "DataAnalysis.zip" is attached.
What I require is for staff to use the "first_dataset" sheet and to import a clients details from the imported data page.
The imported data sheet has all the details required but the details must be split into two sheets.
For both scenarios the details are copied to Range("A20") and populate down.
First scenario -
First dataset: to contain all clients details (columns A:F but only cost columns from 1 to 5 and
Second dataset: to contain all clients details (columns A:F) but only cost columns from 1 to 6.
I have already incorporated a vba macro to do the copy to both sheets but all columns are copied.
The second scenario:
Once the data has been copied to the sheets how can I get the formulas, which are all different (Shown in "Second_Dataset" row 21, column L to O), in Second Dataset starting in column L:O to copy down until the end of any value shown in column A?
Any assistance is greatly appreciated. Thank You
Regards
Michael
I have attached a work in progress file that mimics very closely the work file. The file "DataAnalysis.zip" is attached.
What I require is for staff to use the "first_dataset" sheet and to import a clients details from the imported data page.
The imported data sheet has all the details required but the details must be split into two sheets.
For both scenarios the details are copied to Range("A20") and populate down.
First scenario -
First dataset: to contain all clients details (columns A:F but only cost columns from 1 to 5 and
Second dataset: to contain all clients details (columns A:F) but only cost columns from 1 to 6.
I have already incorporated a vba macro to do the copy to both sheets but all columns are copied.
The second scenario:
Once the data has been copied to the sheets how can I get the formulas, which are all different (Shown in "Second_Dataset" row 21, column L to O), in Second Dataset starting in column L:O to copy down until the end of any value shown in column A?
Any assistance is greatly appreciated. Thank You
Regards
Michael