Data to Certain Cells

[uberathlete]

Hi everyone, I really need some help. Here's the situation (please refer to the image):

Column A has dates , column B has 'data dates' and column D has data. The Ws in column B are just markers signifying that the data in column D must be in those cells that have a W.

Basically, the first data value in column D must must replace the first W in column B, the second data value in column D must replace the second W in column B and so on and so forth. I just want the data values to replace the Ws while the DATA column stays unchanged. So, in the end the result should look like this:

Is there an easy way to get this done? I guess it would require code which unfortunately isn't my strong point. Any suggestions would be much appreciated. Thanks!

 

[texasalynn]

your results didn't show??

 

[uberathlete]

your results didn't show??

Oh that was just an example. I've actually got lots of data and it's just super tedious manually inputting them on each data date.

 

[Yogi Anand]

Hi uberathlete:

Let us see if the following formula based approach works for you ...

y070716h1.xls
	A	B	C	D
1	Date	Data Dates	DataDates	DATA
2	1-Jan-00			12
3	2-Jan-00			34
4	3-Jan-00			6
5	4-Jan-00	W	12	98
6	5-Jan-00			22
7	6-Jan-00
8	7-Jan-00	W	34
9	8-Jan-00	W	6
10	9-Jan-00
11	10-Jan-00
12	11-Jan-00
13	12-Jan-00	W	98
14	13-Jan-00
15	14-Jan-00
16	15-Jan-00	W	22
Sheet12

I inserted column C and the formula in cell C2 is ...

=IF($B2="W",INDEX($D$2:$D$16,COUNTA($B$2:$B2)),"")

this formula is then copied down.

After that I can optionally hide column B.

 

[uberathlete]

Wow, thanks Yogi Anand! Appreciate it.

 

[Yogi Anand]

You Are Very Welcome uberathlete ... now let us keep EXCELing.