automate cells

Hello, I have a list of shifts I did with the date. This list expands as I do more shifts. <tbody> A B 1 Shift Date 2 1 date 1 3 2 date 2 4 3 date 3 5 4 date 4 6 5 date 5 </tbody> I have another list of deliveries (on another sheet) with the shift given, I want to automatically...

Hello everyone, I have an difficult problem and i do not even know if this is possible in MS Excel. The question is as follows: The Excel file should automatically calculate the amount of palletlocations needed for storage. <tbody> Boxes Monday Tuesday Variation 1 0 0 Variation 2 140...

Quick Rundown: I have a Purchase Order template into which I type Product Codes. The template uses lots of lookup functions to populate the rest of the fields such as Item Description, Vendor, Price, Item Number, Type, etc. from an equipment database. It also automatically sums all prices in the...

Hello everyone, I am experimenting with an expenses report. It has a basic form, as described below: - Rows: Jan, Feb, ...Dec - Columns: types of Standard Expenses, total "Standard Expenses", other types of expenses, total "Expenses", Income, Savings, Bank Account no.1, Bank Account no. 2...

Hi i have a drop down list in column c and what i would like is, in any cell of column c, if from the drop down list, the option 'abandoned' is celected, then i would like for that row, any blank cells, to automatically be filled with the term 'abandoned' as well. For example, if a user selects...

I need to auto fill 10 rows in Excel from a database based on one cell value. How do I do this? For example in Cell A1 I have the value "1993" and in A2 through A12 below I have empty cells. On a separate tab I have my list of data (See sample data below). In column A, I have a list of all the...

Hi there, I am new to the group and was curious if anyone can help me out with a macro I need to create. I am trying to number rows based on a number in the header. However, I want to repeat a number a certain number of times until it moves on to the next number. To provide more detail...

Hiya, I've posted about this problem before, without much luck finding a simple (or working) answer. I want a cell to display the current date when another cell has something entered into it. Example: I enter @ into A1, I want B1 to display the date without me having to either click on it and...

Hi Guys, Im struggling to find a formula to populate cells based on values to be checked in two fields (ICODE, COMPANY). In the example shown, all records where ever the ICODE = 49, i need to populate the fields AD1,AD2,AD3 or AD4 based on the same company name and where ever the ICODE <> 49...