enter data once to more location

T

tpbrettin

how can i entry data to one cell and have that data show up in different
cells and worksheets?
example cell b2 is for ending mileage, i want it to show up in c1 also and
so on. Not to complicate things i want this info to show up on a separte
worksheet for customer billing can you help?
 
P

pdberger

In C1, put the formula =B2. If these cells are on Sheet1, and you want them
on another page, then type the following into the 'target' cell on that page
-- ='Sheet1'!B2.

HTH
 

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

Data Validation List Macro 18
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Copy worksheet1 to worksheet2, keep cell format eg cell size 2
Enter number (data) into cells but want to show different data 3
Creating A List of Items Between Two Numbers 2
How to enter in one cell and show up in other worksheets 2
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Help breaking up data in a cell 5

Top