Calculating Daily Quantities

**Bob@Sun** · 11-22-2009, 11:08 AM

Hello,

I have 3 worksheets: Income; Expense; Consolidate.

In the first two sheets i am entering, by dates, quantities that are getting in and out of the warehouse.

My code copies that information in the consolidated sheet.

What I need is to make a code that Calculates the "Daily Quantities" and "Rent", based on quantity in the warehouse, that I am paying each day.

I am attaching a sample file.

Thnans for the help!

**ConneXionLost** · 11-22-2009, 02:58 PM

Hi Bob,

This approach doesn't involve any VBA, but it does provide a solution. Hope it works for you.

Cheers,

**Bob@Sun** · 11-22-2009, 03:55 PM

That I think could work, but how do you make it " - " in the cells where there is no information?
When I do it, it shows zeros and "0-Jan" when my column with the Date is empty??

Sorry if my question sounds stupid for you, but can not figure it out

Thanks anyway, your suggestion helps me a lot

**ConneXionLost** · 11-22-2009, 03:58 PM

Not a problem Bob. Just have a look at the cell formatting (or, right-click "Format Cells...").

Cheers,

**Bob@Sun** · 11-22-2009, 04:28 PM

Well I tried to incorporate this in my original file, but it does not seem to do the righ thign.

I am attaching my orriginal file. Can you please check in the Calculaton's Sheets why this formula is not working properly?

Thanks in advance!

**ConneXionLost** · 11-22-2009, 04:34 PM

The date you have in Calculation!A3 is 1900-01-01. Change it to 2009-01-01.

Cheers,

**Bob@Sun** · 11-22-2009, 04:44 PM

You are The Man!

Thanks A lot !!!

**ConneXionLost** · 11-22-2009, 04:47 PM

Thanks Bob,

On the Calculation sheet, you also have a couple broken cell references to the Date column that need to be fixed. They're in the income and expense columns.

Cheers,