View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mikeice[_24_] Mikeice[_24_] is offline
external usenet poster
 
Posts: 1
Default 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