Link to home
Start Free TrialLog in
Avatar of cpatte7372
cpatte7372Flag for United Kingdom of Great Britain and Northern Ireland

asked on

Excel Copy and Paste from sheet

Hello Experts,

Hope you're all well. Before I ask a question, I just want to say this is the best subscription I've ever paid for.

Anyway, can someone please help me compile a macro/program that will allow me to copy and paste from one sheet to another.

Let me explain, in the attached I have two sheets. In sheet one, column B, I would like to copy and paste the information from sheet 2 column A in one keystroke into sheet one column B.

Now, I know you're probably thinking why don't I just copy and paste it myself! However, if you understood how many times I need to do this you would understand why I'm asking for your help with this.

As always, thank you.

Carlton
copyandpaste.xlsm
Avatar of andreibutu
andreibutu
Flag of Romania image

Hello,

You could simply insert a formula in colum b sheet 1, like this:
in cell 2:
='sheet 2'!A2

and this will automatically put your data from sheet 2 column A in sheet 1 column B.
And you can drag the function for the entire column.
Hope this helps you
ASKER CERTIFIED SOLUTION
Avatar of SiddharthRout
SiddharthRout
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of cpatte7372

ASKER

Brilliant mate.....