I have a peculiar problem:
I have a data in one excel sheet which I would like to transfer to another
excel sheet. The data in the original file (say F1) is in one single sheet
and what I want is to copy this data into a new file (say F2) and that too in
different worksheets based on a value in one column of F1.
For Example:
F1 has sheet 1 only with data in 8 columns and say about 500 rows.like
Headers are:
KD LT LD NW HO SE TIME
Data1
..................................................................1:1..................
The colum SE has data from 1:1 to 1:40
Now the what I need to do is create a new xls file F2 where a macro looks
for a sheet name 1-1 if its there then copies all the rows with 1:1 to that
sheet ...if the sheet is not there then tht macro shud create that sheet
named 1-1 and so on.
I need a macro for this as this data change every hour and there a 9 files
in which there is data and so I need to create like 360 new work sheets with
1-1 to 1-40 , 2-1 to 2-40,...9-1 to 9-40.
I hope some can help me out with this
Bookmarks