Re: $$Excel-Macros$$ help required in petty cash transanction

2015-08-24 Thread Paul Schreiner
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$

Re: $$Excel-Macros$$ help required in petty cash transanction

2015-08-22 Thread GENIUS
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

Re: $$Excel-Macros$$ help required in petty cash transanction

2015-08-21 Thread GENIUS
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

Re: $$Excel-Macros$$ help required in petty cash transanction

2015-08-21 Thread Paul Schreiner
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