Recent content by BH

Fantastic it now works! Thank you very much PHV and Skip

Hi thank you for this but now I get a Run-time error! Run-time error '1004': Application-defined or object-defined error The VBA code indicates that the cell is empty? Am i approaching this in the right way.....using a cell value to drive the pivot dropdown criteria??

Hi WHAT i am trying to do (but failing miserable) is to use a value from a cell to replace fixed text in my code. In my 1st posting example I have fixed text of "TRENTSIDE", i would like to refer to a cell value to replace the text "TRENTSIDE" So if the Cell (I8) value = SOUTHSIDE then my...

Thanks for your assistance Skip I have replaced TRENTSIDE with the cell reference and get a compile error: Expected: list seperator or) It does not appear to like the sheet name "Pack" ActiveSheet.PivotTables("PivotTable1").PivotFields( _...

Hi I was hoping that someone can point me in the right direction in showing me how to refer to a cell value inside VBA code. I am working with pivot tables where i select from a list to give me the values i require. So far i have managed to create and run a macro that selects the values for...

Good idea Skip, i will give it a go....thanks

Hi I am struggling with that as the information comes from a huge data set accessed by many different areas. I want to access just 21 of possibly 200 areas. Is there a way I can loop but only pick out the ones I require? I am not an expert in this area so any assistance would be gratefully...

Hi Hope this makes sense! guidance would be much appreciated.... I send out a monthly report that is sent to 21 different organisations. All of the 21 organisations info is held in one excel spreadsheet and i use a pivot table and dropdown box to filter the information. The next procedure is...

No problem....just very thankful for you assistance. Thanks again

Thanks SkipVought Brill, works a treat.....after I realised Dsiplay was slightly misspelt lol! Other points took on board!

Hi From a command button in an Excel spreadsheet I am filtering data and copying into a new workbook a number of times. I am working with Excel 2010 and saving the new workbooks in 2003-2007. Everything works really well other that I constantly get the the Compatibilty checker message box come...

Hi MajP Thank you again for the extra information. You have explained it extremely well and it is much appreciated.

Brilliant....thank you very much it works fine now! I had tried the contact_id in the code but could not get it to do anything......looks like the bound column was where i was going wrong! Thanks again

Hi dhookom Thank you for getting back. I have a primary key field but the users wish to search by surname as the unique contact_id number would not mean anything to them. My combo row source reads: SELECT tblContacts.Surname, tblContacts.[First Name], tblContacts.Contact_ID FROM tblContacts...

Hi I have a combo box that filters a contacts form depending on what is selected from the list. The list works on surname. Everything works fine until there are more than one surname the same. For example: Bloggs J Bloggs B When I select Bloggs J or Bloggs B it only ever filters to Bloggs B...