Hi,

I have some trouble creating a macro. I'm new with VBA and I want a macro that does something specific.

I have 2 workbooks (WB1 & WB2). WB1 will be the one that will record all the information that I need, while WB2 is the one in which I'll be looking for specific information.

In WB2 I have 4 worksheets. I need to find out how many times the word written in cell A3 is repeated in column A. After doing the count I need to write that word 28 times for each time it was found in column B, starting in cell B2. That is, if the word count was 1, then I should have 28 copies of the word from B2 to B29. If the word count was 2, then I should have 56 copies of the word from B2 to B57, and so on.

I really don't know how to do this and I wanted some help.

Thanks in advance.