Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Copy Data from one worksheet to another
I have Sheet 1 containing columns and rows of chronologically entered transactions.
I would like certain data in this sheet that conforms to certain criteria to automatically appear in sheet 2 as and when that data is entered in sheet 1. Is VBA is the route to go, and if so, could someone suggest the code that might be used? The Column headings in Sheet 1 a DATE DETAILS DEBIT CREDIT The criteria is to copy into sheet 2 only rows containing: AV CL SP from the DETAILS column. I hope all this makes sense and any help would be much appreciated. Joe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Refresh data from original worksheet to newly created copy | Excel Discussion (Misc queries) | |||
Worksheet auto text copy | Excel Discussion (Misc queries) | |||
Worksheet Text Auto Copy | Excel Discussion (Misc queries) | |||
auto copy to new worksheet | New Users to Excel | |||
Auto copy a raw from a worksheet to another. | Excel Programming |