Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro for searching, copy and paste between sheets
Help please very new to macros.
I need to take users input value from sheet1 and search col A in sheet2 for the same number, say number 5, then move across row 5, four columns and insert a date value from sheet1 along with calculated future date value in column 5. have spent ages trying to do this, but unable to do it in macro. really would appreciate any help. I´m using excel 2003. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro for searching, copy and paste between sheets
You need to be more clear. Perhaps send your workbook to my address below
along with clear instructions and before/after examples. Also, a snippet of this msg so I know from whence it came. -- Don Guillett Microsoft MVP Excel SalesAid Software "Benijofar Dave" <Benijofar wrote in message ... Help please very new to macros. I need to take users input value from sheet1 and search col A in sheet2 for the same number, say number 5, then move across row 5, four columns and insert a date value from sheet1 along with calculated future date value in column 5. have spent ages trying to do this, but unable to do it in macro. really would appreciate any help. I´m using excel 2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and Paste with Macro Between sheets | Excel Discussion (Misc queries) | |||
Compare two wk sheets with common data using copy paste macro | Excel Worksheet Functions | |||
Copy&paste of several sheets | Excel Discussion (Misc queries) | |||
Macro - 2 Sheets - Find/Insert/Copy/Paste | Excel Programming | |||
Copy and paste between sheets | Excel Programming |