Need Help with copying and pasting with var.
 

HI THere Excel Guru's

I have a problem that I cannot solve and have read about 200 posts here
this morning but cannot find anything that suits.

This is what I want to do.

I have a master workbook with each worksheets name as a month.

THen I have another workbook with two worksheets - Summary and Current

Ok I want to display in the current sheet the range A1:b65
BUT

I want to be able to choose individual months in the Master workbook
and display the above range via the variable month.

Should I do this with a copy command or import.

Please give suggestions and how to.


thanks for all the previous help


--
Mikeice
------------------------------------------------------------------------
Mikeice's Profile: http://www.excelforum.com/member.php...o&userid=22467
View this thread: http://www.excelforum.com/showthread...hreadid=382987

Need Help with copying and pasting with var.
 

Consider setting up an Advanced Filter on thr CURRENT sheet, to pull
information from one of the monthly sheets.

If you perform this operation once, while running the macro recorder, it
should not be difficult to generalise the resultant code to operate on a
user selected month sheet.

If you are not familiar with the Advanced Filter feature, see Debra
Dalgleish's pages on Advanced Filter at:

http://www.contextures.com/xladvfilter01.html

and:

http://www.contextures.com/xladvfilter02.html

Note particularly, Debra's step by step explanation for 'Extracting Data To
another Worksheet'

---
Regards,
Norman



"Mikeice" wrote in
message ...

HI THere Excel Guru's

I have a problem that I cannot solve and have read about 200 posts here
this morning but cannot find anything that suits.

This is what I want to do.

I have a master workbook with each worksheets name as a month.

THen I have another workbook with two worksheets - Summary and Current

Ok I want to display in the current sheet the range A1:b65
BUT

I want to be able to choose individual months in the Master workbook
and display the above range via the variable month.

Should I do this with a copy command or import.

Please give suggestions and how to.


thanks for all the previous help


--
Mikeice
------------------------------------------------------------------------
Mikeice's Profile:
http://www.excelforum.com/member.php...o&userid=22467
View this thread: http://www.excelforum.com/showthread...hreadid=382987

Need Help with copying and pasting with var.
 

Assume you put the text Jan in cell F1

in another cell

=indirect(F1 & "!A1")

to display Jan!A1 or Feb!A1 depending on what is in F1

--
Regards,
Tom Ogilvy

"Mikeice" wrote in
message ...

HI THere Excel Guru's

I have a problem that I cannot solve and have read about 200 posts here
this morning but cannot find anything that suits.

This is what I want to do.

I have a master workbook with each worksheets name as a month.

THen I have another workbook with two worksheets - Summary and Current

Ok I want to display in the current sheet the range A1:b65
BUT

I want to be able to choose individual months in the Master workbook
and display the above range via the variable month.

Should I do this with a copy command or import.

Please give suggestions and how to.


thanks for all the previous help


--
Mikeice
------------------------------------------------------------------------
Mikeice's Profile:
http://www.excelforum.com/member.php...o&userid=22467
View this thread: http://www.excelforum.com/showthread...hreadid=382987

Need Help with copying and pasting with var.
 

Does indirect work if the workbook is elswhere on another server in
workbook that is closed??

I couldn't get it to work.

Any further info much appreciate

--
Mikeic
-----------------------------------------------------------------------
Mikeice's Profile: http://www.excelforum.com/member.php...fo&userid=2246
View this thread: http://www.excelforum.com/showthread.php?threadid=38298

Need Help with copying and pasting with var.
 

No, indirect doesn't work on closed workbooks. I doubt you will find
anything except VBA code that will support doing something like that.

--
Regards,
Tom Ogilvy

"Mikeice" wrote in
message ...

Does indirect work if the workbook is elswhere on another server in a
workbook that is closed??

I couldn't get it to work.

Any further info much appreciated


--
Mikeice
------------------------------------------------------------------------
Mikeice's Profile:
http://www.excelforum.com/member.php...o&userid=22467
View this thread: http://www.excelforum.com/showthread...hreadid=382987

Need Help with copying and pasting with var.
 

Hi Mikeice,

I misread:

THen I have another workbook with two worksheets - Summary and
Current

as

THen I have another two worksheets - Summary and Current

In consequence, my response was based on the mistaken premise of a single
workbook scenario.

My apologies, I should read more attentively!

---
Regards,
Norman



"Norman Jones" wrote in message
...

Consider setting up an Advanced Filter on thr CURRENT sheet, to pull
information from one of the monthly sheets.

If you perform this operation once, while running the macro recorder, it
should not be difficult to generalise the resultant code to operate on a
user selected month sheet.

If you are not familiar with the Advanced Filter feature, see Debra
Dalgleish's pages on Advanced Filter at:

http://www.contextures.com/xladvfilter01.html

and:

http://www.contextures.com/xladvfilter02.html

Note particularly, Debra's step by step explanation for 'Extracting Data
To another Worksheet'

---
Regards,
Norman



"Mikeice" wrote in
message ...

HI THere Excel Guru's

I have a problem that I cannot solve and have read about 200 posts here
this morning but cannot find anything that suits.

This is what I want to do.

I have a master workbook with each worksheets name as a month.

THen I have another workbook with two worksheets - Summary and Current

Ok I want to display in the current sheet the range A1:b65
BUT

I want to be able to choose individual months in the Master workbook
and display the above range via the variable month.

Should I do this with a copy command or import.

Please give suggestions and how to.


thanks for all the previous help


--
Mikeice
------------------------------------------------------------------------
Mikeice's Profile:
http://www.excelforum.com/member.php...o&userid=22467
View this thread:
http://www.excelforum.com/showthread...hreadid=382987