Copy from Dynamic column cell value to Static cell

[Vijayarc]

Hi Team,
As per my attached sheet,the columns are dynamic, adding one column on daily basis when button click
i want the dynamic data to save to next sheet on fixed cell
for example: dynamic cell value :BE3 should save on sheet2 on B2 static cell
:BE4 cell should save on sheet2 on B3 static cell ...........so on

please help!!!! thanks in Advance

 

[Luke M]

Looks like you just want to grab the last number from each row. A quick LOOKUP function will be your best route. In B3 of Sheet2, put this formula:
=LOOKUP(9E99, 'Sheet1'!3:3)

In B4, something similar:
=LOOKUP(9E99, 'Sheet1'!4:4)

In D3
=LOOKUP(9E99, 'Sheet1'!11:11)

etc.

 

[Vijayarc]

Thanks Luke, u solved in simple Lookup.
wowww... Thanks for Help!!!!!!!!