Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all!
I have a question that I believe you guys can answer. Here it is: I have 2 tabs in an Excel workbook - one tab ('All Transactions') contains info for every type of transaction I've done. This gets continuously updated from other spreadsheets via a macro. There is a column (Column B) within this tab which describes what type of transaction it is ("Bound", "Declined", "ANB"). What I want done is to run a macro which would copy the first 15 columns from this tab with the any transaction which is labeled as "Bound" in column B and paste it to the 2nd tab in the workbook ('Bound Transactions'). In essence, I don't want to copy any deals labeled as "Declined" or "ANB" from column B. I hope I wasn't too confusing - can someone please help? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copying from one TAB to another based on certain criteria | New Users to Excel | |||
Copying data based on filter criteria | Excel Worksheet Functions | |||
Copying a range based on criteria | Excel Programming | |||
Copying a range based on criteria | Excel Programming | |||
Copying data from one worksheet to another based on criteria | Excel Discussion (Misc queries) |