I am trying to update an old workbook that contains 2 worksheets. sheet 1 contains client information and hours of billable services. sheet 2 is set up to look like an invoice that goes to sheet 1 to get the data to fill in the "invoice" It is a cumbersome task to go back and forth between the sheets to set up the formulas on multiple pages within sheet 2. I know a mail merge would be super easy, but the person that uses this cannot seem to understand how to link the information between excel and word.

I have 50 "pages" on sheet 2 that mimic an invoice. how do I easily get the data into each "page" without having to directly link it through sheet 1 or manually enter the formula? Essentially, I am copying data from one row in sheet 1 and entering it in various cells in sheet 2 and then repeating this with the next row of data from sheet 1 onto sheet 2.

I know nothing about macros or vba, but can learn quickly if given direction!

Any suggestions would be fabulous!


Drowning in excel!