Home » Forums » Open Source Learning Center » Question and Answer

how i connect sheet of another outside sheet

Submitted by predator on 25 July, 2012 - 08:04

hi, every one i need your assistince about conection two outside sheet i have a button in sheet i wanna link of another sheet for search is there way to do it?

‹ Cant retrieve auto fill value from java Auto fill a column based on three columns ›
»

last date before or equal to todays date

Submitted by brijendraydv on 21 November, 2012 - 12:00.

Hello Experts,

Can any one help me as i have a data arranged something like this where the dates are in horizontal manner in a row like 10/1/2012 10/1/2012 12/20/2012 9/20/2013
and i need to find using excel formula the date just equal to todays or before date using now or today formula.pls help

Thanks a lot in advance

»
Almir's picture

last date before or equal to todays date

Submitted by Almir on 21 November, 2012 - 13:26.

Use conditional formatting where condition is today() or today()-1.

Anyway, post this separately.

»
Almir's picture

how i connect sheet of another outside sheet

Submitted by Almir on 23 October, 2012 - 09:47.

Do you want to click a button and to jump to another outside sheet?

»