Hi!
Ive searched the forum but at a bit of a loss... Woule be very glad for all help possible
Am looking for following:
A macro that is triggered from a button that will create a new worksheet (or workbook), using template called "Change", give it the name of the value in G4, search column H in the original worksheet, for the most recent dates, and transfer information on those rows to the new worksheet/book. Ot illustrate, if it finds 2007-01-01 on H7, it is to tranfer A7, B7, and D7 to columns A, B, C and first free row in new the worksheet/book with name X?
Is this too hard?
Ive searched the forum but at a bit of a loss... Woule be very glad for all help possible
Am looking for following:
A macro that is triggered from a button that will create a new worksheet (or workbook), using template called "Change", give it the name of the value in G4, search column H in the original worksheet, for the most recent dates, and transfer information on those rows to the new worksheet/book. Ot illustrate, if it finds 2007-01-01 on H7, it is to tranfer A7, B7, and D7 to columns A, B, C and first free row in new the worksheet/book with name X?
Is this too hard?