Want source (raw) data to populate in other sheets when updated daily

Greeting Excel Friends,

I was hoping someone can help me with a problem I have.

When I update a series of data daily (creating new row) I would like this data to feed into other worksheets. A new row will be inserted at the bottom of my large dataset. I assume it is easier to place the new data at the bottom of my dataset instead of having to create a new row at the top.

Please take a look at my spreedsheet to fully understand my question.

Thanks All!forumexample2.xlsx

PS

Just to be clear I am looking for the data to feed into the "Rates" sheet as a simple formula =(100-data) and the '3M Calendars" sheet to simply subtract one piece of data from another.

Try this:

Please Login or Register  to view this content.

@ CWatsonJr,

Start your own thread and I'll try to help you

Orin, I think CW was offering a suggestion to the OP, not asking a question? (unless I missed the question )

Hi Ford,

We, obviously, have different interpretations

@ CW - please elucidate!

Thanks CW - reparation is bestowed

Hi pgp,

Sorry

Directions for running the routine(s) just supplied

If you haven't used macros before you'll need to go to:
File- options - trust center -trust center settings - macro settings ,
the second option down (disable all macros with notification)

Then - Copy the code to the clipboard

Open your Workbook

Press ALT + F11 to open the Visual Basic Editor.

Select "Module" from the Insert menu

Type "Option Explicit" then paste the code under it

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name
*Be sure to save the book with the code as Macro-Enabled

like this:

Thanks gain for all your help! really appreciated

I did everything as instructed but noticed a few problems/doubts. first it seems my function keys weren't executing as expected. i.e. visual basic editor didn't open with ALT + F11, F5 unresponsive

But anyway, I think everything was saved correctly in Visual basic editor.

So this automatically creates the macro correct? Do I need to assign the macro to a button?

I just answered my own question. It did work in the end...thanks a million for your time and help!

You're welcome and thanks for the rep!