VBA Macro to Insert Rows into All Visible Sheets

  • Hello, I hope someone can help me with my code. I have a workbook that splits data from a Main worksheet into multiple worksheets based on the data in column A. After that macro runs, I'm trying to take data from another sheet and copy/paste into all the sheets I just created that contains a "key" to the data in each worksheet. For some reason it copies the rows, but won't paste onto the other worksheets. I'm new at this, and am cobbling this together bit by bit.

  • Hello VA,

    Are you looking at copy/pasting rows 1-13 from sheet37 (assume this is the sheet code) to all the other sheets starting at A1? If so, try the code amended as follows:-

    You'll need to change Sheet37 to the actual name of your source sheet.

    I hope that this helps.



Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!