I am trying to search member from the memberlist. since the list is a big one, i.e. upto more than 3000 pages running, how do I seach that concerned member or in case i want to jump to, say page no. 250 or 500.
If the list is 3000 pages, is that one "page" per member, with the member's name as the sheet name?
Or do you have multiple names on each page and need to search those 3000 sheets in turn?
I am trying to search member from the memberlist. since the list is a big one, i.e. upto more than 3000 pages running, how do I seach that concerned member or in case i want to jump to, say page no. 250 or 500.
To get to a different page, go to page 2 then in the address bar change the final '20' to some other number. Changing it to 4000 (200 x 20) will get you close to page 200. There are 20 entries per page.
pages ?? sheets ???
oh perhaps you are talking about the MrExcel-memberlist ?
then you are not posting in the correct forum
go to members
sort members on joined date or name or posts
click any page (page 2)
change last number to something else (20 to 1000 to get to page 50)
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.