Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I create a Macro that can update a sheet?
Hi all,
I am trying to create a macro that can update the entire sheet. I have this data entry sheet and I also have a data.xls file that is converted from a text file. This data.xls file changes every month. So, instead of typing all those numbers every month into the data entry sheet, which is a different workbook, I want to create such a macro that when I run it, it should load all the numbers for the new month into the data entry sheet. If I make a user form in Macro and add a button and a text box to it, what would the overall code be? This way, if the user wants to see a certain month, he types it into the text box and clicks on the button and the sheet will load the numbers of that month. You can email me I would be so happy if you guys help me out. Thank you ! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making a macro on a template update with new each new sheet create | Excel Discussion (Misc queries) | |||
To create an Macro and alco to update an graph | Excel Discussion (Misc queries) | |||
How can I have a macro update the sheet? | Excel Discussion (Misc queries) | |||
Macro to update sheet | Excel Discussion (Misc queries) | |||
Macro to Create a Chart and Update it Automatically | Charts and Charting in Excel |