Jan
I have a table in excel with customer orders. I have created macros which can add customers, along with their orders. I need to create a macro that creates a row of totals just below the last customer. This macro must run properly regardless of how many entries are added to the database. [Hint: You will have to think about how to use relative referencing to add up to the newest customer and make sure that you do not leave out any customer.]
The first customer's order is fixed on row A16 but each time I use relative referencing it will get all of the new customers but then leave out the old one. How do I use relative referencing and have a cell fixed at the same time?
Answer:
Could you use =sum(A:A)? This will sum the entire column no matter how many entries you have.
Otherwise, can you modify your current macro to nail down the top with A$16, then keep a relative reference for the bottom?
Book Mark it-> del.icio.us | Reddit | Slashdot | Digg | Facebook | Technorati | Google | StumbleUpon | Window Live | Tailrank | Furl | Netscape | Yahoo | BlinkList