jigar1276
07-12-2008, 03:46 AM
Hi Experts,
I have 2 excel file. "Report File.xls" is received by me. I am copying the contents from "Report File.xls" to "Data File.xls".
I want the macro which should prepare my "Data File.xls" by copying Date from cell A2, Team name, Name & No. of Errors from "Report File.xls". The number of Teams are not fixed in "Report File.xls", it can be anywhere from 1 to 3. Number of names in each team in "Report File.xls" are also not fixed.
I have attached sample.zip file which contains both the excel files.
Please help. :banghead:
I have 2 excel file. "Report File.xls" is received by me. I am copying the contents from "Report File.xls" to "Data File.xls".
I want the macro which should prepare my "Data File.xls" by copying Date from cell A2, Team name, Name & No. of Errors from "Report File.xls". The number of Teams are not fixed in "Report File.xls", it can be anywhere from 1 to 3. Number of names in each team in "Report File.xls" are also not fixed.
I have attached sample.zip file which contains both the excel files.
Please help. :banghead: