automatic cell fills

  1. R

    Automatically Center Across Selection and Fill Based on Number in another Cell

    I'm working on an event calendar and need to have the event listed in the week it starts then fill color in cells for the number of weeks that the event will run. If possible, centering the event across the selection horizontally would be ideal. The the weeks listed in the calendar will never...
  2. S

    Moving items to a new page automatically

    I'm trying to find a way to automatically populate the Category/Rank per site as unique rows on the Vendor – Upload Template Tab by us filling in the Vendor – Account Template Tab. Site information on the Vendor – Account Template Tab would be populated manually along with the Categories (upon...
  3. DPChristman

    Automatic Generation of record numbers

    I am trying to create a spreadsheet of records that will automatically numerate cases. There will be up to 1,000 records created annually. Our existing process is a =MAX +1 formula, which requires numbers to be entered manually for each case (and is subject to human error) Normally this would...
  4. S

    Looking for a way to automatically fill a table using data from another table, when providing a certain input.

    I am creating a very large dataset (50-60 thousand unique entries), and I am currently in the process of writing a formula that will fill certain sections automatically, given certain inputs. The autofill would be dependent on 2 variables (V1 and V2), such that I would want the formula to...
  5. I

    VBA: Automatic date update when other cells change?

    Hi, I am trying to find out a way to automatically insert the date in column H, when anything in columns A:G is modified (when in the same row). For example if I modify E3, I want the current time to automatically put in H3. The sheet is called "Master List". I tried looking at some of the...
  6. B

    excel 2013, vba mutiple column Filtering Automatically On Cell Entry

    hi dears, i am using excel 2013 i try to make a traceability for our product manufacturing and delivery MY FORMAT IS (1 - 24 COULMNS) A1PROD DATE A2CLIENT A3WO A4ITEM A5DIA A6QTY (M/Nos) A7ID Nos A8LENGTH (M) A9MATRL A10PR in BAR A11REMASRKS1 A12STIFFNESS A13PROD A14CLBRTN A15QC A16DLVRY...
  7. N

    Fill Cells using a reference Text and Column/Rows

    Hello, I am trying a do cell replacement exercise and have found it a bit challenging. Below is my data and expected results: Current Data: <tbody> Policy No Name_Address Agent Code Date Premium 23456 James Price T83P 2XP 23/05/2013 £35.00 Line1 Line2 Line3 PO1 2TN...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top