Great series, thanks for your effort in sharing. I am a Newbi with Excel.
At work, I have been struggling with preparing a multiple worksheet workbook that will use a master worksheet to populate or fill data to subsequent pages.
I have learned some methods, but the one that stumps me is: How do I pull one item (text usually, like a name or ID number) from a range of cells (list? array?) and have it placed in a specific cell on a subsequent worksheet, and have the next item in the range placed in the same cell on ANOTHER worksheet, and so on through the range. I can do it one at a time, but there has to be a faster way!
The workbook will use Master information which changes from time to time. I hope to learn some sort of autofill from a range to locations across multiple worksheets. Then I can populate the workbooks and let others, even less experience than I, have at them.
Keep Up with TechRepublic