I have 2 sheets; sheet 1 is a monthly account sheet with totals in one row and the name of the month in one cell. Sheet 2 is a summary with a row for each month with month names in the first column of each row. I want to compare the name of the month in sheet 1 with the month names in sheet 2 and then paste the total row from sheet 1 against the correct named month in sheet 2. After that I delete that month's name and figures from sheet 1 and start the new month.
Pasting the values and deleting figures to start a new month is no problem, but I need some code to compare month names and choose the correct row on sheet 2.
Any ideas really appreciated.
Pasting the values and deleting figures to start a new month is no problem, but I need some code to compare month names and choose the correct row on sheet 2.
Any ideas really appreciated.