excelthong
Active Member
- Joined
- Jul 13, 2006
- Messages
- 313
Hi Forumate
thank you for your help and hope some expert can guide me here.
I have a list of data from A1 to AE3548
however the algorithm is simple, there is a time difference in column C,
which mean
C1 :C14 = 2:20 and
C14:C20 = 2:30,
C21:C27 = 3:00 etc
column B is date
may i know how can i copy the data and split the sheet like
when C14 and C15 is different, copy A15to AE15 to a new sheet
when C20 and C21 is different, trigger and copy A20 to AE20 to new sheet?
and use the date in column B to name the sheet in the order like 200327-1 etc?
thank you for the helps
thong
thank you for your help and hope some expert can guide me here.
I have a list of data from A1 to AE3548
however the algorithm is simple, there is a time difference in column C,
which mean
C1 :C14 = 2:20 and
C14:C20 = 2:30,
C21:C27 = 3:00 etc
column B is date
may i know how can i copy the data and split the sheet like
when C14 and C15 is different, copy A15to AE15 to a new sheet
when C20 and C21 is different, trigger and copy A20 to AE20 to new sheet?
and use the date in column B to name the sheet in the order like 200327-1 etc?
thank you for the helps
thong