I am looking for a way to merge my data i have. I have;
- spreadsheet with assets
- spreadsheet with ledger payments
- spreadsheet with document information and documents attached
I need to do a lookup by word and link the ledger payment and/spreadsheet with doc information to an asset table with the spreadsheet with assets.
i also need to load photographs of the assets that i have downloaded but the spreadsheet with assets does have the photograph number so i believe it can be done.
I am in a rush so i need to do this quickly.