Word count and paste

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.

With some tweaking, this code should work. We would need more details, specifically the name of each workbook. If you can't adapt it, post back and we can help you through.

Please Login or Register  to view this content.

I forgot! The word found in WB2 must be copied to WB1 Sheet 2 Column B2 to B29, and so on.