So I'm sure I'm not the first person to need something like this, but I'm having a lot of trouble locating how to complete this action.
I have a workbook with 2 worksheets, one is a table
Date | Name | Account| Department|
The other is more like a form (formatted)
Date: Name:
Account:
Department:
I'm looking to take multiple rows of data from the first worksheet and have them print as seperate sheets in the format of the second worksheet. (Kind of like a mail merge)
It is all contained within excel (I wish I could use Access, I could have had it done already) but excel is the way my superiors would like to go.
I'm guessing I will need to use VBA, any help is appreciated.
Red
I have a workbook with 2 worksheets, one is a table
Date | Name | Account| Department|
The other is more like a form (formatted)
Date: Name:
Account:
Department:
I'm looking to take multiple rows of data from the first worksheet and have them print as seperate sheets in the format of the second worksheet. (Kind of like a mail merge)
It is all contained within excel (I wish I could use Access, I could have had it done already) but excel is the way my superiors would like to go.
I'm guessing I will need to use VBA, any help is appreciated.
Red
