Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Remove data from certain rows and place in new row or spreadsheet
I have a long list of data, approximately 5000+ rows. I also have a second
list of data that was derived from the first list by an outside source. I want to take the 2nd list and bump it up to the 1st list and tell excel to cut the data from that row and place it in another spreadsheet ideally, or another area. |
#2
|
|||
|
|||
Remove data from certain rows and place in new row or spreadsheet
If I understand teh question the first list has "extra' data?
Help VLookup lookup name from second list and deliver the other information from that name's row to the new area "John" wrote: I have a long list of data, approximately 5000+ rows. I also have a second list of data that was derived from the first list by an outside source. I want to take the 2nd list and bump it up to the 1st list and tell excel to cut the data from that row and place it in another spreadsheet ideally, or another area. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find data in columns, then place in rows | Excel Worksheet Functions | |||
Monitoring Data | Excel Discussion (Misc queries) | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Look up values and place in spreadsheet | Excel Discussion (Misc queries) | |||
How do I move the end of the spreadsheet place where (ctrl + end). | Excel Discussion (Misc queries) |