Forum Discussion
Transferring data based on specific date
If the database were a database table rather than a worksheet name some of the referencing would be more descriptive. There is a 'gotcha' with using dates as field names though, in that they get converted to text. So, following up on Riny_van_Eekelen 's suggestions in the Excel 365 context
XLOOKUP is more concise but INDEX/XMATCH/XMATCH has the advantage of being able to return multiple columns as an array.
PeterBartholomew1 Riny_van_Eekelen
Guys first of all thank you and sorry for late reply.
I have attached the sheet again, kindly look into it.
Regards,
Kashif
You will need a VBA macro to perform such tasks. The technical reason is that worksheet formulas implement a functional programming style in which values may be read and calculations performed, but nothing that already exists may be changed. By way of contrast, VBA implements an imperative programming style that allows the state of the information held by the workbook to be changed. In particular VBA will allow you to replace data within a database table as you require.
Thank you PeterBartholomew1 & Riny_van_Eekelen
KashifRiyadh Sorry! Don't understand what you want. Perhaps PeterBartholomew1 .
