Hi @ LibreOffice
I have a workbook in which I want to copy the data from a column in sheet1 to another column in sheet2 in the same workbook.
The column in the first sheet is updated weekly (Saturday) from the internet and is headed with todays Date and constitutes a series of 23 prices going down the column
The second sheet has a series of columns, again headed by dates and a new column is added each week as a copy from the column in Sheet1 every Saturday.
The data in Sheet2 is Dynamic in that each week the column into which data (23 prices) is being copied changes ie it moves one to the right of the previous column.
I am somewhat new to formulae but I want to know how to link the two Sheets in a way that copies 23 prices from a column in sheet one to a column in Sheet2 but which the following weeking moves to another column to the right ie a later date every week.
I would prefer this by formula than Macro.
Thankyou for your help
Terry