# how to calculate 2 column of numbers?

1. ## how to calculate 2 column of numbers?

- 2 worksheets

1) 2 column of numbers(maybe 50) on 1 worksheet

2) would like the left column to substract right column and have the output in the other worksheet.  Register To Reply

2. ## Re: how to calculate 2 column of numbers?

Put a formula in the first sheet doing the calculation want need
Move (Control + x) the column with calculation to the second sheet  Register To Reply

3. ## Re: how to calculate 2 column of numbers?

sorry that i did not mention, I intend to macro it.  Register To Reply

4. ## Re: how to calculate 2 column of numbers?

Does this help? ``Please Login or Register  to view this content.``  Register To Reply

5. ## Re: how to calculate 2 column of numbers?

commended!

thanks, what does the (3)(2) in ``Please Login or Register  to view this content.``
means?  Register To Reply

6. ## Re: how to calculate 2 column of numbers?

End(3) - same as End(xlUp)
(2) is a row offset for the last cell in the column without data.

Entire statement End(3)(2) same as End(xlUp).Offset(1)  Register To Reply

7. ## Re: how to calculate 2 column of numbers?

didnt know .offset can be done without the offset method. thanks alot!  Register To Reply