#16
|
|||
|
|||
Quote:
|
#17
|
|||
|
|||
I was tinkering with the subtotal formula, but I need it to only total the fields that are specific to each SKU# in column 'A'. For example, I need it to list all occurrences for "New Acct", "Damaged", etc. specific for 945DU2869 and so on. This spreadsheet will end up having over 1,000 entries when it is all said and done. Thank you in advance for looking into this.
|
#18
|
|||
|
|||
Hi,
I was looking at the Report sheet. You have data in it that does not appear in "Log" sheet. Columns "B" and "C". Where does that come from? |
#19
|
|||
|
|||
The description (column B from report sheet) is something I was going to add after the fact. This will be an overall description of what each SKU# is and there will only be the 3 descriptions, so I didn't want to muddy the log sheet up. Column C on the report sheet is the same as the numbers list in Column C on the log sheet. However, I can just delete rows 2-5 on the log sheet now since this same info will be on the report sheet. My only issue was every time I delete the rows from the log sheet it messes up the button you did. Thank you.
|
#20
|
|||
|
|||
Hi,
Modified the Log sheet. Also revamped the code for this. Take a look. Also in the report sheet you are not concerned about the data in column "B"? And too when I remove the rows in the log sheet the report now show "Ref". Thats because I remove the rows. |
#21
|
|||
|
|||
Charles, I had a COUNTIF function totaling-up all the occurrences of entries per each SKU# to give me a total of each entry in order to calculate the percentage of SKUs logged. I also need to calculate the total # of marked issues specific to each SKU#, but have been getting extremely confused. Thank you for helping me on this. Your work has been much appreciated.
|
#22
|
|||
|
|||
Hi,
I'll try to put something together tomorrow. Was gone for a short time today. We can address the "Countif" once I get the count for the "Problems" fiorthe report sheet. |
#23
|
|||
|
|||
That would be much appreciated. Thank you for looking into this further for me. Hopefully, I am not a "problem". LOL
|
#24
|
|||
|
|||
HI,
Are you wanting a separate button to run the "Report"? |
#25
|
|||
|
|||
If a separate button works easier for you than you can. I just need the report sheet to calculate the totals and make the required percentages. It can just be a sheet that keeps a running tally to real-time or can be updated via a button. Honestly, this one can be your call. Whatever you think the most efficient way is. Thank you, Charles. –Lonnie-
|
#26
|
|||
|
|||
Hi,
almost done. Have the counts going to the report sheet. All i need to do is the %. Will not be done today. I'll be gone tomorrow. But, will finsh on thursday. |
#27
|
|||
|
|||
HI,
About ready to take off. For the % you have formula that looks at column "C" quality. Where does that come from? Is it the count of the sku that you looking at? |
#28
|
|||
|
|||
C4 is the total quantity of units being sold and I would like to divide column D (the total amount of replacements) from this in order to get the percentage of units needing to be replaced. Then, for each column (new acct, damaged, missing, etc.) this would divide into column C to give me a percentage for each issue by itself. Let me know if this makes since and thank you!
|
#29
|
|||
|
|||
Hi,
In the file you sent I do not see "Number" of units being sold. Can you supply this info? I have the code working to populate the Report. But, as mention I also need the quantity of units. |
#30
|
|||
|
|||
Number of units sold is the same at column C "QTY." Sorry about this.
|
Tags |
button, filter, search |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Onenote 2013 search is not identifying search terms correctly | Delta223 | OneNote | 0 | 08-12-2014 06:40 AM |
Search for date and then apply mutliple search criteria in huge dataset | maxtymo | Excel | 2 | 12-01-2013 04:52 AM |
Looking for Windows Search app with ability to search by content | gopher_everett | Office | 1 | 02-28-2013 09:23 PM |
Instant Search's "Display search results as I type when possible" with Exchange | lwc | Outlook | 0 | 06-01-2011 01:56 AM |
Search and Replace - Clear Search box | JostClan | Word | 1 | 05-04-2010 08:46 PM |