I'm looking for some help from all you Excel/VBA experts out there... This is above my excel knowledge...
I have attached my file and a screenshot to help facilitate the explanation of what I am trying to acomplish.
Excel Screenshot.jpg
The data in the list is a manually entered example of how I would like it to end up, automatically.
The pale yellow shaded cells are the only ones where data will be changed manually.
Cell B:4 is the key data for Column B
Cell C:4 is the key data for Column C
Cell E:4 is the key data for Column E
The pale yellow shaded cells in Column J should determine how many rows of that dataset type will be created in the list which would include the text of Column H of the same row being added to the D cell of each of the rows created.
Looking at the example you can see what I mean....
Thank you...... and I really mean that.... thank you for any help you can give me.
Bookmarks