1. L

    Limitations to Excel VBA - where to go from here?

    I developed a POS system using excel vba. Now, multiple cashiers have to write to the same excel file simultaneously and I can't seem to overcome this limitation. The problem is that I need a locally hosted solution (no cloud based solutions). How can I do this? Any recommendations? I am...
  2. S

    need if conditions

    my data is <colgroup><col><col><col><col><col></colgroup><tbody> Pos 0 Subs 1 subs 2 sub Sub 1 1 2 2 1 1 3 3 1 2 5 </tbody> 1 subs- 1 pos and 2 sub then in 1 subs ZERO and in 2 sub its 1 1 subs-1 pos and 1 sub then in 1 subs 1 and 0 subs its 1 2 subs-2 pos and 2 sub then in 1...
  3. M

    How to pull data based on 74 specific criteria

    I am not sure if this is possible in Access or Excel for that matter... In my data I have a field Client PO. I am working on a project where I need to pull all line items associated with about 74 different PO #. There will potentially be additional lines of data added with these PO's. So I...
  4. M

    VBA to extract data from several data files - Bank Deposit Analysis

    I prepare a weekly deposit analysis for 80 locations and we are growing rapidly. I pull POS data from 2 sources and bank data from 18 bank accounts. 1. Deposit Analysis Workbook: This workbook has a tab for each location where all the data is consolidated 2. QOS POS data file: csv file that...
  5. B

    Count unique numbers within range

    help please, I'm trying to write a formula in the cells in yellow which will 1. in column D count the total number of unique POs ("purchasing documents") raised which fall under Group A (cell B5) and are within the range B7 to C7. 2. in column G sum the total of POs raised, it is ok to count the...
  6. M

    Can a data validation look for values against another column?

    Hi everyone, I am updating a Purchase Order register and would like the Purchase Order column to show only PO's that are on the master PO list with the same Supplier as in a separate column. Is this feasible? Thanks!
  7. kelly mort

    Replace last comma with and in cell

    <code style="box-sizing: inherit; margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera...
  8. Tenbapps

    Drop Lowest Score Formula

    Hello, Below is a championship table for the model cars that I race. There are 4 championship rounds - Coulsdon, Roedale, Haydon & Pinewood and I would like a formula in the last column where it currently says #NUM ! that shows the best 3 results only - we are yet to race at Pinewood, but I'd...
  9. I

    IF Unique line

    Hi 'Alternative to vba Code If pos = 2 Then pos = 3 If pos = 5 Then pos = 6 If pos = 34 Then pos = 35 Thanks
  10. C

    Setting up a dependent form

    <tbody> Vendor Project PO Asset Apples Galore Fall 10 11 Green Apples Galore Fall 20 22 Yellow Johnny Appleseed Fall 10 54 Red Johnny Appleseed Fall 20 67 Pink Johnny Appleseed Fall 20 67 Peach </tbody> <colgroup><col width="514" style="width: 386pt...
  11. S

    Matching sheets together

    Hi, Below is my main data table of all my players: Sheet 1 <tbody> Name Total Rat. Cor Cro Dri Fin Fir Fre Hea Lon L Th Mar Pas Pen Tck Tec Agg Ant Bra Cmp Cnt Dec Det Fla Ldr OtB Pos Tea Vis Wor Acc Agi Bal Jum Nat Pac Sta Str James Coppinger 403 10 14 15 12 14 11 4 7 1 8 14 10 10 15 7 13...
  12. P

    arithmetic formula challenge neg /neg, pos / neg, pos / pos

    I am struggling to solve the arithmetic and write an excel formula that can calculate the percentage of goal. The goal can be either positive or negative and the actual result can be positive or negative. Example -3 / -2 = -100% -2 / -2 = 100% - 1 / -2 = 200% 0 / - 2 = 300% 1 / - 2 = 400%
  13. G

    Producing a plotted graph in Excel 2016 for given data

    Hi, I am a novice and am struggling with the below. Any help on this is highly appreciated please. Produce a simple graph – 1 graph with 3 plotted lines on it – whereby the axes accommodate full and accurate spatial dimensions. Not just accommodating the supplied raw data points evenly across...
  14. J

    Index Match for multiple values with same results

    Hi, I am trying to use the INDEX MATCH function to populate Columns E & F in the example below however I'm not having any luck, can anyone advise how to populate multiple values where the results are the same? Thanks for any feedback / assistance <tbody> Person Pos Pos Name 1 Name 2 Player...
  15. M

    Salesman performance anlysis.

    Hello Everyone, I recently opened up a retail store. Transactions are completed in a POS system that allows me to download reports. They are however not sufficient for me to do the analysis I need - hence I need excel help please! I am trying to create a dashboard to measure individual and...
  16. Z

    VBA Pivot Table Module not working

    Hello. I want to make the following part of the code to work, but where it is, it isnt activating the filters: Sheets("Clientes").Select With ActiveSheet.PivotTables("Tabela dinâmica15").PivotFields("Regional") .PivotItems("REG. SUL - LUCIANO").Visible = True End With...
  17. K

    Count Formula

    Hello, I need a formula to give me a count of all items in a column, ignoring hidden rows and duplicate values. Thank you in Advance! <tbody> A B C D E F G H I J 1 Total PO's 4 2 5520 3 4580 4 5520 5 1825 6 4890 7 4580...
  18. A

    if cell contains substring remove the substring

    folks, I need to remove the title "Dr" from a list of names prior to publishing. Not all names have this title. I can find the substring within my specific range with pos = InStr(nm1, "Dr ") where nm1 contains a name. nm1 refers to the cell C9 on my spreadsheet. if nm1 does not contain the...
  19. C

    Problem with SORT macro?

    Hi, I have an issue with this macro but don't know why. My table headers are all in Row 9 and I have frozen the pane just below it. I can select any cell from A10:J10 and down, run the macro and it sorts the cell's row ascending/descending taking the rest of the table with it. It all works fine...
  20. S

    Screen scraping from Internet after submit (VBA)

    Hello, I'm trying to retrieve information from Internet. I'm opening the site, filling in a condition and press the button Deal. So far it works. But then I'm trying to retrieve the information displayed on the website into VBA and sometimes that works and sometimes it doesn't. It seems...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back