moving cells to a cell based on value

[RCBricker]

Ok I goofed. I created a template and processed my data. I found that Part of my template is not where it needs to be on all 200 of my sheets.

I need to copy the cells in K (where ever they are for that particular sheet) and move them to a sheet based on a value in column B. The value is repeated only once on each sheet (section header).

Currently I am cutting and pasting for each sheet. Need report to be completed faster than that. I can macro cut and paste, but not based on a value of a cell.

Any suggestions?

Thanks in advance

Rich

 

[RCBricker]

OK no hits.

I am thinking that I could use something that will place in cell K# data if B# (cell is 5 rows below K#) is Cycle 15.

So if B5 is equal to cycle 15, Then K10 needs to have "Outstanding amount", K11 & K12 need to have "P&I Due", K22 would need to have "Current Due" and finally K24 would need "Prior Interest".

I guess my main problem here is that B# could be any where in B:B, and The data in K:K needs to start 5 rows below B equal to the values and distance described above. I can write a macro to find K and cut it and paste it, but not by basing it on B#.

I hope this makes it clearer and that someone can help.

Thanks

Rich