Previous Topic Next Topic

Auto populating multiple sheets

Closed
DumbUser - Apr 28, 2015 at 03:57 PM
MaxStart Posts 338 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 - Apr 28, 2015 at 04:12 PM
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.



Related:

1 response

Answer 1 / 1
MaxStart Posts 338 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 69
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: 
=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.

Similar discussions

Cannot download multiple files at once in WhatsApp Web
nemonavicusrino -
dannygzus -

Hello, I have a very strange situation in last two month. Usualy my clients send me multiple files for printing (photo or doc). From day one when i use whats-app web i choose select mesaje, thic multiple files or pres shift and select last files that i want downloaded. after select/ thick multiple files, i press the download simbol in right corner . an archive is downloaded, extract archiv and i see al files that i dwanted to download.. Now, in last two month, i can not find what it was changed, because when i select multiple file, download sign not apear. Only after i download individual files (on doc, odf or other) or viwe any photo, via web or phone, only after this operation download ...

4 responses