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

$$Excel-Macros$$ Client in New Orleans, LA need PeopleSoft Benefits Consultant

2015-08-21 Thread MADHU-GenuineItLlc
Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com Role: PeopleSoft Benefits Location: New Orleans, LA Duration:1+ year JD:- · PeopleSoft Benefits --- *With Warm Regards * *Madhu Roy* GenuineIT LLC *Certified Women Owned Business* Making

$$Excel-Macros$$ Client in Nashville, TN need WebSphere Process Server Consultant

2015-08-21 Thread MADHU-GenuineItLlc
Hi Partner, Hope you are doing great… Please send resume to ma...@genuineitllc.com *WebSphere Process Server Consultant - There are two openings* *Nashville, TN 37214* *2 months with possible extensions* Target hourly pay rate not to exceed $50 per hour corp to corp On behalf of our clie

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

Re: $$Excel-Macros$$ Re: Error : FileDialog

2015-08-21 Thread Paul Schreiner
I think the confusion is in the portion of the terms themselves:msoFileDialogFilePickermso: Micro Soft ObjectFile: FileSYSTEM (not a "file")Dialog: Interactive communication toolFile/Folder: Type of object to select.Picker: purpose of the object So, basically, msoFileDialogFilePicker is a flag t

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2015-08-21 Thread Paul Schreiner
Welcome!We'll do what we can to help. Just so you know:Much of the discussions deal with macro programming, rather  than excel itself.So, sometimes when you look at the messages, it may look "odd" because we often need to make the macro program do something that could normally easily be done with

$$Excel-Macros$$ Re: Introduce Yourself !!

2015-08-21 Thread onkar bodas
> > Hello everyone > Myself Onkar Bodas, I am from pune and i am a mechanical engineer. I like to work on ms excel but facing problems. I hope after joining this group, i will become sound in working with ms excel -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =

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

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