CODEWITHSUNDEEP
excel
comkalp
comkalp

Reputation: 63

Matching of cells in excel

It Sum of columns is storing in one cell and if I want the same answer to be printed in another cell, what is the formula to get this?

Upvotes: 0

Views: 98

Answers (2)

Subhash Dike
Subhash Dike

Reputation: 1891

Let's say your sum is stored in B1 and you want same in C1 then you can do

=B1

inside C1 cell

Upvotes: 1

das_weezul
das_weezul

Reputation: 6142

Let's say you want the value of cell A1 in cell B1. You would use this formula in B1:

= A1

In code you would write something like this (example in VBA):

Dim sht as Worksheet
Set sht = ThisWorkbook.Worksheets("MySheet") //Or whatever your target sheet is
sht.Range("B1").Formula = "=" & sht.Range("A1").Address

Upvotes: 1

Related Questions