Menu

Add to a cell if a row has a date and a column has a department

Search this Thread

Prev

Previous Post

Next Post

Next

#3

Report Post

Posted to microsoft.public.excel.programming

Toppers

Toppers is offline

external usenet poster

Posts: 4,339

Default

Add to a cell if a row has a date and a column has a department

Craig,
Attachments not allowed so can you post to
.

Your post seems to suggest only 11 months of data Cols 8 to 18) but no doubt
your attachment will clarify all.

"Craigm" wrote:

From another worksheet I want to total miles driven by department. A
pivot table won't work for me here. I need to code this. A sample
worksheet is attached.

Column 1 is departments (not sorted, one row for each driver). Columns
8 through 18 hold miles driven each month by each driver. Every driver
gets one row, starting in row 8.

Row 5 holds the date of the last day of the quarter, there are 3
quarters of data and the number of columns grows by one each month.
The first quarter end date is in Cells(5, 9). Currently the last
quarters date is in Cells(5, 18). So above each coulmn of monthly of
miles driven is the quarter end date in row 5 of the same column.

Rows 8 through 500 hold miles driven by each driver. Each row holds
the 9 quarters of miles driven by each driver. The first available
monthly miles driven data is cell(8,9). The last monthly miles driven
for each driver is (8, 18)

From another worksheet in the same workbook I want to total miles
driven by department.

I am in for..next, select..case hell and the gray cells have died!

Thanks for your help! Craigm

--
Craigm
------------------------------------------------------------------------
Craigm's Profile: http://www.excelforum.com/member.php...o&userid=24381
View this thread: http://www.excelforum.com/showthread...hreadid=393434

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Bar chart by division, department, region date	Stephanie	Charts and Charting in Excel	1	March 20th 09 08:48 AM
Automating Department Payroll	Howard R	Excel Discussion (Misc queries)	4	March 5th 07 01:07 PM
Need the formula or macro. If i enter today date in the cell (Row 1,Column 2) and on tab out, the column 1 cell should be filled with "corresponding Day" of the date	kakasay	Excel Discussion (Misc queries)	1	January 22nd 07 12:31 PM
Need Formula or macro. If i enter today date in the cell (Row 1,Column 2) and on tab out, the column 1 cell should be filled with "corresponding Day" of the date	kakasay	Excel Discussion (Misc queries)	1	January 22nd 07 12:31 PM
How to use Macro throughout Department	Dave Peterson[_5_]	Excel Programming	0	March 22nd 05 12:16 AM

All times are GMT +1. The time now is 02:57 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement