ces you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: GENIUS
To: MS EXCEL AND VBA MACROS
Cc: schreiner_p...@att.net
Sent: Saturday, August 22, 2015 1:16 AM
Subject: Re: $$Excel-Macros$
THANK YOU VERY MUCH FOR YOUR HELP
On Saturday, 22 August 2015 10:16:25 UTC+5, GENIUS wrote:
>
> The formula you have sent is working but the problem over here is the date
> when i copy 02/06/2015 from another sheet and paste the same in
> TRANSANCTION sheet, then it is over write on the previou
The formula you have sent is working but the problem over here is the date
when i copy 02/06/2015 from another sheet and paste the same in
TRANSANCTION sheet, then it is over write on the previous one. Now I'm
sending 4 days transanction to you just apply such a formula when i copy
transanction
What are the other sheet names for each day?They can't all be called
"Transaction".
Are you looking for a macro solution? or Excel formulas?
the issue here is that for each ROW of data, you have to predict what the
source transaction sheet name will be.
For example, in Cell C4, you need the value