pomptonian
New Member
- Joined
- Aug 17, 2011
- Messages
- 1
Hi All,
i have a spreadsheet that is setup to print the two left most columns. In rows 3 and 5, it is pulling in data from a different worksheet in the same workbook. the data in row 3 are employee names, and the data in row 5 are employee locations. whenever the data in row 5 changes, e.g. a new location, I would like a new page to print from that point on until the data changes again. for example, columns c thorugh j might have location 1234, columns k through o might have location 2345 and columns p through u might have 3456. whenever the data changes in row 5, the location code, a new page should print. this way all employee in the same location would print together on the same page and the next range of employees will print on another page. any help would be appreciated.
i have a spreadsheet that is setup to print the two left most columns. In rows 3 and 5, it is pulling in data from a different worksheet in the same workbook. the data in row 3 are employee names, and the data in row 5 are employee locations. whenever the data in row 5 changes, e.g. a new location, I would like a new page to print from that point on until the data changes again. for example, columns c thorugh j might have location 1234, columns k through o might have location 2345 and columns p through u might have 3456. whenever the data changes in row 5, the location code, a new page should print. this way all employee in the same location would print together on the same page and the next range of employees will print on another page. any help would be appreciated.
