Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data manipulation within the same sheet
I have a spreadsheet where the first 5 columns have data I want to pull from.
Further down the column path, I have a section where I type a Loan # in and I want it to search the first few columns for that Loan # and pull the data that corresponds to it and place it at the new location. We have managed to get this part done by using an old Lotus Data Retrieval command. If there is a better way would appreciate the input. The part we have not figured out yet is what I really need help with. After the data is found and copied to the new location, I want it to automatically delete itself from the data in the first few columns. Lets say my data I am pulling from is in column A-F Rows 1-100. In column N I enter a Loan #. I need it to search Column A for that loan # and pull the corrsponding data from columns A-F and move it to Columns O-T and then remove itself from columns A-F. Any suggestions on how I might do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
Excel and propogating data | Excel Worksheet Functions | |||
refresh external data on a protected sheet | Excel Discussion (Misc queries) | |||
find data from other sheet | Excel Worksheet Functions | |||
Automatioc spill over data to a new Excel sheet from Xml source? | Excel Discussion (Misc queries) |