I need to learn how to:
1 - Pull data from one spreadsheet to another, by using a common information present in both spreadsheets
2 - Check updates, comparing old spreadsheet with a new one
19 freelance font une offre moyenne de $27 pour ce travail
Hi! I can explain how to do what you want in Excel by Formulas and by Macros. If the first question is easily resolved by Formulas, the second one is better to realise by VBA Macro.
What you need to learn is VLookup. I have a great worksheet on my computer that provides different ways we can use vlookups and hlookups. Teaching someone would only take 30 minutes top.
I am working in excel based projects for the last 10 years, working on data presentation, data mining and data aggregation. You want to learn these skills, I will be able to teach you the same.