Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default Macro Printing One Sheet with one change at a time

Basically I have one sheet that displays a table that changes every time I
pull down a different number. So right now I currently have a pull down that
numbers from 1 to 50, but only 1 to 27 give me 27 unique tables, with the
possiblility that 28 through 50 may do the same thing in the future.

So my first question is create a macro that will print all 27 tables even
though they are located one sheet and each table could possibly have more or
less rows then the others, but they all have the same amount of columns.

From there I think I'll be able to figure out how to adapt the Macro to the
situation where I have more then 27 tables.

Can anyone help?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro Help (Uppercase multiple ranges?) Ken Excel Discussion (Misc queries) 14 December 2nd 06 07:23 PM
Comparing Data from two 2 worksheets Roberto R Excel Discussion (Misc queries) 17 December 2nd 06 02:58 PM
error when running cut & paste macro Otto Moehrbach Excel Worksheet Functions 4 August 9th 06 01:49 PM
Want cell ref. to change after sort in other sheet Bullfn33 Excel Discussion (Misc queries) 1 August 6th 06 05:48 PM
Macro to change data in a sheet Diana Excel Discussion (Misc queries) 1 April 28th 06 08:01 PM


All times are GMT +1. The time now is 06:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"