Forum Discussion
Transfer data from one table to another table with different layout
ihatebillsDetlef_Lewin Thanks for the reply
I tried what you suggested with the vlookup but am not quite sure how to implement it in the spreadsheet (attached) I have the source sheets (2) and the destination sheets (2).
Does the vlookup move the data from the source sheet to destination sheet or does it reference the source sheet in the destination document (so i would need to keep the source sheets in workbook either in plain view or hidden)
hello I have attached a file with steps to do to make things easier
to answer your question:
vlookup just uses its formula and does nothing to your source, so it is safe and won't be moved.
note if you move your data - source data to another sheet just make sure your vlookup formulas are refreshed or recoded because it may return an error message or wont work basically your source has changed destination.