pos

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...

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...

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...

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...

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...

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!

<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...

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...

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

<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...

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...

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%

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...

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...

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...

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...

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...

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...

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...

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...