Hai groups,
Can you tell me what is the use of $ sign excel
And can you give some examples please;;;
Thank you
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com
Hello excel and macros experts;
Can you mail some examples of excel and macros with worksheets.
Thank you
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links
$1
>
> the formula in B2 is then:
> =$A2*B$1
>
> Now, when you copy the cell formulas, the A stays the same,
> but the row changes..
>
> This is actually referred to as using ABSOLUTE references
> and Relative references.
>
> the $A is the ABSOLUTE column A.
> so w
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Deepak Rawat
Sent: Friday, January 21, 2011 7:02 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Auto Reference
My problem is, I want max amount in the last column but whenever i inse