geronimo
10-11-2019, 05:00 AM
Hi all,
I have a very large table (100k rows) which contain the bibliography of some romanian authors.
The table has only two columns
Column 1 - contains author name
Column 2 - contain all the authors works, each of their works on a separate row. Besides the work's name, the cell contains also some more data as: editor name; year of publishing.
I am looking to make a search form with the following search fields
Search Field 1 - Author name - it will search only in Column 1
Search Field 2 - Year - here i need to set up an interval (let's say 1880-1885) - it will search in Column 2
Search Field 3 - other keywords - it will search in Column 2
The search should be performed as follows
1. not all of the Search fields must be filled => Search will display the matching results only for the filled fields
2. Search field 2 - year interval - this will search in Column 2 for each of the years in the interval (ex. if interval is 1880-1883, it will search for 1880,1881,1882,1883)
3. Search result will also display corresponding data from both columns of the sheet.
So, to summarize, a few search examples:
Example 1 - i need to search for all the works of Author X from year 1900 - i put the author name (X) in Search Field 1 and i set the year interval 1900-1900
Example 2 - i need to search all the works that were published by Editor Y between the years 1900-1903 - i leave author Search Field (1) empty, i set a the year interval 1900-1903, and i fill the editor name in Search Field 3 => so in this case the search will basically look only in column 2 of the sheet and will display only the rows in which we can find the keyword form search Field 3 (in this case editor name Y) AND one of the years from the interval ( 1900,1901,1902,1903)
I never used VBA before and till this project cam up i never tried any VBA programming...so please be gentle with a complete beginner as i am :)
Can anyone help me do this, i will provide very fast all needed details if there are things to clarify
Thank you all in advance for any input and guidance in solving the problem
Cheers!
I have a very large table (100k rows) which contain the bibliography of some romanian authors.
The table has only two columns
Column 1 - contains author name
Column 2 - contain all the authors works, each of their works on a separate row. Besides the work's name, the cell contains also some more data as: editor name; year of publishing.
I am looking to make a search form with the following search fields
Search Field 1 - Author name - it will search only in Column 1
Search Field 2 - Year - here i need to set up an interval (let's say 1880-1885) - it will search in Column 2
Search Field 3 - other keywords - it will search in Column 2
The search should be performed as follows
1. not all of the Search fields must be filled => Search will display the matching results only for the filled fields
2. Search field 2 - year interval - this will search in Column 2 for each of the years in the interval (ex. if interval is 1880-1883, it will search for 1880,1881,1882,1883)
3. Search result will also display corresponding data from both columns of the sheet.
So, to summarize, a few search examples:
Example 1 - i need to search for all the works of Author X from year 1900 - i put the author name (X) in Search Field 1 and i set the year interval 1900-1900
Example 2 - i need to search all the works that were published by Editor Y between the years 1900-1903 - i leave author Search Field (1) empty, i set a the year interval 1900-1903, and i fill the editor name in Search Field 3 => so in this case the search will basically look only in column 2 of the sheet and will display only the rows in which we can find the keyword form search Field 3 (in this case editor name Y) AND one of the years from the interval ( 1900,1901,1902,1903)
I never used VBA before and till this project cam up i never tried any VBA programming...so please be gentle with a complete beginner as i am :)
Can anyone help me do this, i will provide very fast all needed details if there are things to clarify
Thank you all in advance for any input and guidance in solving the problem
Cheers!