Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automated copying & pasting from multiple sources
Hi all,
If I have a spreadsheet, can I set up a function / macro that will search for say "order number" and if it finds it then copy certain cells in that row and paste them to other cells within another spreadsheet that also contains a cell for the "order number"? I'm not sure if I am explaining myself correctly here... I can generate a report (spreadsheet 1) that has some information on it that I need to copy over to another spreadsheet (spreadsheet 2). From this other spreadsheet (2), other data is manually entered in. Once this other data is entered, I then need to be able to use just some of the data in this spreadsheet (2) to be copied into another spreadsheet (spreadsheet 3). Also, if possible when data is bought from spreadsheet 2 to spreadsheet 3 I would like spreadsheet 3 to insert a new row to contain the information from spreadsheet 2. I appreciate any feedback. Thanks, Averil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PLEASE HELP! Return a Value Using Multiple Sources | Excel Discussion (Misc queries) | |||
Return a Value Using Multiple Sources | Excel Discussion (Misc queries) | |||
Return a Value Using Multiple Sources | Excel Discussion (Misc queries) | |||
Automated multiple text files into multiple sheets in one workbook | Excel Discussion (Misc queries) | |||
Copying and pasting multiple formulas, it it possible? | Excel Discussion (Misc queries) |