new data

  1. S

    Automatically populate a sheet from another sheet and print the same sheet multiple times.

    I am new to Excel. Cell A1 in "Sheet 1" has an autocomplete drop down menu of 1500 items. I have set things up such that when a selection is made in A1 it triggers the auto population of 10 other sheets (using VLOOKUP). I have a CLEAR ALL Button on "Sheet 1". This also resets data on the...
  2. K

    Cell Change Time Stamp

    I don't know if this is possible, but I thought I would give it a shot anyway. Is there a formula, or series of formulas that can show the last time a given cell was changed? Or at least, out of the choice of 2 cells, is there a formula that can show which one was updated most recently? (Must...
  3. W

    Importing information to a master file from several copy's of the same file

    I have a workbook with several worksheets that are all identical in structure and layout representing sales data fed to me from different stores. they all contain 3 distinct blocks of information made from a number of rows (containing different categories of sales) and columns (containing...
  4. V

    VLOOKUP not bringing back new data

    Hello. I hope someone can help - I've searched the internet numerous times and cannot locate the the answer thus far! I have a sheet which has a number of VLOOKUP functions that brings back personal details from an employee number (first name, last name, mobile phone number etc.). The sheet...
  5. B

    A formula that will pickup a new cell and exclude the prior cells

    Good afternoon, I'm trying to figure out a formula that will pickup the current month data automatically but at the same time exclude the prior months data. This will be done in a seperate summary tab from the source data tab. I should mention that this is a monthly report. So every month...
  6. E

    Add classification to new data in database

    Hi everyone, I'm having a bit of trouble finding anything on the following problem i've been having: I have a database with about 20 columns spanning some 40 thousand rows, I will be adding about 3 o 4 thousand rows every week... The issue is that these rows do not contain all of the columns...
  7. L

    macro help adding new entries to a list

    Hey again, I'm trying to write a macro. Basically I have a set of data that I download every week. It is always in the same format with an ID in the leftmost column. Basically I want to just download the data and then run this macro and have it add the new data into a list. So as an...

Watch MrExcel Video

This Week's Hot Topics

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
Top