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 |
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 |