populate data automatically from sheet to another
I have seen similar posts on this problem, but none worked for me. I have a workbook with 5 sheets, it's part of a finance project. What I would like to do is in input all new information on the first sheet, then have the other sheets auto populate with that data. For example, on the first sheet, all data from a20:g30 should populate on sheet 2, all data from a40:g50 should populate on sheet 3, etc. is there a way to accomplish this? I am a beginner when it comes to complicated formulas and macros, so please be detailed, any help is greatly appreciated!!!
It is easy and you do not need a macro!
As far as I could understand your request, it is easy to solve and you do not even need a macro.
Just go to the second sheet and write on the first cell "=Sheet1!A1" and you drag this until cell g30
Go to 3rd sheet and place on the first cell "=Sheet1!a40" and you drag it as well.
Do the same for the last 2 sheet and from now on you just have to input data on the first sheet.
I hope it helps,
Cátia Santos
worked like a charm!
Thanks Cátia, your explanation was easy to understand, and it worked perfectly!
Welcome!
We are really welcome! comeback if you have more questions :)
Have a nice day!