LoneRanger
New Member
- Joined
- Dec 18, 2016
- Messages
- 17
Greetings,
I have multiple excel workbooks with the same sheet called "board" which contains 4 Columns and "X" number of rows depending on how many events there are. For example Sally, Jesse, James, Wanda, and Peter each have an excel workbook with a sheet called "board" . Each "board" sheet format is very similar with 4 columns with "x" number of rows depending on each one's events. Some may have from row 1 to 22 or maybe 1 to 50. What I would like to do is import each board into one excel workbook with the first Column A,B,C,D give a column space then copy the next along side of it. Ultimately creating a type of dashboard feel.
Workbook names:
Sally
Jesse
James
Wanda
Peter
I have multiple excel workbooks with the same sheet called "board" which contains 4 Columns and "X" number of rows depending on how many events there are. For example Sally, Jesse, James, Wanda, and Peter each have an excel workbook with a sheet called "board" . Each "board" sheet format is very similar with 4 columns with "x" number of rows depending on each one's events. Some may have from row 1 to 22 or maybe 1 to 50. What I would like to do is import each board into one excel workbook with the first Column A,B,C,D give a column space then copy the next along side of it. Ultimately creating a type of dashboard feel.
Workbook names:
Sally
Jesse
James
Wanda
Peter
Last edited: