Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

How to paste cell information, based on another sheet cell


  • Please log in to reply

#1
hugoafsilva

hugoafsilva

    New Member

  • Member
  • Pip
  • 3 posts
Hi to all,

How are you?

I'm trying to find an automated way to transfer data from sheet to sheet without the copy/paste method.

What i want to do is this:

I have two sheets on a book.

On the 2nd sheet, i want to input "cell" like A2 on a blank cell. This is the input value set by me.

The next cell, would read the value A2 on the other sheet, and give me the value i have on C2, based on that value.

I don't know if i'm explaining this correctly.

So i'm doing an example here:

sheet1
A2 = 6 B2=9 c2=10

Sheet2
A2 = input by me cell number A2 B2 = automatic input value B2 of sheet1 C2 = automatic input value C3 of sheet1


Can you help me with this? Is it even possible to do?

Thanks
  • 0

Advertisements


#2
Vino Rosso

Vino Rosso

    Visiting Staff

  • Visiting Consultant
  • 235 posts
Unless I'm misunderstanding what you want:

Click on Sheet2 A2
Press = on the keyboard
Click on the Sheet1 tab then cell A2
Press Enter on the keyboard
(The contents of Sheet2, A2 will be =Sheet1!A2)

Anything you put in Sheet1 A2 will appear in Sheet2 A2.

Drag/copy Sheet2 A2 contents to B2, C2 or repeat the above as necessary.
  • 0

#3
hugoafsilva

hugoafsilva

    New Member

  • Topic Starter
  • Member
  • Pip
  • 3 posts
Hi there,

Thanks for the fast reply.

Its something like that, yes. But i want the method to be automatic and to only fill some cells.

I have info on sheet1 that goes from A to J

And i want on sheet2, that column B show info from C column of sheet1, column G shows column F of sheet1.

And the most tricky part, is that i want it to be done automatically, meaning i fill column A with the name of the cell, and the rest of the cells, fill in automatically with the info from the row that belongs to that cell.
  • 0

#4
hugoafsilva

hugoafsilva

    New Member

  • Topic Starter
  • Member
  • Pip
  • 3 posts
i i'll try to upload an example of this! Its probably more easy to explain :S
  • 0

#5
dsenette

dsenette

    Je suis Napoléon!

  • Administrator
  • 26,019 posts
  • MVP
i don't have the answer, but you're probably going to need to use a macro of some sort to do this. i don't think there's any way to do it with a formula
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP