VBA Beginner needs help with project

**Russmeister57** · 09-04-2015, 04:07 AM

Hi All,

I've just started learning VBA as I've learned there is whole new take to Excel. At a good time really as i'm working on a little project for work, but I need something writing as there is no formula I can use for what I need.

So here goes.

I will be re-using the same workbook over and over again each week, (it's a weekly sheet)
A1:A10 are cells that can contain any of the following but only one of:
any number between 0 - 9
"H8", "H4", "H6"
"S8", "S4", "S6"
"A8", "A4", "A6"
"MAT8", "MAT4", "MAT6"

I need A13 to total all, if any, "H8", "H4", "H6" but just the number's.
A14 to total all, if any, "S8", "S4", "S6" but just the number's.
A15 to total all, if any, "A8", "A4", "A6" but just the number's.
A16 to total all, if any, "MAT8", "MAT4", "MAT6" but just the number's.

Can somebody help me with this please?

**romperstomper** · 09-04-2015, 04:53 AM

Can you post a sample workbook showing some samples of what results you'd expect for example inputs? Currently I can't see why some SUMIF formulas wouldn't do what you need.

**Russmeister57** · 09-04-2015, 05:43 AM

EXCEL FORUM.xlsx

This is an example of what I'm trying to do. Although these cells aren't always what they are now they can change to anything so I need it to pick up what is in the cell at the time.

**romperstomper** · 09-04-2015, 06:45 AM

And what results would you expect, and where, for that sample data?

**Russmeister57** · 09-04-2015, 06:55 AM

The cells in A12:16 in the sample are the results that I would like to achieve.

**romperstomper** · 09-04-2015, 07:01 AM

OK - here's one way.

**Russmeister57** · 09-04-2015, 09:45 AM

Originally Posted by romperstomper

OK - here's one way.

Unfortunatly the formulas dont work when i transfer them over to the actual spreadsheet, even though the arguememts look right and its the same principal. I just get #VALUE.

**romperstomper** · 09-04-2015, 10:11 AM

You'll need to give better sample data then, I think. Does the real data always end with one digit?

**Russmeister57** · 09-06-2015, 06:44 AM

Excel Forum 2.xlsx

Here's a sample of the sheet I'm using in the same format. I've included notes on the attachment too. Thanks for your help. I really appreciate it.

the formulas on the baove did work, now I've had chance to play about with them but there has to be a number in every single cell in the range. Is there a way modify it into maybe an IF there is a number in the cells as there sometimes isnt a number in them.

**Russmeister57** · 09-06-2015, 12:28 PM

Doesnt matter, i have made them work for me now. Thank you so much for your help i got there eventually.

VBA Beginner needs help with project

LinkBack

Thread Tools

Rate This Thread

Display

VBA Beginner needs help with project

Re: VBA Beginner needs help with project

Re: VBA Beginner needs help with project

Re: VBA Beginner needs help with project

Re: VBA Beginner needs help with project

Re: VBA Beginner needs help with project

Re: VBA Beginner needs help with project

Re: VBA Beginner needs help with project

Re: VBA Beginner needs help with project

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Generating a List of Project Parts Based on Project Duration and Time Window

spreading a project value over a number of months based on order month & project duration

[SOLVED] Function that concatenates multiple sub-project descriptions based on project code

[SOLVED] Insert Blank Rows between sorted projects, Subtotal project to the right of final project.

VBA Project and Modules Remain in Project Explorer after workbook closed

With VBA from Excel: Open Project, extract resource list and copy it to a worksheet, close project.

[SOLVED] Beginner needs help w/first work project

Bookmarks

Bookmarks

Posting Permissions