Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
1 Create a macro to Copy & paste certain data to another sheet
I have no experience with macros @ all. Really need your help.
I have a spreedsheet that I sort by column A, depending on what code is in column A, I need the data adjacent to it copied to another sheet. Example: SHEET "OPEN" COLUMN A COLUMN B COLUMN C COLUMN D 09 $25,000 ABC VENDOR 11/2/08 13 $55.00 XYZ VENDOR 10/19/08 IF COLUMN A ON WORKSHEET "OPEN" IS = 09 THEN I NEED EVERYTHING IN THE ROW ADJACENT TO IT (COLUMN B THRU D) COPIED TO SHEET "SMITH". CAN ANYONE HELP ME. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro - copy a range and paste it in a new sheet 12 times | Excel Worksheet Functions | |||
how to create a copy/paste special/transpose macro? | Excel Discussion (Misc queries) | |||
How to create a macro which performs a copy-and-paste task every 5mins after data is refreshed from web page? | Excel Worksheet Functions | |||
Copy and Paste Macro for front totals sheet | Excel Discussion (Misc queries) | |||
I need formula help or create a macro to copy and paste value only | Excel Discussion (Misc queries) |