Auto populating multiple sheets

[Closed]
Report
-
Posts
341
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
-
Hello,
I have read some of the Qs and As and they are scary if you don;t know Excel. !

Is there not a simple formula for entering data into a specific cell on a specific sheet and then having it also auto populate into a different cell on a different sheet?

Surely there is not some major Einstein looking expression! It seems to be physicist that wrote the answers to these blog Qs LOL

Help a simple **** person please.
BTW the sheets are in the same document.



1 reply

Posts
341
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
68
Hi there;
bear with me as I follow-up with you,
while entering text in a cell the formula stored in it will be replaced with your text, but as an example:
let's say that Cell A1 on Sheet2 will change value according to Cell1 on Sheet 1, for this to accomplish simply select Cell A1 on sheet2 and enter this Formula:
=IF(Sheet1!A1="test1","test1 was entered","")

However; you can accomplish a lot more using macros.
Sub M()
If ThisWorkbook.Sheets(1).Cells(1, 1).Value = "test1" Then
    ThisWorkbook.Sheets(2).Cells(1, 1).Value = "test1 was entered"
End If
End Sub

you just need to trigger an event.
Je ne parle pas français, mais je l'aime.