Cell offset?

[Dibbley247]

I'm looking for a macro that will copy from "Sheet 1 Range E5" and paste it into "sheet 2 Range B?" I would like to start from B3 check it's clear and paste into there, then the following week, if B3 has a figure then paste into B4 then the following week into B5 etc.

I've heard of cell off set, so googled it, but it's not making much sense for what I have found.

This entire column of B will end up being Weeks 1-52 but I'd like to start at around B3 if possible due to headers and title?

This macro will run in between lines of other macro as a module.

[Norie]

This code will copy E5 from Sheet1 to the first empty row of column B in Sheet2.

Please Login or Register  to view this content.

[Dibbley247]

Brilliant, i'll give it a try!!!!!

[Norie]

If you just want the value from E5 and not the formula.

Please Login or Register  to view this content.

[Dibbley247]

Thanks, that's exactly what I needed!!!!!!!!