PuntingJawa
Board Regular
- Joined
- Feb 25, 2021
- Messages
- 140
- Office Version
- 365
- 2019
- Platform
- Windows
I'm trying to make Excel be able to print multiple pages at the same time after populating a column by a quantity of 4 to another sheet. I managed to make this work with one sheet at a time but I would like to create a mass list and have it print multiple pages at once based on the data from another sheet. Example of what I am trying below.
Columns A,B.C,D: Each had it's list unique ID (or data).
Columns F,G,H,I: Takes 4 rows from column A to F, B to G, C to H, D to I and populates them into 1 cell, then separates with a comma and space. (Example: A1:A4 rows are 1 2 3 4, but looks like "1, 2, 3, 4" in cell F1
Column's F,G.H,I's data is mirrored to another sheet for print. This is where my problem leads. I cannot for the life of me make it print more than the first string of 4.
Columns A,B.C,D: Each had it's list unique ID (or data).
Columns F,G,H,I: Takes 4 rows from column A to F, B to G, C to H, D to I and populates them into 1 cell, then separates with a comma and space. (Example: A1:A4 rows are 1 2 3 4, but looks like "1, 2, 3, 4" in cell F1
Column's F,G.H,I's data is mirrored to another sheet for print. This is where my problem leads. I cannot for the life of me make it print more than the first string of 4.
R211 OP CRATE PRINT.xlsx | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | ||||||||||||
2 | ||||||||||||
3 | ||||||||||||
4 | ||||||||||||
5 | ||||||||||||
6 | ||||||||||||
7 | ||||||||||||
8 | ||||||||||||
9 | ||||||||||||
10 | ||||||||||||
11 | ||||||||||||
12 | ||||||||||||
13 | ||||||||||||
14 | ||||||||||||
15 | ||||||||||||
16 | ||||||||||||
17 | ||||||||||||
18 | ||||||||||||
19 | ||||||||||||
20 | ||||||||||||
21 | ||||||||||||
22 | ||||||||||||
DOOR CRATE PRINT |