Info between worksheets

E

Eileen

All i want to do is fill a cell with a number and that number to go into a
cell on another sheet as well.
 
J

Joe User

Eileen said:
All i want to do is fill a cell with a number and that
number to go into a cell on another sheet as well.
Click to expand...

A little light on details, dontcha think?

Suppose the cell to be filled in is in A1 in Sheet1. Suppose the other cell
is in B1 in Sheet2. Then B1 in Sheet2 should have the following formula:

=if(Sheet1!A1="", "", Sheet1!A1)

The first part of the IF statement ensures that if A1 appears to be blank,
so will B1.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Crating User Form to Add Names 1
Embed the same Excel multiple times 0
VBA Coding Help for Beginner 0
Newbie Help - IF Yes No Function 0
formula issues. 0
Identifying common data between 2 cells 1
Moving Cells 0

Top