I'm currently trying to figure out how to do a sumif to keep track of current inventory. I thinking of just getting rid of that qty on hand column, and placing a master table on the side, or either on another sheet. Maybe I can just place it on the item sheet since the info is already there.
And...
This inventory list is for when employees are given work material. It uses vlookup for item numbers (some doesn't have any) and vlookup for the shift the employee works on to pull up data. It will be maintained by a customer service rep without any excel experience, just data entry.
What I...
I mean the colors and formating. Attached you will see the formatted (copied from Excel), and the plain (copied from Excel browser). Copying from the Excel application, you have pasting options including keep formatting and even paste as a picture. When copying out of a Sharepoint Firefox...
How can I do this and keep the formatting. I designed an Excel workbook, then placed it on SharePoint. The data that I need should be copied and pasted to an Outlook email, not attached. The problem is, I can't keep the same format when doing so. I can only paste plain, loosing the format. Is...
I definitely would like to recycle the formula if I can get it going. We products at different prices How would I change the price for other uses? Oh yeah... Thank you again. This is really helping. I thought something like this wasn't even possible.
Just trying things out...If I made date received 11/1, Date loaded 11/16, with free time ending 11/15; the # of storage days to charge (U2) is 1. The month of November (AJ2) shows 15 (7.5), but I would like for it to show 1 (.50). That's 15 free days, and 1 day that would be charged a storage fee.
I'm currently doing some business traveling, so I'm going to give it a try as soon as I get to the office. Thank you guys so much for seeing what you can do.
Correct The free 15 days start when it's received . So those 4 days in June would have been free, then 11 days in July would have been free. So the month of July would have had the 12th through the 31st cost calculated.
Warehousing and Storage Cost Calculation Question
I’m trying to figure out a formula that does this:
I want 12 columns for each month. In these columns will be calculations that adds the cost of storage based on the number of days that particular item is being stored.
The first 15 days of...