Move specific data

[BBoyAl]

Transfer info.xlsx

Hi,

I want to transfer data to cells underlined in red on "SHEET 2" from the info on "SHEET 1"

I would like to be able to choose which row of information is populated from "SHEET 1" to "SHEET 2"

Is there a way I can type the row number into "SHEET 2" so I get the correct info when it is desired.

Other ideas welcome too.

Thanks!

[tigertiger]

I thinks, you should post attached sample file to more elaborate, thanks

[tigertiger]

Attachment 179301
Is there a way I can type the row number into "SHEET 2" so I get the correct info when it is desired.
Thanks!

Sorry, I haven't seen your attached file, I downloaded it

------------
In sheet2:
Pls, typing the values:
at C2: "NO"
at D2: 3 (the value of "NO")
--------

at D4 you can use the bellow formula:
=VLOOKUP($D$2,Sheet1!$A$4:$F$10,MATCH(Sheet2!C4,Sheet1!$A$3:$F$3,0),0)

then you copy the formula for D6,D8,D10,D12
---------

now you can change the NO at D2

is it that you need?

[BBoyAl]

That seems to work very well thanks.

The spreadsheet I will need to us this for will be quite large and there will be more data to transfer. I guess the principle will be the same so hopefully I will be able to work it out.

Regards,

[BBoyAl]

Attachment 179324

I keep trying to use bits of the formula from tigertiger to populate the required fields but I am really struggling to get it to work. I think what I am trying to do is more complicated than my original post.

Unfortunately I am not very experienced with Excel. I am not sure what to do.

I am trying to populate the cells on the "Referral Sheet" and "Profit Sheet" tabs from the data I have in the "Sales Data" tab. The cells I need to populate are underlined in red.

The cells must be able to populate any chosen row of information from the "Sales Data" tab.


Any help is greatly appreciated.

[tigertiger]

Plz see the attach file,

pay attention to read my cell comments in the file

You can use the same formula's C4 cell for all cells needed caculating

[BBoyAl]

That is very clever. Only had a quick look but I think I'll be able to work the rest out.

I'll let you know how I get on!

Thanks !!

[BBoyAl]

Data Transfer 2_rev.xlsx

I have tried to add a formula to the cell on the Profit Sheet (I2) that determines what info populates from the Sales Sheet.

It is not working as I hoped.

I would like to be able to put a "tick" sign into any cell in "Sales Data" Column "A" and it to return the deal number that is in Column "B" to "I2" on the Profit Sheet.


If anyone knows how to achieve this it would be great to learn how.

[tigertiger]

At Cell I2 at sheet "Profit Sheet" you use the following formula

=INDEX('Sales Data'!$B$4:$B$11,'Sales Data'!A4)