Copy info from cells between worksheets

[bloomis]

Hi,
I have looked and searched all over for this, but can't find the answer.

I have an Excel workbook that has two worksheets in it. What I have is certain cells from the first worksheet need to automatically be entered into certain cells on the second worksheet.

Examples would be when a value is entered into cell B5 on the first worksheet, I want it to automatically entered into cell B2 on the second worksheet.

Also if anything is entered in cell D2, I want CheckBox13 on the second worksheet to be checked.

There is more data that needs to be copied from the first worksheet to the second worksheet, but I wanted to get a basic idea of how to do this and I cannot find any info. Maybe I am searching incorrectly or something.

Any help offered I would be thankful for!

Thanks in advance!
Brian

[shg]

Welcome to the forum.

Please take a few minutes to read our forum rules, and then amend your thread title accordingly.

Thanks.

[batesie]

For your first problem :

Just enter '=' on the cell you want the data to show and then navigate to the cell that the data is already in - try putting this in B2 on your second worksheet -

=Sheet1!B5

Hope it helps

[bloomis]

Thanks batesie, that worked great!

How do I get the cells on the second worksheet to stay blank if nothing is entered into the cell on the first worksheet?

With doing the '=' sign, it puts a '0' in the cell on the second worksheet if nothing is in the cell on the first worksheet.

Thanks,
Brian