Dear shrinivas,
you can put this formula
*=B4+BeforeThisSheet("C4")*
and copy to another sheet (except sheet1 / *most left* tab sheet in
workbook)
*BeforeThisSheet* is an UDF ( = User defined function) that we can create
with VBA
Function BeforeThisSheet(RangeTxt As String)
' siti Vi / jakar
Thank you! I had problems when I just used an absolute column
number.
I did not realize that it was relative to the start of the table. In
the simple tutorials,
it is not clear whether it was supposed to be absolute or relative
(same in examples).
Hi to all !
first of all, sorry for my so poor english, i'm a poor poor poor
frenchy guy !
i'm trying to dev à "meeting time manager" ...
here is my project :
in e meeting, you have several subjects, and, of course
each subjects have there own time...
And, of course, one meeting have his global
*Hi siti Vi*
*
*
*Thanks for your reply .That was efficient*
*
*
*But i had a problem the order of the values may not be the same in all
sheets*
*
*
*for example:if "17" is in row 17 in sheet "A" it may be in row 20 in sheet
"B"*
*Your code works effectively if the order is same.You are comparing w
Dear Siti
Really thaks for the reply This reduce my work greatly
Shrinivas
On Sun, Oct 10, 2010 at 5:37 PM, siti Vi wrote:
> Dear shrinivas,
>
> you can put this formula
> *=B4+BeforeThisSheet("C4")*
> and copy to another sheet (except sheet1 / *most left* tab sheet in
> workbook)
>
> *BeforeThi