EXCEL DATA.jpg
i need help in Macro for date and time in rows of workbook
Workbook contain 12 sheets Having Names Of Months
like Sheet 1 = January
Sheet 2 = February
Sheet 12 = December
every sheet contains its date like January have 31 days that means Row will be 31 and so on
Auto Generation of Workbook of relative Year like 2019 is the workbook then auto generation of months in the work book sheet and auto generation of Days in relative month sheets
after this when i fetch the data thru vba it should validate the system date and time and nd copy the data according to the system date and time the data will be fetch and placed in its position like if i have schedule task to fetch a data everyday at 7 am then rows of sheet containing date must concatenate with running time schedule task
example if data called on 1st september 2019 then work book of name with 2019 will open and then sheet with name of Sept should open and then in row with date 1 where data will be placed and having date 1 in cell the time will concatenate with 1 showing calling date and time
Bookmarks