Moving data from one cell to another

[lpalomo]

I generated a report and would like to move the data from one cell to another.

I have data in Column J3 and would like to move it to K2. Please advise. Thanks.

-- removed inline image ---

 

[lpalomo]

Would like to use a formula and not cut and paste.

 

[Smitty]

Welcome to the Board!

Your image didn't come through (for me anyway).

Unfortunately, formulas can't perform physical actions, so if you need the information physically moved from cell to cell you'll need VBA. But that can be done.

As for posting an example, follow the MrExcel HTML Maker link in my sig.