Auto-populate a sheet with data from different other sheets

Solved/Closed
ThanatosTalos
Posts
30
Registration date
Monday July 22, 2019
Status
Member
Last seen
July 28, 2019
- Jul 22, 2019 at 03:31 PM
 Blocked Profile - Jul 29, 2019 at 07:07 AM
Hello,
I have been having problems with having a general data sheet in my workbook. My problem is as follows:

I have 3 different sheets, all of which keep track of the same set of data, for purposes of this question, let's say they all keep track of:
-Id
-Name
-Random Number

They are separated in 3 different sheets because they are filled by 3 different people, as the workbook is in a network. However, the problem that I am facing is having an auto filling general sheet; as in, when the first user fills rows in their respective sheet, it auto populates in a fourth different sheet, where all the data is kept track of.

Maybe I am not making myself clear as English is not my first language, but in other words, I want a sheet to be auto populated as multiple others are filled.



System Configuration: Windows / Chrome 75.0.3770.142
Related:

9 replies

Blocked Profile
Jul 22, 2019 at 04:35 PM
Ok, this is real easy. Make your cell reference to the the sheet, as in
=Sheet4!A2
=Sheet4!A3
=Sheet4!A4

and then....
=Sheet3!A78
=Sheet3!A79
=Sheet3!A80
=Sheet3!A81


No coding needed!

0
ThanatosTalos
Posts
30
Registration date
Monday July 22, 2019
Status
Member
Last seen
July 28, 2019

Jul 23, 2019 at 02:14 PM
Hold on, wouldn't this mean then i would have to manually input every single cell reference to the sheet? That would be cumbersome
0
Blocked Profile
Jul 23, 2019 at 02:28 PM
Yes, and no its not with an auto drag.

Do you know how to build a " for loop " in VBA?
0