Copy one value from a particular position into a varying number of cells & repeat

[wifi]

In essence, I would like to change this:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

"1", "2", "3", "4" are just column numbers. They are not present in the actual spreadsheet.

Each dot represents a piece of data that must be kept as is. "A", "B", and "C" are the same across the entire spreadsheet and are present 2 rows below the V value in every case. The V1, V2, V3, etc. are all different from each other. The V values are just text and spaces, no numbers. Notice that there are 2 blank rows between the end of a V series and the beginning of another. There is only 1 blank row between the V value and "A", "B", and "C". The dot values in Column 2 are dates (formatted as text) in the form of "Aug. 1", "Sep. 10", "Oct. 20", "Nov. 30", etc. You may find that helpful.

I essentially just want to copy the V value from its cell in Column 2 into the cells and rows in Column 1 in which there are dots. There's about 300 V values. The number of rows within a V series is not constant, but is generally close to 10.

[xladept]

Hi WiFi,

Try:

Please Login or Register  to view this content.

[wifi]

That does not work. The error message is:

Please Login or Register  to view this content.

The debug message points to this line:

Please Login or Register  to view this content.

Please keep in mind that the V1, V2, etc. aren't actually "V1", "V2", etc. They're actually a bit of text that varies in name (i.e. "Apple Pie", "Car Maker", "Laptop", etc.). Deleting the "V" from "V*" in your code causes the same error to be thrown.

[TMS]

Cross-posted here: http://www.mrexcel.com/forum/excel-q...ls-repeat.html

[kalak]

answer to OP post, try

Please Login or Register  to view this content.

[xladept]

@ wifi - so, what is true in your example??

[stanleydgromjr]

A message to forum cross posters

Please read this:
http://www.excelguru.ca/node/7

[wifi]

answer to OP post, try

Please Login or Register  to view this content.

This solution works perfectly for me!

[wifi]

@ wifi - so, what is true in your example??

I'm not quite sure what you mean. But, regardless, a solution has been found.

[kalak]

Thanks for the feedback.

That solution relies on there being at least one space between each V* (or whatever is there) and the next A (or whatever that is) and also at least one space between the bottom dot in Col B in each group and the next V.
If these spaces are not there then the code won't work.

[xladept]

@kalak - thanks for the description!