Search:

Perfect - thank you for your help again!

Regards

Hi Maud - yes I understand how that, however when I back space (so no search criteria) there must be still some filtering happing as the row numbers are blue and there are no "Blank" cell showing.
...

Thanks Maud - Understood.

Will see how I go using it in my spreadsheet.

But looks as though is will be just fine

Thanks again

I've tested the code in my spreadsheet and it works as it...

Hi Maud - thanks again for your help. The code looks to be just what I need.

However, not sure how you set up the search field in G1 and actually how all the cells on Row 1 are set up

Any tips...

Hi Steve Thanks for the reply, I agree, however the spread sheet will be used by a number of different people with different excel skill levels, so was trying to automate (to accommodate the lowest...

Hi Loungers,

I'm after help with some VBA code to search a column for text that match a search criteria in a column (L).
I've tried to record a macro to activate the filter but that does not...

Hi Ian - Thanks very much for your help.

Will give your it a shot tomorrow when I get back to the office.

Will let you know

Regards

Hi Loungers

I'm after some assistance with the following offset formula

=OFFSET(Sheet2!$K$7:$K$18,0,MATCH(Sheet1!$E12,type,0))

This works fine and offsets as it should, but i'm after help...

Hi Zeddy - sorry about the delay in getting back to you on this, but I've been off line for the past few days.

Thanks for your help - looks very good and I should be able to adapt to my working...

Loungers - more assistance required please.

I'm sure that this has been discussed before - but I need to be able to off set the chart in the sample attached, so the data range moves by 12 months...

Thanks to all for your help - very much appreciated

There seems to always be more than one way to skin a cat!


Regards

Verada

Thanks for your help - that looks to do the job just right.

Regards

Hi Loungers,

After some help (again)

Trying to sort out a formula in C35 that matches the date in A33 along Row 2 and then the project name in B35 on.

The result should return the value of...

Hi Y32rem, Just having a look at your spreadsheet. I've done something like this before One suggestion in your 2013 Mailing tab, instead of putting the column numbers in row A suggest you try...

Maud - "slap the forehead!" sorry I should have picked that up.

Thanks again

Verada

Maud - Screen shot as requested.

You can see that the text "test to see if this apprears in the task section" in the last cell in the Task tab is not apprearing in the last row of the Measurable...

Thanks Maud - Sorry to bother you again about this, looks like you got the bug for Responsibilities tab and is picking up the last record but still looks to be a problem with the task tab not picking...

Hi Maud - No sign of you off Rottnest yet!

Any luck with the fix for the bug?

Regards

Verada

That was quick! - thanks Maud

Hi again Maud, been doing some more tests and discovered a small bug. The very last record on the Tasks (B270) and Responsibility (B72) tab will not appear in the generated PD template.

So in...

Hi Andrew - Thanks for the reply. Will be a good excuss to get of the dark ages and upgrade our Office version

regards

Verada

Maud - thanks once again for all your help. Very much appreciated

Regards

verada

Hi Maud - sorry to bother you again. One more request (I hope). I need to protect the PD Template tab, have selected all cells (other then the Compo box) and locked and hidden them, however when I...

Hi Andrew - thanks for the reply - we are still on 2003

Regards

Maud - thankyou very much for all your help. I'll see if I can sort out the print areas - must be very close but must need some adjusts to the range. If you have any thoughts about the print range...