Auto populating multiple sheets
Closed
DumbUser
-
Apr 28, 2015 at 03:57 PM
MaxStart Posts 339 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 - Apr 28, 2015 at 04:12 PM
MaxStart Posts 339 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 - Apr 28, 2015 at 04:12 PM
Related:
- Auto populating multiple sheets
- Grand theft auto 1 download - Download - Action and adventure
- Grand theft auto v free download no verification for pc - Download - Action and adventure
- Facebook auto refresh - Guide
- Nvidia drivers auto detect - Guide
- Auto redial - Guide
1 response
MaxStart
Posts
339
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
69
Apr 28, 2015 at 04:12 PM
Apr 28, 2015 at 04:12 PM
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:
However; you can accomplish a lot more using macros.
you just need to trigger an event.
Je ne parle pas français, mais je l'aime.
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.
