user1720303
user1720303

Reputation: 9

Copy cell value to a different worksheet

I have an Excel workbook with multiple worksheets in it. Say Book1, Book2, Book3 etc. I want to copy the value of Book1 Cell D5 into Book2 Cell E3.

What is the formula for this please?

Upvotes: 0

Views: 196

Answers (1)

am304
am304

Reputation: 13876

Are you asking VBA code or simply the Excel formula? If the latter, just select cell E3 in Book2 and type =Book1!D5. If you're asking for VBA code, I don't know...

enter image description here

Upvotes: 1

Related Questions