formula needed

[kylefoley76]

I need a macro where if a 1 appears in column B, the copy what is in column A into the next blank column in column C.

Note: a 1 in column B will appear sporadically but in column C I need each row to be filled one after the other. So in column B many rows will be empty but no rows in column C will be empty.
Thanks in advance.

 

[kylefoley76]

ok i got it to work. i changed this file to

thisFile = "charts.xlsm"

plus there was a column that was messed up, but i fixed it