can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-- ---
From: Izhar
To: excel-...@googlegroups.com
Sent: Friday, August 21, 2015 7:14 AM
Subject: $$Ex
mp;TEXT($B4,"mm.dd.")&"!$A$2:$B$55"),2,FALSE),"")
>>
>> You drag THAT across and down.
>>
>> Then, as long as the new sheets are named in the proper format:
>> "transaction_mm.dd.yyyy", then the Petty Cash sheet will update
>> appropriately.
>>
>> If
format:
> "transaction_mm.dd.", then the Petty Cash sheet will update
> appropriately.
>
> If you can give me the proper sheet name format, I could make sure the
> formula is corrected.
>
> *Paul*
>
>
> ---------
>
ys you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Izhar
To: excel-macros@googlegroups.com
Sent: Friday, August 21, 2015 7:14 AM
Subject: $$Excel-Macros$$ help re
in this workbook, I have two worksheets namely PETTY CASH SHEET and
TRANSANCTION, I need a formula through which I may be able to transfer
amount from TRANSANCTION sheet to PETTY CASH SHEET in the date and
respective accounts mentioned in the TRANSANCTION sheet, in this workbook
I've provided only
