Search results

Fantastic. It just works..... It is 22:45 here and I have been at work since 11:30 this morning. I can see what you changed but I am not going to try and work out why it works now until tomorrow. Please be assured I will work it out and learn from this. Thank you for your time! Oh You...

Hi, Some time ago one of you gents put together some VBA which did the job it needed to do. But now I was hoping I could get some more help with it. The attached file is more explanatory but basically the code works fine if I put a value in each cell one by one. Want I want to do is...

I tried sumproduct earlier today and got value errors but it's working beautifully now. The unmerging and filling the cells in A with the correct values has made everything come together. Thanks a bundle, I will get this all up and running over the next few evenings at work and roll it out to...

Ok, I see what you did there. It's a useful start. Needs some preparation of the report to get the result but if the other required results can be got without any extra prep, just formulas, it's a good start.

Hi, I am trying to make my and my co-workers lives easier. We receive reports twice a day that we manually wrangle for necessary data. I would like to be able to pull the necessary data using formulas so we can just copy/paste the results (as values) into our report presentation. Attached is...

That man requires a large beer. NOW

BINGO! Thanks, I have absolutely no VBA knowledge whatsoever and (shamefully) the right click on the sheet tab and copy/paste threw me for a bit. But I have succeeded and it works! So many thanks. I can see how to modify the code for my real timesheets. I have changed the cell references...

That works fine BUT (sorry...) as these are time schedules it is actually necessary to adjust them during the week/month etc. Currently we just select and drag a filled cell across into a blank area to create extra hours and select/drag empty cells across to remove hours. Unfortunately once the...

Hi, just posted my first question.I have been getting your newsletters and reading your site for a few months. The charting info is really helping ma at work, many thanks....

Hi, I should intorduse myself in the "saying hello" forum first but didn't....my bad.... So, I have a shiftplan or time schedule I am trying to make easier to use. The sample workbook explains it all but briefly, I want to type a letter into one cell (say any cell in C1 and then autofill...