office help: Excel 03: How do I make info I type into a cell on worksheet 1 show up automatically in a cell on worksheet 2? - Help.com



This post left anonymously

Excel 03: How do I make info I type into a cell on worksheet 1 show up automatically in a cell on worksheet 2?

I’m keeping track of records on the 2 sheets, each sheet has different info for the same record. If I type BOLOGNA in cell A1 of Sheet 1, I want BOLOGNA to show up in cell A2 of Sheet 2…

This open post was written 9 months, 2 weeks ago | V/U/S: 240, 5, 1 | Edit Post | Leave a reply | Report Post


Reciprocity (0) Reciprocation Failure -- The poster has NOT helped anyone else yet!

Since writing this post Anonymous may have helped people, but has not within the last 4 days.

Post Tags (3)

excel, spreadsheets, office (How Tags Affect Reciprocity)

Replies (5)

Where were you?

Click and drag to move the map around. FAQ: How we place people on this map »
You can also watch events on Help.com as they happen
Mouse over the map for 2 seconds to see an expanded, interactive view

fractal.scatter offline Verified User (10 months, 3 weeks) Long Term User Shouts: 296 #
An Unknown Location | 9 months, 2 weeks ago (7 minutes after post)

On the same cell in the second sheet type
= then select sheet one and the cell you want. It should copy that cell to the second sheet. You can then drag the black square in the corner of the cell around to copy it to any other cells you want to mirror.

Do you see what I mean?

Quote this reply Report this reply to moderators
michael_d_hawkin offline Verified User (9 months, 2 weeks) Long Term User Shouts: 0 #
An Unknown Location | 9 months, 2 weeks ago (12 minutes after post)

Ok, I just tried it and this is the formula it gives me =Sheet2!B83…this gives me a value of ‘0′ for whatever I type in B83 on sheet 1???

Quote this reply Report this reply to moderators
fractal.scatter offline Verified User (10 months, 3 weeks) Long Term User Shouts: 296 #
An Unknown Location | 9 months, 2 weeks ago (14 minutes after post)

Well is the original is on sheet 1 at A1 and the copy is on sheet2 at A1, then in A1 of sheet 2 type
‘=Sheet1!A1′

Quote this reply Report this reply to moderators
michael_d_hawkin offline Verified User (9 months, 2 weeks) Long Term User Shouts: 0 #
An Unknown Location | 9 months, 2 weeks ago (17 minutes after post)

Got it!!! Thanks a million!!!

Quote this reply Report this reply to moderators
fractal.scatter offline Verified User (10 months, 3 weeks) Long Term User Shouts: 296 #
An Unknown Location | 9 months, 2 weeks ago (17 minutes after post)

No probs.

Quote this reply Report this reply to moderators

Invite Others to Help

A logged in and verified Help.com member has the ability to setup a Friends List and invite others to help with posts.