## Inventory Spreadsheet

Help !!! I am “trying to” create an inventory signout sheet that keeps track of quantities (with multiple vendors). So each vendor has items …

Excel 2003 Help. Free Excel help for formulas, functions, macros, spreadsheets and VBA.

Help !!! I am “trying to” create an inventory signout sheet that keeps track of quantities (with multiple vendors). So each vendor has items …

I am using Excel 2016 and I am trying to have two different text alignments in the same cell: top align and bottom align. I want to write a statement on the …

I’m trying to return a value of what shift a tech starts his day based on when he inputs his starting time. If they start anytime between 4 am and Noon …

Not sure what type of formula I need but I will try my best to describe the situation. On a risk matrix there are 6 levels of severity (numbered 1-6) and 6 …

How do I write the following in VBA? If (“F2”) begins with 8: true: if (“H2”) is empty …

Hi there My boss wants me to analyze every sales peson that has walked through our doors into sales done in their first 8 weeks, 16 weeks, 24 …

Hi, I’m looking for a formula that will automatically apply today’s date to a cell if another cell is filled in, and keep that date in the …

Hi there, Please help solving adding a second formula to a cell that already has a formula. That is, column D is named “Shares”, column E is …

Need to do a vlookup for the mid digits of a UPC from another work book to find a match. UPC in Nielsen is 12 digits and my dbase is 10 digits and it appears …

(please ignore the category in each, i was making sure formulas worked) i’m currently using google sheets, which i know isnt exactly the same set …

Is it possible to create a unique customer form for each customer from a list. In other words, I have a list of 150 customers and I’d like to be able to …

I have created a link to a website: no big deal. I am trying to get a formula to ‘add’ the number from an adjacent cell A1, A2, etc. to search at …

i have a set of 30 stations (30 raws), i wanted to create a chart fro each raw , i have the same number of years in teh first raw as an x axis … …

I have a global template at my company using which I am saving SOPs. Each time I create a new SOP with this template, I number the SOP with one greater than …

Instead of looping through one worksheet “RVP Local GAAP” how do I change the below code to loop through two worksheets along with two …

Greeetings! I am trying to create a column in excel that is 35% of the numeric value of each number in the column. It is several thousand rows, all with …

Hi I have a few excel worksheets with work rotas on and want to then auto transfer data to a single daily sheet to reflect who is working that day and also …

Hello, I am trying to use =IF(NOT formula to tell me if a certain date is over 11/01/17 then it will tell me yes or no. For example, if my invoice date …

hi there, I have a number of excel price lists I am working on and I need to know the following: How do I move the value of a number of different cells …

Hi, I have a master list which has a list person names with some details. I wanted to extract list with some % (lets say 10%) from each person? Is it …

Copy the database to sheet 2 and extract the records where the item name is starting with letter “P” How to do above thing in excel By:

How to tell following criteria in if function Employees who are in grade 1 are subject to 1% of basic salary Emoloyees in grade 2 are subjected to 2% of …

I have a questions about a formula. If R7=1 then S7=13.05If R7=1.5 then S7=15.54If R7=2 then S7=19.54If R7=…….. What would be the formula for that …

Hello, I have an excel document with multiple worksheets. Each worksheet represents an engineering project and the worksheet tracks tasks to be …

Hello, I need your help if possible. I am trying to build a word document out of a excel file. The problem is that I want to make the process automatic, …

Asset data1 data2 data 3 status ABC ddd ddd ddd CDE ddd ddd ddd FGH ddd ddd ddd IJK ddd ddd ddd WS 1 Above WS 2 …

28985RPB309190 2750932B123925 The above string of numbers & letters. I am trying to take only the first 5 or 7 numbers and concatenate a new column …

Hello, I need to create a database for my outgoings. (using offica pro plus 2013) I get paid every 28 days so the pay date changes and there are numerous bills …

I have a dataset in one range (which is from A2:A10) which i need to divide in two ranges (from B2:C20) equally and repeat range one data from A2 …

Если ассоциировать установку электронного теплого пола с водяным, то 1-ый выигрывает …

Hello! I’d say I’m an intermediate excel user but I have a not mastered using match, index and count if functions within each other. I have …

At the company I work for I am in charge of ordering seed. I have over 300 different species and I order from 10 different suppliers (ordering generally from …

In Excel 2016, I have a list of daily temperatures for my home town since 1961 to the present day. It consists of two columns, one for the date and one for the …

I have a workbook with 5 sheets in it (new, delayed, in process, completed, and cancelled). In each of those sheets is a column named “Status” (all …

I was wondering how I could multiply every previous cell in a column with a specifc number. For example we have 2 and I want to multiply it with 3 so the cell …

Helllo, So I run a few things in access then export it to excel 2016 and need a macro I can just click a button on every excel sheet I open. Either one …

Hi, I’m trying to find out if I can input a file name such as “file name_123456_2018_NI” into one cell and have just what is before the first …

Hi I am looking to get some help with excel but don’t know how to word my question. I am trying to create a calendar that updates itself. I will do …

I have worksheets named WS1 and WS2. I need to compare Column C of WS1 with Column D of WS2. If both columns contain same values then I need to …

Hello I have entered the following formula; =TEXT((A1),”ddd d mmm yyyy”) This returns ‘Mon 18 Dec 2017’ in my chosen cell (G2 in this …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.