Excel Macro Fill Down Multiple Columns

[Boges71]

Hi,

Desperately need help to populate an excel spreadsheet where multiple columns need to be filled, for example, need to populate columns a,b,c, based on cells above, fill example is in red. This is due to multiple comments per column a being unique id.
Need to be able to do this for thousands of rows therefore need help with VBA code PLEASE


[TABLE="class: grid, width: 500, align: left"]
<TBODY>[TR]
[TD]wo[/TD]
[TD]dept[/TD]
[TD]user[/TD]
[TD]comments[/TD]
[/TR]
[TR]
[TD]1123[/TD]
[TD]admin[/TD]
[TD]smith[/TD]
[TD]line 1[/TD]
[/TR]
[TR]
[TD]1123[/TD]
[TD]admin[/TD]
[TD]smith[/TD]
[TD]line 2[/TD]
[/TR]
[TR]
[TD]1123[/TD]
[TD]admin[/TD]
[TD]smith[/TD]
[TD]line3[/TD]
[/TR]
[TR]
[TD]1124[/TD]
[TD]finance[/TD]
[TD]jones[/TD]
[TD]line 1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]line 2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]line 3[/TD]
[/TR]
[TR]
[TD]1125[/TD]
[TD]hr[/TD]
[TD]brown[/TD]
[TD]line 1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]line 2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]line 3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]





[TABLE="width: 447"]
<TBODY>[TR]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
</TBODY><COLGROUP><COL span=3><COL></COLGROUP>[/TABLE]

 

[Peter_SSs]

Welcome to the MrExcel board!

This can certainly be done with a macro, but it's also very easy manually

1. Select the 3 columns (Click & drag across their heading labels)
2. F5 > Special... > Blanks > OK
3. Press the = sign then the up arrow and then hold Ctrl while you press Enter
4. Select the 3 columns again, Copy and Paste Special (Values)

 

[Boges71]

Thanks so so much Peter,

This solved my problem.

 

[Peter_SSs]

Thanks so so much Peter,

This solved my problem.

No problem - it's nice to see so many happy faces.