dollars

I need to create one pivot table for a report. My data currently exceeds the rows for excel, so I took the data and put it on different tabs. The headers are the exact same, but instead of one tab with ~1M+ rows, I have two tabs with ~500K. How can I connect these two tables to one pivot...

Greetings, is it possible to have (3) dropdown lists equal a dollar amount? Task at Hand: I will try to simplify to help make sense. Let's use a restaurant menu as an example. Depending on your order and the options chosen, the total will be different. Dropdown list 1: Types of meat-Chicken or...

I am looking for help on how to import text file data based on the files page break. My current VBA is below and writes the data to Excel, but does not do it by page &/or dealer. Any help is appreciated (text file example follows code). Option Base 1 Dim TextLine As String Dim FileToOpen...

I am trying to pull Labor Dollars from Sheet1 into Sheet2 by using a 3 way lookup Index and Match Function. The 3 criteria are JO, TSTSD and KO. Any help is appreciated. Thank you Gene Sheet2 <tbody> <colgroup><col style="mso-width-source:userset;mso-width-alt:3766; width:77pt"...

I am in the design phase and looking to get some ideas on the best way to design my spreadsheet. We have a small private org that makes purchases and hold fundraisers. Some items we buy in Japanese yen and some we buy in US Dollars. We also receive Japanese Yen and US dollars. What is the best...

Hi All, tried to look up the answer cause I know we covered this years ago 2005 ish. I needed to get same type answer/formula then but can't find the answer and can't remember how we did it. So here goes: I'm getting old and want to set up a will. I have a couple dollars in investments. have...

I have a chart based on two columns of data - % of total and the actual dollars. I have the chart show the bars as a % of total. However, my data labels point to the actual dollars so these are based on a formula reference to the cells containing that data. This is referencing a pivot table...

Hi all, the "spell" function works great, the only problem is , it doesn't fully resolve my problem. For the document i need to send to bank. I have few problems that i need to modify the code: As below e.g. 1. Usd 45612.00 . I need it to covert for me to " us dollars: Fourty five thousand six...

Do any of you know of an Excel function or add-in that would convert currency with custom rates? I was going to make an add-in that would do the simple conversions for me but before I jump into that I was wondering if there was something already out there that accomplishes this. In case you...

This formula is working well with on major exception. A person can work in more than one department and their name will be listed more than once. This formula will only capture the dollars of the first matching name entry. If John Doe is a match in the Jan-Pay Paste tab more than once, I need...

I'm putting together Quickbooks reports into one spreadsheet for each group within our church. I'm having the offerings and expenses listed by month at the top of the page. Within the report, it will have "October income" (or whatever month) in column b. I want to have the total $ which is in...

I made a chart with two axis. I need to actually switch the axis so that Cum % is on the right side of the chart and dollars is on the left. Right now Cum % is on the left and dollars is on the right. How do I make this change? Seems like it would be easy but I am not having any luck