Set range H5: H#### where ### is a number from a cell stored in HD4

[sdl2]

Hi guys,
All I want to do is set the range as H5:H#### where #### is a number stored in a cell. In other words the range is dynamic.

Please Login or Register  to view this content.

Additionally, I'd like to filter multiple criteria starting with criteria1 and criteria 2 will filter from criteria 1 and so on... can I just use

Please Login or Register  to view this content.

Thanks,
Sam

[hoyasaxa215]

You can accomplish this using the =INDIRECT function.

https://support.office.com/en-us/art...b-d4007d89477a

[sdl2]

I'm afraid I don't know how to do this in VBA. Right now I have a bunch of rows that go to 14000 and increase daily and 1 row goes to 50,000. I only need to filter the list that goes to 14k as it changes not all the way to 50k. This takes too long.

[Debraj Roy]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[sdl2]

Please see the attached, by the way I need to search every single field so if there is anything I need to be wary of please advise

Data_For_filter.xlsb

[Debraj Roy]

OK.. thats the story..

try to grasp it..

Please Login or Register  to view this content.

[sdl2]

OK.. thats the story..

try to grasp it..

Please Login or Register  to view this content.

Ug I knew it was so simple. I was so close. If I post the code I have now for the complete setup would you be able to offer any suggestions to make it faster? Your call of course.

[sdl2]

p1 of 2

Please Login or Register  to view this content.

[sdl2]

p2 of 2

Please Login or Register  to view this content.

[Debraj Roy]

If I post the code I have now for the complete setup would you be able to offer any suggestions to make it faster?

only If you post the Sheet.. and let us know the FLOWCHART.. or requirement.. in plain language..

[sdl2]

only If you post the Sheet.. and let us know the FLOWCHART.. or requirement.. in plain language..

Hi Debraj,
I have been having great trouble with this. What I have in the Design Form is an unchangable layout for our product. The "flow" is that a user enters any data in the design master, that may be a partial match or more than one criteria. The data types are numerical, text and date. Then when the user clicks search records, records that match are returned. Basically filter the raw data. I have only shown the first few hundred records. There are 14k and growing. Let me know what you think!

Module 5 contains the code that pertains to the search record button and what I am trying to do.

Thanks for the help!!!
DesignMasterCodeCleanup.xlsb