Auto populating multiple sheets
Closed
DumbUser
-
28 Apr 2015 à 15:57
MaxStart Posts 338 Registration date Tuesday 3 March 2015 Status Contributor Last seen 3 July 2015 - 28 Apr 2015 à 16:12
MaxStart Posts 338 Registration date Tuesday 3 March 2015 Status Contributor Last seen 3 July 2015 - 28 Apr 2015 à 16:12
Related:
- Auto populating multiple sheets
- Google sheets download - Download - Spreadsheets
- Android auto apk - Download - Other
- Nvidia auto detect - Guide
- What is auto download mms - Guide
- Split excel sheet into multiple files - Guide
1 response
MaxStart
Posts
338
Registration date
Tuesday 3 March 2015
Status
Contributor
Last seen
3 July 2015
69
28 Apr 2015 à 16:12
28 Apr 2015 à 16:12
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.
