$$Excel-Macros$$ trouble with multiple formulas

Can anyone provide me the formula/s for below query? I have four columns. Company, Product, Date and Weight. What I need to do is add up the monthly volumes per Customer/Product for each month. I have over 170,000 records that I need to sort. I've tried multiple formulas but I can't seem to work it

RE: $$Excel-Macros$$ using variables as part of a "sum" function?

Hi, I haven't tested this, but it's probably: Cells(i, 14) = "=sum(RC[-" & x & "1]:RC[-" & y & "9])" Regards - Dave. > Date: Mon, 26 Jul 2010 20:09:45 -0700 > Subject: $$Excel-Macros$$ using variables as part of a "sum" function? > From: carlo.bitu...@gmail.com > To: excel-macros@googl

$$Excel-Macros$$ using variables as part of a "sum" function?

Hi, this from a complete Excel VBA novice For i = 1 To 10 Cells(i, 14) = "=sum(RC[-1]:RC[-9])" Next i The above code snippet works, using the colums 1 and 9. Question: how would I use a variable instead of 1 and 9, e.g. Cells(i, 14) = "=sum(RC[-x]:RC[-y])" --

RE: $$Excel-Macros$$ Making sheet references dynamic

Hi, Not quite sure if I fully understand your needs, but have a look at the attached and let me know if it suites or not. Regards - Dave. > Date: Mon, 26 Jul 2010 10:26:56 -0700 > Subject: $$Excel-Macros$$ Making sheet references dynamic > From: ejax...@gmail.com > To: excel-macros@googlegrou

Re: $$Excel-Macros$$ Need list style from data

Give me sample file with few rows Thanks & Regards Sandeep On Mon, Jul 26, 2010 at 8:01 PM, Nadine S wrote: > Can you help me again?  I've loaded all my data and I have 3549 rows and > columns A-Y.  All column headers are the same except Col Y = Adjustment. > When I try to run the second macro i

Re: $$Excel-Macros$$ Making sheet references dynamic

try thinking like music pages of sheetsor sheets of pagesthere will be timing loops On Mon, Jul 26, 2010 at 5:26 PM, Edgar wrote: > Hi Everyone, > > Does anyone know how to make sheet references in an equation dynamic. > Specifically, I want to list the names of a series of sheets in

$$Excel-Macros$$ Making sheet references dynamic

Hi Everyone, Does anyone know how to make sheet references in an equation dynamic. Specifically, I want to list the names of a series of sheets in a column, the have an equation look up the sheet name so that the sheet it looks up changes as the cell reference changes. It should be doable, but I

Re: $$Excel-Macros$$ Need list style from data

Can you help me again?  I've loaded all my data and I have 3549 rows and columns A-Y.  All column headers are the same except Col Y = Adjustment.  When I try to run the second macro it doesn't work.  I don't know how to debug it. Thanks. Nadine From: Sandeep K

$$Excel-Macros$$ VBA macro to open web page then enter phonenumber and submit

Hi, I need to open an internal webpage after a phone number is entered into a spreadsheet then submit these details on the webpage and the result is paste on the spreadsheet. Is there a way of doing this? Thanks in advance! Manoj Kumar -- M.K.V --- "The state of your life is nothing more than

Re: $$Excel-Macros$$ How to ADD product of two columns in a single cell

good On Thu, Jul 22, 2010 at 10:27 PM, Harmeet Singh wrote: > Hi There, > > See attached file. > > > > Warm Regards, > > Harmeet Singh > IT Analyst > McKinsey & Company > http://www.facebook.com/Harmeeet > > > On Thu, Jul 22, 2010 at 11:42 AM, Rave Patwal wrote: > >> Please help to add the produ