Hi there I am trying to copy repetative Data between workspaces. In excell the VLOOKUP function was used and it works fine.
I have 4 workspaces
- Mortgage Fact Find → this has a data such as name address mobole email DOB address postcode
- Mortgage Appplication → there is a lot od data in sheet 1 that i wnat to pull inot sheet 2 (celluar data)
- Mortgage SIGNOFF → this has data i need to pull from worksheet 2
- Mortgage NBR → This data need to be pulled from the previous threre shetts no human input
I wpuld appreciate if anyone could help me out here I have tried VLOOKUP and it just fails all the time