Link to home
Start Free TrialLog in
Avatar of Kevin G
Kevin G

asked on

Formula to copy cells form one sheet to another?

Hello,

I would like to know a formula that allows a cell to be copied if the cell from another sheet has a value or text and if there's a cell next to it that also has a value or text. For example:

If A1 in sheet 2 AND 12 have a text or value then copy A1 from Sheet 2 to A1 from Sheet1.

I would also want one that if there's a value from A1 in sheet 2 but nothing on B1 then to copy cell A1 from sheet 2 to C1 from sheet 1. I've attached an excel file with an example.

It looks complicated so thank you for any help given.
HELP.xlsx
Avatar of Ramin
Ramin

If A1 in sheet 2 AND 12 have a text or value .

And 12 ?    I didn't get it. something is missing,
Avatar of Kevin G

ASKER

Sorry it's and B1
Does it need to be a formula? Would a macro work?
ASKER CERTIFIED SOLUTION
Avatar of Ejgil Hedegaard
Ejgil Hedegaard
Flag of Denmark 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 Kevin G

ASKER

Thank you!!! This works