psychedelicat
New Member
- Joined
- Mar 22, 2011
- Messages
- 4
<TABLE border=0 cellSpacing=0 cellPadding=2 width="100%"><TBODY><TR><TD align=left>I have a Data Validation Box in Cell E7 Worksheet "Report" that references the employees numbers in I3:I80 in another worksheet "Data". I can select the employee numbers from the Data Validation box & it will populate all the rest of the info i need (something like a payslip). I would like to assign a macro to a button whereby I can print all the reports. I have tried creating a marco by recording but of cos it only records the printing of one record. Please help!</TD></TR></TBODY></TABLE><TABLE border=0 cellSpacing=0 cellPadding=2 width="100%"><TBODY><TR><TD align=left>I have a Data Validation Box in Cell E7 Worksheet "Report" that references the employees numbers in I3:I80 in another worksheet "Data". I can select the employee numbers from the Data Validation box & it will populate all the rest of the info i need (something like a payslip). I would like to assign a macro to a button whereby I can print all the reports. I have tried creating a marco by recording but of cos it only records the printing of one record. Please help!</TD></TR></TBODY></TABLE><TABLE border=0 cellSpacing=0 cellPadding=2 width="100%"><TBODY><TR><TD align=left>I have a Data Validation Box in Cell E7 Worksheet "Report" that references the employees numbers in I3:I80 in another worksheet "Data". I can select the employee numbers from the Data Validation box & it will populate all the rest of the info i need (something like a payslip). I would like to assign a macro to a button whereby I can print all the reports. I have tried creating a marco by recording but of cos it only records the printing of one record. Please help!</TD></TR></TBODY></TABLE>
