sanchit16
New member
A | 12:13 |
B | 4:56 |
C...so on up to 20 more columns | 4:34 |
we have SHEET LIKE ABOVE WITH THE NAME "DATA OF 12 FEB 2012" AND COLUMNS A,B,C,D...WITH THE TIME COLUMN.
and we have another excel file (FULL MONTH DATA)with SHEET name A,B,C,D,....SO ON UP TO 20. AND IN EACH SHEET WE HAVE DATES:
SUPPOSE THIS IS" A "SHEET WITH DATES ..AND WE HAVE MANY SUCH SHEET WITH NAM B,C,D,E...... IN ONE EXCEL FILE.
12 FEB 2012 | 12:13 |
13 FEB 2012 | SO ON.... |
14 FEB 2012...SO ON UPTO LAST DATE OF MONTH | SO ON... |
NOW I WANT SUCH MACRO WHICH TAKES OUT DATA FROM" DATA OF 12 FEB 2012" EXCEL FILE AND FILLED IT IN "FULL MONTH DATA" AS PER THE DATE IN DIFFER SHEET. (A ,B,C,D,.....)
HOPE YOU CAN GET IT WAT I NEED.
IF NOT PLEASE FELL FREE TO ASK.