Search:

Hi Koolsid,

Sorry for the late reply! And thanks for the getting me on the right track:)

Here's my attempt... Seems to work ok but not sure if its the most efficient way of doing it so any...

Excellent that appears to be working perfectly.

How would I also get the same check box to also hide columns W -AD, AW - BH & CC) and sort the results by Column M desc?

Many thanks in advance

Thanks for the tip, unfortunately this is not the cause as I tried changing that initially

Hi Koolsid and thanks for taking the time to reply.

As mentioned I am a novice with macros and have used coding from various threads to get me to this point so apologies if its not logical:)

I...

I have had an attempt at coding this using snippets of google-ing. The issue I having is the rows do not unhide when the check box is unticked, does anyone know where I'm going wrong? Also how would...

Hi All,

Excel 2003

I was wondering if anyone can help me? I am after a macro (assuming this is the best solution) to hide certain columns and rows based on the value in column B, the macro...

Hi and thanks for your reply,

I think SQL queries may work but can the results of the query be remain on a worksheet with a button to the refresh the results?

Would also need the new sheets...

Hey Guys,

Hope you're all well
I was wondering if anyone could offer some assistance with a particular task that I have been struggling with inb Excel 2003?

I have a spreadsheet with a...

Hi nO_OnE, That code it working now. Thanks you so much for your help I really appreciate it. It has also spurred me to get more educated in the use of macros and general excel functionality. Thanks ...

Hiya

The code works up until is skipped the summary sheet and looks for the next sheet but is for some reason looking for Sheet2.xls in the directory. I renamed one of the xls to Sheet1.xls and...

Thanks i'll try that.

I am copying the data from the separate workbooks to the master which can be stored in two separate locations/folders or the same folder whichever is easier

Unfortunately due to the distribution of the master spreadsheet once populated it is not possible to query or reference the data.

I agree though it would have been alot easier to do so.

Runtime Error 438 - Object doesn't support this property or method

Line 14 . For each sht in wb is highlighted when debugging

Hi nO_OnE.

Thanks for the updated code

I have added the code but seem to get a compile error : Object required
on line no.26 (wbnm is highlighted)

Any ideas?

Hi nO_OnE

Sorry about the delayed reply and thank you so much for taking the time to help me with this, your efforts are really appreciated.

I have added the code but seem to get a compile...

Hi nO_OnE and thank you for the prompt reply.

I would like to run the macro from the "master" spreadsheets which will be the only spreadsheet open. All the other spreadsheet will be stored in one...

Hi All,

I am new to this forum so apologies if I am asking simple questions!

I have an urgent problem which I have been trying to code for weeks but unfortunately my VB skills at basic to put...