pack

Hi all I'm trying to speed up the transpose process. When I copy an order form from online it pastes it all into Col A but I need to make it easier to read as I already have the next stages in place. The problem is the site changes from time to time and I have to redo the sheet. The common...

Morning, For the life of me i can not think of a way to do this. So im trying to set up a spreadsheet for inventory management. I have the following formula in cell E2 =IF([Average_Qty per week]>=3,[@[Average_Qty per week]]*D$1,(D$1/2)*[Average_Qty per week]) But i would like this to have...

Trying to improve my pack list. Our worksheet has a unique product number at the top of each column. The cells of each column contain description, weight, size, price, etc. I want to copy the contents of the column (approx 8- 10 rows each) onto a packing list. Currently I find the column...

Hello All! Got a query which I hope someone can help with.. I have a spreadsheet that I need to create for work due to a new process. Essentially what I need help on is a formula which automatically breaks down the allocation (column B) into packs (columns D-M). Below is a shortened version of...

Good afternoon. I have two tables as follows: Table 1 has a client's name, and pack mode. The pack mode can be any of three items (FCL, LCL or LSE) table two has two columns, one for pack mode and one for the related price. Each pack mode has its own price. I need to do a vlookup in table 1...

Hello All, So I create product upload CSV and each product has a different choice such as a Size, Unit, Color, Size and Units, options etc. These choices are all on different columns however I need to consolidate all into one column at the end. The reason because I need to upload the choices...

Hey Guys, I've got a pivot table infront of me and just wondering if this is possible. Pivot table columns go as: Mechanic - Brand - Pack - Account I need all of these as they are. The next column is months. After this I have financials. I want to create a conditional format where...

I own a small business and I'm having trouble with employees adding incorrectly and I'm wanting to create a spreadsheet that will do the math for them. As a part of my business I sell lottery scratch off tickets. Each ticket is numbered and we count them down at the end of the day to determine...

Hello, I have a list with 3 columns: Package Name: Latest Date: Link: The VBA should click on the link, go to the linked sheet, capture a value and return to the main page. I have a problem with writing a loop to go through the link in each row. Can you please help...

Hi, I have multiple Rows (within a Column) that I want to SUM but some have #N/A in them. When I have the formula to create the Total, I want to be able to drag it across 24 Columns. I have found 2 examples - both work in various situations but not my specific one. Can anyone suggest a...

I have the following table structure. I am attempting to pull in the Planning rate associated with the Part No. The structure (if you look towards the bottom of my table) is not stable - sometimes a product may have 1, 2 or 3 lines (they could, conceivably, have 10). The structure may have...

Hi I have a sheet where I'm extracting the pack size of a product using IF(ISNUMBER(SEARCH then multplying that pack size by the units of the product. However, there are some products where the pack size is 2 and others where it is 12 eg Chocolates 2x250g Chocolates 12x250g Excel can't...

Hi, I am wanting a formula for this spreadsheet. Column A has a list of descriptions for example "red pens pack of 100" or "red pens pk25" What i am wanting is in column B to pick up Pack of 100 or pk25 (numbers would change). Ive got partly there with this...

Hi everyone, I've got a bit of a problem I do an index match of my sku's to tell me my stock levels from my weekly CSV readout. I put the data into sheet "CSV" the simply have a formula in sheet "Stock Level" that index matches the Sku in "D6" (for example) with the data in sheet "CSV" CSV...

Bitcoin calculator - Google Drive Hi guys, I'm new to the forum and need some help. Above is the link to a calculator a friend has made however it's not quite finished. How it works: I start with a number of packs (B10) which is determined by the starting balance (B3) and each day the...