Need MACRO to copy the text in the cell left of first selected cells (a column), paste all

Hi Experts,

I am trying to automate my cut and paste operation for a document in excel format.

I need a MACRO that will copy the text in the cell to the left of first selected cells (a column), paste this text value into all the selected cells.

So, what i am trying to do is this ...

a. Select a column of cells, eg: B1 to B4
b. Press some shortcut to trigger the MACRO
c. Macro will copy the text in cell A1 (to the left of B1), paste this text value into all the selected cells in step a, ie: from cells B1 to B4.

That's it for now.

Thank you.

Hi,

Insert this code into a module, then use the macros menu on the developer tab on the Excel 2007 ribbon to assign a shortcut key to trigger the macro.

Please Login or Register  to view this content.

Hope this helps

Thank you Richard, this worked too.

Originally Posted by Richard Buttrey

Hi,

Put this Procedure in a Module and attach it to any button or shape object, (right click the object and choose 'Assign Macro), or assign a shortcut key to it. On the Ribbon: Developer...Macros...select the macro name..choose Options and add the key of your choise

Please Login or Register  to view this content.

You're welcome

Please don't forget to mark this thread as solved and click on the star next to my post and Richard's post to say thanks.

Have a great day

I was trying to do both things you mentioned but could not find the buttons to do that ! May be it's because it's Friday.

Pls advise, or do i need to post or that? LOL.

Originally Posted by ajryan88

You're welcome

Please don't forget to mark this thread as solved and click on the star next to my post and Richard's post to say thanks.

Have a great day

Lol.

The star is just beneath each person's post, where it says "Add Reputation", and to mark a thread as solved go to the first post in the thread and click Thread Tools --> Mark Thread as Solved.

Done. Thanks again.

Originally Posted by ajryan88

Lol.

The star is just beneath each person's post, where it says "Add Reputation", and to mark a thread as solved go to the first post in the thread and click Thread Tools --> Mark Thread as Solved.

Thanks.

You're welcome