Forum Discussion
Transferring data based on specific date
Hi, I am creating a data base, but I am stuck at point where I want data to be copied to another sheet based on date. e.g. if I enter a data on 02/12/2021 then in the database sheet it should find t...
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