Hi Team,
I need your help. I saw your youtube videos. This is quite urgent within tomorrow
. I will explain the need.
Sheet2 has MID, Name, shift code, each row need to be copied and pasted in sheet1 in the columns and date for this month 1-30 should be autopopulated with the same data, then it should next row, copy the values into the cells in Sheet1 and auto populate the dates from Aug1-30.
Whenever we enter a row in sheet2 and run macro, it should get copied to sheet1 with dates autofilled for that month(only date).
I think that the last available column after pasting to dataset is done by relative positioning
Sheet2 has employee id, Name, shift code, each row need to be copied and pasted in sheet1 in the columns and date for this month 1-30 should be autopopulated with the same data, then it should next row, copy the values into the cells in Sheet1 and auto populate the dates from Aug1-30.
Whenever we enter a row in sheet2 and run macro, it should get copied to sheet1 with dates autofilled for that month.
Sheet 1
Emplid name shiftcode shift dates( should autopopulate for same record from 1 to 30)
Sheet 2
User enter
Emplid, name, shiftcode.
I need your help. I saw your youtube videos. This is quite urgent within tomorrow
. I will explain the need.
Sheet2 has MID, Name, shift code, each row need to be copied and pasted in sheet1 in the columns and date for this month 1-30 should be autopopulated with the same data, then it should next row, copy the values into the cells in Sheet1 and auto populate the dates from Aug1-30.
Whenever we enter a row in sheet2 and run macro, it should get copied to sheet1 with dates autofilled for that month(only date).
I think that the last available column after pasting to dataset is done by relative positioning
Sheet2 has employee id, Name, shift code, each row need to be copied and pasted in sheet1 in the columns and date for this month 1-30 should be autopopulated with the same data, then it should next row, copy the values into the cells in Sheet1 and auto populate the dates from Aug1-30.
Whenever we enter a row in sheet2 and run macro, it should get copied to sheet1 with dates autofilled for that month.
Sheet 1
Emplid name shiftcode shift dates( should autopopulate for same record from 1 to 30)
Sheet 2
User enter
Emplid, name, shiftcode.
Last edited by a moderator: