Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Paste Macro
One sheet one I have a table containing transaction data B4:J514 (th first row is the header). In the "C" Column contains the transactio date. Sheet one contains all transactions ever recorded. One sheet two I would like to have a macro that I can select a mont from a dropdown list and run the macro to see the transactions for tha month populate in the fields E4:M30. The reason a auto filter will not work is that I have some formula that will do reporting based on the data in sheet 2 E4:M30. I have already created a dropdown list (cell H2) on sheet 2 containin the month/year I want to view. I am just not sure how to make the macr to look for the dates on sheet one that match and copy them over. Please hel -- jermsalerm ----------------------------------------------------------------------- jermsalerms's Profile: http://www.excelforum.com/member.php...fo&userid=3016 View this thread: http://www.excelforum.com/showthread.php?threadid=51782 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Paste Macro
Have you looked at the Subtotal worksheet function which will work with the
visible cells in a filtered range (it is multifunction - not just summing) If that won't work, then you can still us an autofilter and copy the data. Only the visible rows are copied. sample code using an autofilter is at Ron de Bruin's site: http://www.rondebruin.nl/copy5.htm -- Regards, Tom Ogilvy "jermsalerms" wrote in message ... One sheet one I have a table containing transaction data B4:J514 (the first row is the header). In the "C" Column contains the transaction date. Sheet one contains all transactions ever recorded. One sheet two I would like to have a macro that I can select a month from a dropdown list and run the macro to see the transactions for that month populate in the fields E4:M30. The reason a auto filter will not work is that I have some formulas that will do reporting based on the data in sheet 2 E4:M30. I have already created a dropdown list (cell H2) on sheet 2 containing the month/year I want to view. I am just not sure how to make the macro to look for the dates on sheet one that match and copy them over. Please help -- jermsalerms ------------------------------------------------------------------------ jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167 View this thread: http://www.excelforum.com/showthread...hreadid=517823 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro | Excel Programming | |||
Copy and Paste macro needs to paste to a changing cell reference | Excel Programming | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
Macro to Copy/Paste then Paste to Next Line | Excel Programming | |||
Macro Copy/Paste Help | Excel Programming |