Hi - newbie here! Thank you for accepting me.
I've used excel a lot over the years and can carry out basic sumifs, lookup, pivot tables, etc - but not in-depth - I've tried googling how to do it and found consolidating data doesn't work with what I would like to do.
To keep it brief - I have 2 spreadsheets for 2 different companies, owed by the same people for a construction site they are working on. The data has to be kept separate for accounting purposes. On the master sheet for both companies the data includes - supplier, invoice date, number, gross value, part number, description, plot number and more. I would like both the spreadsheets to merge together on a 3rd spreadsheet so that I can look up suppliers and query prices and also run pivot tables to issue costs by plots. Also, when entering data on the individual spreadsheet it will automatically update the merged file.
I don't understand VBA functions at all and it's like reading a foreign language!
Thank you for reading my post.
I've used excel a lot over the years and can carry out basic sumifs, lookup, pivot tables, etc - but not in-depth - I've tried googling how to do it and found consolidating data doesn't work with what I would like to do.
To keep it brief - I have 2 spreadsheets for 2 different companies, owed by the same people for a construction site they are working on. The data has to be kept separate for accounting purposes. On the master sheet for both companies the data includes - supplier, invoice date, number, gross value, part number, description, plot number and more. I would like both the spreadsheets to merge together on a 3rd spreadsheet so that I can look up suppliers and query prices and also run pivot tables to issue costs by plots. Also, when entering data on the individual spreadsheet it will automatically update the merged file.
I don't understand VBA functions at all and it's like reading a foreign language!
Thank you for reading my post.
