RE: $$Excel-Macros$$ Please help

2011-01-29 Thread D M Sukumar
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

RE: $$Excel-Macros$$ Subtotal

2011-01-29 Thread D M Sukumar
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

RE: $$Excel-Macros$$ Please help

2011-02-01 Thread D M Sukumar
$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

RE: $$Excel-Macros$$ Auto Reference

2011-10-27 Thread D M Sukumar
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