hefferwolfe
New member
- Joined
- Nov 22, 2014
- Messages
- 1
- Reaction score
- 0
- Points
- 0
Hello,
I`ve attached my spreadsheet into the link to make it more understandable.
So, I have two Excel documents. I would like to print all Column A cells one by another to B-Master file, then I would like to print the text that is written in B2 cells in each tab. I did the first part, only printing text left.
So, if we assume that data has 3 A in Column A and text Apple in Tab1-B2 cell, 3 S in Column A in Tab2 and Text Banana in Tab2 -B2 cell Also, the tabs numbers are not certain so it should be capable of taking a look at every single tabs like that.
so that it should be like that at the end in my B-Master file.
A Apple
A Apple
A Apple
S Banana
S Banana
S Banana
I would be really really glad if someone could help me. Please take a look at Result tab in data.xlsx to see what I exactly want.
I`ve attached my spreadsheet into the link to make it more understandable.
So, I have two Excel documents. I would like to print all Column A cells one by another to B-Master file, then I would like to print the text that is written in B2 cells in each tab. I did the first part, only printing text left.
So, if we assume that data has 3 A in Column A and text Apple in Tab1-B2 cell, 3 S in Column A in Tab2 and Text Banana in Tab2 -B2 cell Also, the tabs numbers are not certain so it should be capable of taking a look at every single tabs like that.
so that it should be like that at the end in my B-Master file.
A Apple
A Apple
A Apple
S Banana
S Banana
S Banana
I would be really really glad if someone could help me. Please take a look at Result tab in data.xlsx to see what I exactly want.