amount

I am merging 2 databases and joining through using the data in the amount column, on table 1 there are a few entries that have duplicate amounts, when the query is merged the power query matches table 1 Date Amount 02/10/19 7000 02/15/19 7500 02/17/19 7000 table 2 date...

Hi all, I have a macro that copies different excel workbooks into one workbook, except they all have their own sheet. When the files get copied into the one big file and get their own sheets, the sheet names are Sheet 1, Sheet 1 (2), Sheet 1 (3), etc.... I need help writing a macro that then...

I have a group of cells (A2:C20) that constantly has new information. I always have to go into the data/range and sort the values so that they are in order by date. Since the content of this group of cells is always changing, it is kind of annoying to have to re-sort the list all the time. Is...

Hi, I am trying to calculate the minimum and maximum amount the value of a cell based on another cell and cannot figure it out. I have never used this function. Helpful (hopefully) example. the max allowable increase is 10% but the below increase is 15%, so I would want the result to max...

Hello, I have the code below to get the lookup amount of the selected client from sheet5, but I don't know what I did wrong since it's not showing the amount on the "txtTotal, can you please help me to get the amount of the selected client? Note: the Amounts on column "D" contains formulas...

Hi All, If the positive amount is 100 and the negative amount have -75 and -25, will it highlight all these three. Can anyone please help me with a VBA code to get these. Thanks

Hello! I'm trying to find what possible combination of numbers is causing a variance. I saw someone do a formula once to find this but I don't have that formula. We have a statement with close to 500 lines and I wanted to be able to find which combination of those number would make $$$ amount...

Hi, I have n number of sheets in the workbook. Sheet 1 contains Customer name on column A, Sales amount on column B. <tbody> A B Customer Name Sales Amount Srinivasan Prabhu N number or Rows </tbody> sheet 2 name is Srinivasan and last row of Column D has sales amount...

Hi all, I am in need of a VBA code to be able to autofill this formula "=IF(ISNUMBER(--MID($B:$B,SEARCH("241",$B:$B),3)),MID($B:$B,18,10),0)" into column D anytime datat is inputted, this is an attempt to limit the amount of formula's are in the sheet as i dont want to have to copy the formula...

Hi Everyone, I Have two ranges D20:D250 & F20:F250 I need a total these with this rule Not all cells have a value, Column D needs to be ignored if column F has an amount example <tbody> Column D Column F 5 6 34 43 12 17 66 12 12 15 6 35 4 44 4...

Good morning all, I was curious if someone could lead me in the right direction? I was given the task by my manager to put together a spreadsheet that tallies up the amount of time someone spent in a certain classroom. They want the amount of time, 2 or 4 to be color coded but they do not want...

Dear All, I'm having a very hard time trying sort data in Column C from largest to smallest and also maintaining the row grouping. Can someone please help me by creating VBA code which can handle this task? Screenshot below without row grouping Sheet1 <colgroup><col style="width: 30px;"><col...

Hello all, I am in desperate need of some help with rolling back our inventory and seeing what the discount amount was on a prior date. I have a measure that rolls back the date and I have a table with the historical discounts by date. What I need to see is: SKU QTY DISCOUNT AMOUNT VALUE...

Hi there, I've tried to recreate two tables which I'm working with below: <tbody> Start Date Finish Date Effective Days Total Amount Daily Amount Month Start of Month End of Month Monthly Amount 04/09/2019 22/10/2019 49 1000 20.41 Sep-19 01/09/2019 30/09/2019 ??? 15/09/2019 15/10/2019...

Hi I am trying to create a pivot table based on this <colgroup><col><col><col><col><col><col><col><col></colgroup><tbody> <colgroup><col><col><col><col><col><col><col><col></colgroup><tbody> No. Invoice Date Company Net Amount (£) Infrastructure M&S/Aldi/Retail Safeline </tbody>...

hi, this is the 2nd part of my auto banking project Sheet 1 <tbody> Column A (Day) Column B (Date) Column C (Amount) Monday 2/9/19 0 Tuesday 3/9/19 0 Wednesday 4/9/19 0 Thursday 5/9/19 0 Friday 6/9/19 0 </tbody> Sheet 2 <tbody> Column A (Date of each month)...

Hi all, I have hit a problem with my work project and it's one of those where I can't even begin to design the solution never mind implement it! I hope you guys can help! I have provided a sample workbook here. https://drive.google.com/open?id=1u30oLh9SavbDpc3YVfoWGCEGJZ7Aqpeu The process...

Hi, I am trying to find a formula that would determine the distance (in feet) that these two coordinates varied from. In this case, to be expressed as "X" (amount of feet south) and "X" (amount of feet west) or original point. Then total distance as the crow flies. <tbody>...

Hello! Requesting help for Conditional Formatting. Example in table below shows desired results. CAPITAL ONE is paid off in bottom table. When excel sees the a value higher than zero in the PAYOFF AMOUNT column I want the CREDITOR and PAYOFF AMOUNT cells to display with a red font...

Hello. I am a bit new at using VBA for complex and detailed codes and I have really only used it for simple basic needs. I would say I have an average to above average understanding of it though. I am working on project in Excel where a User Form will open and display a Total Forecast Amount...