create list

  1. R

    How do I dynamically create a new list from an existing list?

    I want to build a dynamic list from an existing list. From the image you can see the list of budget items in column C. Some of those items are "savings items". Meaning I don't buy tires every month, but I want to save a little every month towards a future purchase of tires. The list in Column...
  2. tljenkin

    Determine Unique List and Create folders etc

    Hi All, I have a report which has 4 sheets, lets call it the Master file (MF) MF has been set to manual calculation because of the amount of calculations required from the formulas within. Sheet 1-3 are reports; and Sheet 4 has a 4-column table (Tab1) which is about 2000 rows tall (headers in...
  3. G

    VBA create a List from selected inputs on a seperate worksheet

    All, I am trying to create a macro which creates a list on a seperate worksheet. The data i have is arranged in different cells in "Sheet 1" but predominantly looks like: <tbody> Room No. Lecture Rooms 12 Seminar Rooms 3 Dining Hall 2 Sports Hall 2 Activity Rooms...
  4. Smokeyham

    Create a List of Absolute Reference in multiple worksheet

    I have a spreadsheet and would like to create a list of the value in an absolute reference from multiple worksheets. Here is what the formulas for the final result might look like: ='Management Analyst'!B2 ='Human Resources'!B2 The spreadsheet is quite large (lots of worksheets), so the...

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