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?