Posts by Freddyfroo

Quote from Haseeb A

Hello Freddy,

Try:

=SUMIFS(E$4:E$6,C$4:C$6,"<="&H4,D$4:D$6,">="&H4)

Absolutely bang on Haseeb - appreciate that so much.

Good Morning, I am really scratching my head here with a formula I need to summarise numbers of resource demand per day from a schedule with start and finish dates. I have attached an example excel document - I hope someone can help me?.

In table 1 I have a schedule to Resource, Start Date and finish date then qty. In table 2 I simply want it to create running totals per day - I hope it pretty self explanatory?.

Thanks a lot in advance.

Roy - absolutely nailed it, exactly what I require.
Thanks a lot, very much appreciated.

Basically, when a new sheet (time sheet) has been created and the summary tab is poplulated all using the code you provided, I may have to go back and update a newly created time sheet that subsequently will need to update the corresponding record of it in the summary tab. Does that make sense?

Mumps - sorry for the late reply, that's excellent and worked a treat. Thank you very much.

Is there a simple code that enables any given worksheet to be updated and subsequently updated in the summary tab? No biggie as this scenario wouldn't really happen very often but thought I would ask the question.

Again many thanks indeed.

Hi, I hope someone can help me.

I have created a very simple timesheet template on a worksheet and have used some code that copies this worksheet (named 'Template') and renames it with the week commencing date. What I want though is once submitted I want the new data to be added to a summary table on a separate worksheet named 'summary'. I have attached the document, I think the requirements are pretty evident from this. Thanks a lot

Re: Sumifs to sum qty's from 3 different columns with same criteria

At first view this looks absolutely fantastic and exactly what I need. I will take some time to work with it and understand the code also.
Thank you so much for taking the time to do this.
Much appreciated indeed.

Re: Sumifs to sum qty's from 3 different columns with same criteria

No problem

Re: Sumifs to sum qty's from 3 different columns with same criteria

Table 2 goes up to the 31/12/2018

Re: Sumifs to sum qty's from 3 different columns with same criteria

No, table 1 could have possibly hundreds of rows, this will need to be dynamic.

Re: Sumifs to sum qty's from 3 different columns with same criteria

Yes that would be great - really appreciate your help

Re: Sumifs to sum qty's from 3 different columns with same criteria

Yes that would be great

Re: Sumifs to sum qty's from 3 different columns with same criteria

Kj, Really appreciate your help.

Re: Sumifs to sum qty's from 3 different columns with same criteria

Thanks again for that, to be honest I dont mind if they return zero......I defintely need to find the addtional lines solution though..........Can anyone else help??

Thanks

Re: Sumifs to sum qty's from 3 different columns with same criteria

Just notcied, if I add another line with the same resource (for eg another 'cleaner' in cell B4) table 2 doesn't pick this up - any further ideas?
Thanks a lot

Re: Sumifs to sum qty's from 3 different columns with same criteria

KjBox, Wow, I think that's literally the longest formula I have ever come across - that being said it does work so thanks ever so much for that.

Good Morning - I hope someone can help me with a Sumifs formula I require that is completely puzzling me.

I have attached a mock up of the output I require.

Basically I have 2 tables - a project table (Table 1) where there are 3 phases of work - Prep, Delivery and Commissioning. All 3 phases have start and finish dates, resource and qtys attached to them. So in effect I have 3 Resource Columns, 3 Start and Finish Columns and 3 QTY Columns.

Table 2 consists simply of a date header and the other headers consisting of the different resources. I need a formula that totals the resource requirement for the particular date in the date table - so adding together the 3 qty columns in table 1 for the particular resource and the date.

I think the attached will probably make more sense than my attempt to describe the problem ha.

I hope someone can help?

Thanks

Lee

Re: Macro to duplicate values/rows based on cell value

Thanks once again - tweaked this and now works as I want.

Re: Macro to duplicate values/rows based on cell value

BaraaKhalil,

I have had to insert 3 rows above the table headers so the input table starts at A4 (as opposed to A1) and the output table starts at E4 (as opposed to E1). Subsequently the macro no longer works.

What part of the code needs tweaking to mitigate these extra rows?

Thanks again.

Good afternoon - I hope someone can help,

I have an excel (2010) document that has several macros one of which creates new worksheets from a template sheet. All sheets are named "Task1", "Task2" and so on as they are created.

What I now need is on a separate sheet ("Summary") is to create a list of all worksheets in the document with hyperlinks to those sheets. Also, from there I would like in the next column a lookup of cell B2 of each sheet. So the summary table will look something like this:

[TABLE="width: 500"]

[tr]

[td]

A

[/td]

[td]

B

[/td]

[td]

C

[/td]

[/tr]

[tr]

[td]

1

[/td]

[td]

Sheet Name

[/td]

[td]

Details

[/td]

[/tr]

[tr]

[td]

2

[/td]

[td]

Task1 (hyperlink)

[/td]

[td]

This would display the value of cell B2 from Task1

[/td]

[/tr]

[tr]

[td]

3

[/td]

[td]

Task2 (Hyperlink)

[/td]

[td]

As above

[/td]

[/tr]

[/TABLE]

I hope this makes sense? I already have a macro that lists and hyperlinks the sheets but its the lookup of the value in cell B2 of each of those sheets that I am struggling with.

Hope someone can help?

Thanks in advance.