I have a workbook with multiple sheets, each sheet is of varying length but all have the same header layout from columns A:E. I am trying to add a formula to column F that starts in cell F3. The formula written manually would be =A3=A2. I need the vba to find the last row of the worksheet using column A as a guide, then autofill the formula from cell F3 to the bottom of the data. Then I need it to move to the next worksheet and repeat this process through the rest of the work book. For some reason the Next is not working and instead of repeating the formula on the next worksheet it just stays on the first worksheet.
Thanks for the help.
Please Login or Register to view this content.
Bookmarks