How to link an input sheet to a master sheet.

**PaddyP** · 09-20-2012, 01:47 AM

This is a very basic example but it should illustrate what I would like to accomplish.

So in the spreadsheet I have attached, the top part is my "Input Sheet" with the bottom part being the "Master Sheet"

I put them on the same sheet for convenience but I would actually like the top to be on one sheet, and the bottom to be on a separate sheet.

I then want to enter the data in the top of the sheet on a daily basis and have it transferred to the other sheet matching with the corresponding date.

Is there an easy way to do this?

Thanks.

**arlu1201** · 09-20-2012, 02:05 AM

Should the data in the entry sheet be cleared after the data is copied to the 2nd sheet?

**PaddyP** · 09-20-2012, 02:56 AM

Yes, once the data is entered on the input sheet it will be cleared and re-used for the next day when I change the date.

**arlu1201** · 09-20-2012, 08:01 AM

Try this

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button

**PaddyP** · 09-20-2012, 03:17 PM

Thanks for the reply, but I can't get it to work.

Just to be clear, this is what I want to do.

I'm trying to create a macro that will copy data from a data entry sheet (Sheet 1) into a summary sheet (sheet 2). The entry sheet is going to be cleared daily so I can't use a formula just to reference it. I want the user to be able to enter a date, run a macro, and have the macro copy the data from the entry sheet into the cells for the corresponding date on the summary sheet.

I am very new to macros, so I am not sure if I am just wasting your time as I am unsure if I will be able to pull this off on my own.

If you have any further advice or suggestions I would love to hear them.

**arlu1201** · 09-21-2012, 01:32 AM

Ok, its very simple. What you need to do is, enter the data into the file, then select View-> Macros and run the macro given (provided you have already copied the macro into your file as per the steps given in post 4.) Automatically the data will be copied to the other sheet and the entry sheet cleared.

See the attached file. I have put in the button for you and also completed a few transfers.

**PaddyP** · 09-21-2012, 02:36 AM

Arlu you are one smart, and extremely generous, [contributor]. I am very grateful for your help!

I can't quite set it up myself but that is fine. I can use your updated spreadsheet and incorporate that into my own work.

Thank You so very much.

Pat