#31
|
|||
|
|||
Yes, I see that. But, how do you populate it? You need to populate it at the time the code runs.
|
#32
|
|||
|
|||
It will be a number provided by the customer at the time of the order and will not change, so I am just going to input it by hand.
|
#33
|
|||
|
|||
Is there some way to do this without entering by "Hand". It must be tracked in someway. Otherwise you will need to look at each "Sku" and then populate the quantity.
|
#34
|
|||
|
|||
I don't know how to obtain that number without hand entering it. It is something my customer provides to me at the beginning of each SKU order. I apologize if this makes it harder.
|
#35
|
|||
|
|||
Not a problem. Does the customer provide you a list? Is it hand written? Or, in some other format?
|
#36
|
|||
|
|||
It is usually in email format whenever an order comes in.
|
#37
|
|||
|
|||
Would it be possible to see it?
|
#38
|
|||
|
|||
See attached PDF of email.
|
#39
|
|||
|
|||
Hi,
Thanks! But, if possible can you send a copy to me? It may be possible to get the info from it. |
#40
|
|||
|
|||
Just pm'd you with my email address
|
#41
|
|||
|
|||
HI,
Here's the file. You will still see the "Test" button. I added the "Report" button. Click it and check the result in the report sheet. I used code to set the formats in the Report sheet. Still waiting for Email copy. |
#42
|
|||
|
|||
This will work perfectly. However, if I try to run the report a second time I get an error message wanting me to debug. I was hoping I could change or add data and then hit the report button to have it generate a new set of calculations if needed. Sorry to be such a pain here. Thanks
|
#43
|
|||
|
|||
HI,
I'll check it. Just ran mine and it too had error. What do you mean change or add data. In which sheet? Also not currently a "Pain" Added: The error is because it's looking for information in column C. Which we do not have any data in "Rows" 7 down. There must be info. That's why I was looking for the "Qty" Last edited by charlesdh; 12-17-2015 at 02:32 PM. Reason: Add info |
#44
|
|||
|
|||
I meant add more rows of data with numbers for columns K-R, or if I need to change a number in one of these fields due to a mistype or something.
|
#45
|
|||
|
|||
Ok, If I'm correct you will need to have the userform allow you to edit and or add data the the "Log sheet". Is this what you want?
PS am about ready to leave for a short time. |
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 |