Home |
Search |
Today's Posts |
#1
|
|||
|
|||
merging sheet1 to sheet2
Alright, I am not sure if I should be utilizing a macro, a formula or what.
Here is my situation. I work in an office that is consistantly using excel. Commonly I need to copy data from sheet1 and paste to sheet2. Here's the kicker--what is on row 1 in sheet1 may be on row 999 on sheet2. I am looking for a way to save me tons of time. What I would like to be able to do is create a formula/macro that allows me to copy data from sheet1 and paste to sheet2 using a common identifier that exists in a row. Therefore, the data lines up where appropriate without me having to copy and paste. I know there must be a way to do this. I need very 'dumbed' down directions if somebody is willing to adopt this task. I will be watching for any activity. Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine 3 Columns on Sheet2 to Display in 1 Column on Sheet1 | Excel Worksheet Functions | |||
Modifying Sheet1 macro to run on Sheet2 | Excel Discussion (Misc queries) | |||
Looking for comparable data records between Sheet1 and Sheet2 | Excel Discussion (Misc queries) | |||
can i type sheet1 A5 and make it show Sheet2 A6 cell | Excel Discussion (Misc queries) | |||
Copy values from Sheet1 to Sheet2 | Excel Discussion (Misc queries) |