Excel Spreadsheet Question

V

VegasBurger

First, thank you for reading this post and any insight I might receive
following this post.

I am currently working on a spreadsheet where users will input figures on a
monthly basis from a P&L worksheet. I am looking for a way to make it easier
for users to move the figures from the previous month into a new column so
those figures can be compared to the new month.

Currently, users input the new month's information into Column C but I would
like a macro or something for the users to click and it will move that
information in Column C into Column D and clear Column C.

Hope that makes sense?!?
 
S

StumpedAgain

How's this?

Columns("C").Copy Destination:=Columns("D")
Columns("C").ClearContents
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top