Copy Values to separate sheet, locate value in list and paste 6 cells to the left

[drknot]

cli test.xlsx

Hi

I think this is quite simple to do, but I'm stumped.

In sheet "daily" I have a list of values in cells C20:C190, In Cells A20:A190 is their tag or heading.
The list is compiled throughout the day, so at any one time the cells C20:C190 might be empty. Unfortunately they are not populated in order.

I would like to move the contents of cells C20:C190 either during the day or at the end of the day to a separate sheet which will hold the historical data.

This is called "Data" On the data sheet the tags/headings are located in column I,

I would like to loop through the daily sheet taking the value in column C, finding its header/tag from column A in the Data sheet in column I and pasting the value in column C on the data sheet.

Because people will be doing this throughout the day, if the data is already there its ok to paste over it.

I hope someone can help

Thanks in advance
Andy

[jagadeesh.rt]

Hi,

Can u please upload sample data file with ur requirement (with output as per ur requirement). For better understanding.

[jagadeesh.rt]

Hi drk,

Please try this code..........tested..

Please Login or Register  to view this content.

[AB33]

Since this is a single column return a formula will do

In sheet Data, C2 and drag it down to the bottom

Please Login or Register  to view this content.