CODEWITHSUNDEEP
excelformula
Alfred Hitchkock
Alfred Hitchkock

Reputation: 365

How to copy and Paste a formula driven cell to another cell as values in Excel

I have an excel sheet where "Sheet1.A3=Sheet2.A1"

Here i want to copy the Sheet1.A3 to Sheet3.A1 as a Paste Special Value.

Do anyone knows excel formula (not VBA code) to perform the action?

Upvotes: 0

Views: 2559

Answers (1)

p._phidot_
p._phidot_

Reputation: 1950

Based on your " i want this cell to copy and paste the 12345 to Sheet3.A1 as values" statement.. I just would like to clarify.. If you target the (12345) value to be 'filled' in Sheet3.A1 , then you should put the formula in Sheet3.A1 . You cannot put a formula in Sheet1.A3 that 'make' Sheet3.A1 cell value change.

Just put the =Sheet1!A3 formula in Sheet3!A1 will do what you need.

Hope it helps.

Upvotes: 1

Related Questions