Posts by thangarajdme

Re: Hide or Lock column based on cell date

working to me.Thanks Mr.Jindon

Re: Hide or Lock column based on cell date

Dear Mr.Jindon,

same problem happened today also.Expecting help from you.

Regards,
D.Thangaraj

Re: Hide or Lock column based on cell date

Dear Mr.Jindon,

i have to open that file daily to make a stock entry.

Re: Hide or Lock column based on cell date

Dear Mr.Jindon,

its working but need to go and run the code daily.in my application if date changed that code should automatically run.
This is problem i having.
Is it possible?
Thanks in advance.

Re: Hide or Lock column based on cell date

Dear Mr.jindon,

i have noticed following mistake.

i have added VB in my excel on 27/09/13.its lock all column except 27/9/13 and 26/09/13.
But today (29/09/13) morning i have opened that excel.It is not changed with today date.
Expecting feedback for this.

Thanks in advance.

Re: Hide or Lock column based on cell date

Thanks jindon .its working great.

Regards,
D.Thangaraj

Re: Hide or Lock column based on cell date

Dear Sir,

Thanks for your valuable reply.

While run the code it shows following error.

Object variable or with Block variable not set

Can you help for this?

Re: Hide or Lock column based on cell date

Dear Sir,

Thanks for your valuable reply.

While run the code it shows following error.

Object variable or with Block

Dear All,

Herewith i have attached production workbook for your reference.

In this production sheet, we need to lock or hide or protect the entire column based of date.

If today date is 19.09.13, all other column should locked or protect from editing except 18.9.13,19.9.13 dated column.

Let me know and expecting help from you.

Thanks in Advance.

Regards,
D.Thangaraj

Re: Auto Hide or lock based on date

Hi
Excel attached and password for sheet is 123.

hi

My excel has attached for your reference.
In that i need to lock or or hide the entire column based on date.
Example
if Row 3 date is 10.8.13(today Date),i need to lock or Hide all column except todays column.

this is required automatically while open the excel.
My protection password is 123

expecting favourable response from you.

Re: look up value

hi
thanks for your reply.
Consider only 7th row.i need 7th row all rate value in different sheet.In excel sheet C8:L8 and N6:N7 are different sheet,i have combined that sheet for reference only.
My requirement is to take all rate values of row 7 based on date .

Re: look up value

Dear all,
above formula is not working.let me know the formula. find the attachment

Re: look up value

is any formula available for the same function.

my excel sheet attached for your reference.

i have combined five cells(column c5,d5,e5,f5,g5) and i have to look merged cell and take d column value.i have used hlookup function it takes c column value,how to take d,e,f,g values.