receipt

Hello, I'm currently working for a company selling phone cases and other accessories and, even tho they don't really care about their own Excel files, I do, as it makes the workflow much more convenient. Recently, my manager has asked me if I could come up with a formula for automatically...

Private sub command button1_click() If Range("J15").value=4 then Workbooks("c:\ tournament\bad beat\ receipt file.xlsm").worksheets(array("1","2","3","4")).printout Else End if End sub Says script out of range

ok this does not work but I'll post it so you can see what I'm trying to do, returns #REF "=IF(OR(W886="cp",W886="f",W886="m",W886="o",W886="of",W886="sf"),MAX(AH$5:ROW()-1)+1,"")" If you don't follow what that is trying to do... I keep track of mileage and expenses for a business vehicle...

I am trying to import a CSV file into excel via VBA and have it split the text into several columns based on "standard"-delimiters such as "," and also split it at certain words appearing in the text. Below is an (edited) excerpt of the csv file: (The current file is about 700 lines, but will...

I'm not sure if this is possible. I would like to enter a numerical value in cell I6 of a customer receipt and have the spelled out number appear in cell C7. Can this be done automatically with a formula? So if I enter into cell I6 - "2,123.46". I would like cell C7 to show "Two thousand one...

Hi, I need the below formatted text in the Excel VBA Code to appear as Message Body. (in place of MyItem.Body in Code). Thanks in advance. Formatted Text :Hi Sir/ Madam, Please find the attached receipt for your donations. Your contributions are invaluable to the Children. Thanks for your...

Hi Everyone, I have this data in Sheet1 - RECEIPT (1) NAME of payor, to be encoded every time clients pays for the service (2) DATE and TIME (3) AMOUNT (4) Receipt Number - should add an increment of 1, upon printing of receipt example, A...

Hi folks, I'm trying to add up the figures from a data dump that are a certain Brand, Warehouse, and Receipt Month. I know my arrays named Brand, Warehouse, Receipt Month and Rec Units are all the correct matching sizes. Any idea why this formula returns "#VALUE!" ...

Hi all, I have a user form which has various text boxes containing info. One text box relates to a word doc receipt as just a basic number system. Is there a code we can use to apply to a button on the user form that would then look at a specific text box and open its relevant word doc receipt...

Hi, Not sure if this is better suited here or the main forum, but here goes I have the code below that is supposed to save an email attachment to a defined location on receipt in Outlook. Private WithEvents Items As Outlook.Items Private Sub Application_Startup() Dim olApp As...

I have a fuel receipt form that must be filled out every day. Then we have to print the document and scan the doc and receipt together to email to HQ. what code is available to have a button or a before right click can I use to open a browse window and select the pdf to be embedded onto the...

I have a userform that collects customer information and generates a receipt. Presently the receipt is generated in another tab within the same workbook. Each time the userform is used the receipt is over written. I would like to have the receipt put into another workbook and each receipt is put...

Hello all, Hope you are doing well, Can anyone assist me in correcting the formula which lacks a function/condition to suffice my project. Assume the below cell values information provided: · B9 = Receipt amount · I9 = Level of Graduation · M9 = Grade Achieved ·...

Hello all, I have a project to work on where i am unaware and failed to get output i am looking for. Can anyone look into the below description with condtions and help me with a code which would fulfil this. For example: B7 = Receipt amount E7 = Claim amount. Claim amount= If Receipt...

Hi all, I have a table containing receipt (Column A) amount (Column B) description (Column C). The most important thing is that the receipt multi receipt numbers but by description cloumn we can identyfy as if one receipt # used to purchase chair it won't be use to purchase chair again...

hi guys I am struggling to get the data from one source WB to another destination new WB based on selection criteria with VBA. the source WB is as follows col1 col2 col3 col4 desc center receipt payment AA 12 1 3 BB...

Good day, I have a question: I work at a phone retail shop, and we use Excel to make the receipts for our customers. In order to find the receipts back if there's a problem, we have to (manually!) increase a number, the order number, everytime we open the file. So, one customer comes, buys...

I wish to create a pivot of the message receipts in an Outlook folder. I am coding in Excel so that the code can be run by anyone in the department without adding code to their Outlook profile. Using code that I have already got working for checking Categories in another folder I have modified...

Hi. In collecting funds, I have to give a receipt to the individual. So I am using a template from Excel 2013 which I have customized. I already know from pre-determined rates what amount should be received. On my source sheet I have a list of the people. I want to enter the person's name and it...