Hi,
First, my apologies if anything I write is unclear or if I have not provided sufficient information. I almost never have the opportunity to work with vba, so when I do get to play around with it once or twice every year or two, I come at it as an absolute newb.
My question (with some details):
I copied some vba from a previous macro that splits data from a table in one sheet onto several sheets based on contents in cells of one of the columns in the original sheet. In other words, if there are three unique strings in column E, then my macro creates three new sheets with names that match the unique strings in column E in the original table, and then it copies rows of data from the original table that contain each unique string, and pastes those rows into the corresponding new sheet. This code is working perfectly (even thought I don't understand how it all works).
What I want to happen next is, on each of the newly created sheets, I want to count the number of unique strings in column B, then insert that number of blank rows + 5 at the top of the sheet. In other words, if there are 5 unique strings in column B, then I want to insert 10 blank rows at the top of the sheet. I don't know if it matters, but the new sheets will always start at the 4th sheet (first three sheets are fixed, and will always be present). Possible names of the new sheets are, "ICO RWE", "ICO RWE-RSH", "ICO RSH", "ICR SSU", and "ICR MED", but not all sheets will always be present. For example, one workbook might only have "ICO RWE" and "ICO RSH".
Any and all help is greatly appreciated. Please let me know if more details are needed.
Thank you!
Carlos
Edit: I have not received a response to this question, so I cross-posted here: Chandoo
Ha! This site instructs users that if they cross-post, they should provide links to the cross-post, BUT I CAN'T DO IT, because excelforum will not let me post links due to my current low post count.
Can someone explain why cross-posting is strongly discouraged? Why is it a problem? In life, isn't it smart to look for information/answers from multiple sources, and then choose which works best for you? Also to learn which sources are best for your personal needs? Please don't tell me this anti cross-posting thing is about hurt feelings! I mean, I completely understand why we shouldn't post the same question across different parts of the same forum, but why not on different forums!?! I'm looking for an honest answer, as I would like to understand, and know if I am missing something, or looking at things wrong. Thanks.
Bookmarks