Hi,
Apologies for a repeated question - I've found a bunch of similar questions, but I don't have solid enough VBA skills to be able to adapt to my specific query.
I have a single row summary table (TABLE 1), populated after various values are input across a related table (TABLE 2). Column A on TABLE 1 is a manually input date and various values go in columns B-H.
There are then separate tabs for each month. Each tab has a table the same as TABLE 1, except is has a row for each day of the month.
I need a macro that will copy values from TABLE 1 to the row corresponding with the date currently on TABLE 1, on the relevant month tab, and then leave it unchanged when a new date is input on TABLE 1 and the macro is run again.
Appreciate any help, thanks.
Apologies for a repeated question - I've found a bunch of similar questions, but I don't have solid enough VBA skills to be able to adapt to my specific query.
I have a single row summary table (TABLE 1), populated after various values are input across a related table (TABLE 2). Column A on TABLE 1 is a manually input date and various values go in columns B-H.
There are then separate tabs for each month. Each tab has a table the same as TABLE 1, except is has a row for each day of the month.
I need a macro that will copy values from TABLE 1 to the row corresponding with the date currently on TABLE 1, on the relevant month tab, and then leave it unchanged when a new date is input on TABLE 1 and the macro is run again.
Appreciate any help, thanks.