How do I enter data on one worksheet and have it appear on another

  • Thread starter Thread starter Walker28
  • Start date Start date
W

Walker28

I want to enter data on the first worksheet and have the data post to another
based on the field "Location". I have five locations and I want a tab for
each.
 
I want to enter data on the first worksheet and have the data post to another
based on the field "Location". I have five locations and I want a tab for
each.
Click to expand...

Since you are basing it on a field, have a look at the VLOOKUP
function.
 
Assume you want data entered in cell b5 of Sheet 1 to appear in cell g7 of
Sheet 2.
Put this formula in cell g7 of Sheet 2.

= Sheet1!b5

Whatever you post in b5 of Sheet 1 will also appear in g7 of Sheet 2.
 

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

OFFSET LOOKUP function in VBA? 9
Copy Range of data using VBA 0
Passing data to an event handler 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
i want to input data into a range from a simple input location 1
setting one worksheet cell range reference to another worksheet 1
Excel Move or Copy Stopped Working? 0
cell to worksheet 1

Back
Top