Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 19th, 2011, 10:29 AM
Authorized User
Points: 116, Level: 2
Points: 116, Level: 2 Points: 116, Level: 2 Points: 116, Level: 2
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2009
Posts: 25
Thanks: 11
Thanked 0 Times in 0 Posts
Default Help with formulas

I have a workbook which tracks maintenance issues in our building. Issues are entered on the second sheet called: Maintenace Tracking. The first sheet is a summary of issues by floor. I am having trouble with formulas in the first sheet which need to go and check two columns on the second sheet for certain criteria then give a running total of each issue.
The first sheet, titled Cover Sheet, is divided into columns by floor (two columns for each floor, one with different issues and one for how many of that issue).In the column for the second floor, in column D, first row (Camera issues),(cell D19) I need to put a formula which goes to the second sheet (Maintenance Tracking), column C and looks for all 2s (for second floor), then checks column E for the word "Camera" and tells me how many camera issues I have on the second floor.

Clear as mud? I can send you a copy of the worksheet.

Last edited by billy1r; July 21st, 2011 at 09:13 AM.. Reason: Problem solved - delete message
 
Old July 21st, 2011, 09:20 AM
Authorized User
Points: 116, Level: 2
Points: 116, Level: 2 Points: 116, Level: 2 Points: 116, Level: 2
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2009
Posts: 25
Thanks: 11
Thanked 0 Times in 0 Posts
Default

Problem solved! Thanks to all who at least looked!
 
Old July 27th, 2011, 09:14 AM
Friend of Wrox
Points: 3,060, Level: 23
Points: 3,060, Level: 23 Points: 3,060, Level: 23 Points: 3,060, Level: 23
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2005
Location: , , .
Posts: 812
Thanks: 1
Thanked 53 Times in 49 Posts
Default

Would be nice if you can post the solution here ; someone someday will require the same solution
__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)




Similar Threads
Thread Thread Starter Forum Replies Last Post
code for formulas tofimoon4 Excel VBA 16 October 28th, 2010 04:33 AM
Formulas Juan0214 Access 4 July 2nd, 2008 02:04 PM
Need help with time formulas pfreire727 Excel VBA 1 February 12th, 2006 07:41 PM
Inputbox and Formulas bahachin Excel VBA 3 February 17th, 2005 01:39 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.