That was just some words of encouragement to include Access in the website ..didn't know I should start a new topic for that. Sorry for breaking the rules.
Hi RobSA,
I dont know much about macros but maybe this code will help.
First insert a command button(activeX control) and then right click and choose "view code". you will see a Subroutine has already been added.Write the code below between "Sub" and "End Sub" ...
Hi Maheshkasera
First you need to select the cells that you want to hide their value or formula in the formula bar, then press Ctrl+1 (or right click and select "format cells..." . On the "Protection" tab check the "Hidden" box.
After that protect your sheet (Review-> Changes->...
First you can use concatenate to join the city name and codes in for example column F to I, and have it like this:
F G H I
Mumbai25 Mumbai98 Mumbai154 Mumbai32
Calcutta85 Calcutta94 Calcutta42 Calcutta69
and so on...
Then name the...
I dont know much excel,but i konw SEARCH formula returns the number of the character at which a specific character or text string is first found. You may find the second occurance by changing the start_num in the SEARCH formula( for example using another search formula and adding 1 to it to skip...
I have a formula for counting number of thursdays and fridays between two dates,but i can't understand how this formula works!
The formula is:
=SUM(INT((WEEKDAY(start date-{5,6})-start date+finish date)/7))
Can someone please explain it to me?
THANKS