Macro to import cells from a work book into a new work book?

[talking_goat]

Ok, my boss (has anyone seen the movie Office Space???), wants me to create a macro (or some automation) so that we can click a button and draw data from different cells of an excel work book (the data source) and plug this data into a new work book. The cells in the data source work book are also in a variety of sheets within that work book.

Catch is, I'm no guru when it comes to spreadsheets. I'm sure that this is possible, I'm just having trouble doing it. Can anyone help me out with how to do this? Or point me into the right direction?

Any help is appreciated. Thanks

 

[tactps]

Use the macro recorder (see Tools, Macro, Record Macro) and run through the steps you want.

Better still, just use formulas and update your links.

 

[talking_goat]

I tried the macro recorder but kept getting an error. What I'd like to be able to do is run something so that the macro pickups the data in cells A1, A3, A10 in sheet one, A1, A3, A10 in sheet two etc. and then places this data in a completely new work book. Is that possible?

 

[talking_goat]

Use the macro recorder (see Tools, Macro, Record Macro) and run through the steps you want.

Better still, just use formulas and update your links.

So where would I store the macro? in a template work book? I'm sorry I'm a little confused. I have used the macro recorder before and got it to work, but it's just not doing it for me this time.

 

[talking_goat]

 

[Legacy 51064]

You can store the macro in the module or you can link it to a button. Do the tab name change? Are the same cells always referenced?

 

[talking_goat]

You can store the macro in the module or you can link it to a button. Do the tab name change? Are the same cells always referenced?

The cells should always be the same reference. The tabs at the bottom, or sheet names change.