cambralenta
New Member
- Joined
- Nov 30, 2009
- Messages
- 21
I need help to make a macro for this:
I have 8 Columns with 55 Rows of data, some have names (always Top Cells), most have blank Cells (Bottom Cells): Range (A3:H57)
<tbody>
</tbody>
Below this, I have data Areas (STD1: Area 1 - A61:G64, Area 2 - A65:G68...to Area 55; STD2: Area 1 - H61:N68, Area 2 - H65:N68,...), that catch information from another sheet according to names for each corresponding column above. Range Areas (A61:BD280)
I need a MACRO to print only the areas that correspond to the CELLS with data! In this example it will be:
PRINT STD 1: (A61:G76); PRINT STD 2: (H61:N88)... etc."
It will be nice to have a Macro to print all areas with data, in arranged 1, 2, 3... pages (printed areas don´t need to be sequential).
Thank you in advance for your patience to reed this!
Any suggestion how to do this?
I have 8 Columns with 55 Rows of data, some have names (always Top Cells), most have blank Cells (Bottom Cells): Range (A3:H57)
STD 1 | STD 2 | STD 3 | MM 1 | MM 2 | MM 3 | VET | INF | |
txt1 | txt1 | txt1 | txt1 | txt1 | txt1 | 1 | ||
txt2 | txt2 | txt2 | txt2 | txt2 | 2 | |||
txt3 | txt3 | txt3 | txt3 | 3 | ||||
txt4 | txt4 | txt4 | 4 | |||||
txt5 | 5 | |||||||
txt6 | 6 | |||||||
txt7 | 7 | |||||||
... |
<tbody>
</tbody>
Below this, I have data Areas (STD1: Area 1 - A61:G64, Area 2 - A65:G68...to Area 55; STD2: Area 1 - H61:N68, Area 2 - H65:N68,...), that catch information from another sheet according to names for each corresponding column above. Range Areas (A61:BD280)
I need a MACRO to print only the areas that correspond to the CELLS with data! In this example it will be:
PRINT STD 1: (A61:G76); PRINT STD 2: (H61:N88)... etc."
It will be nice to have a Macro to print all areas with data, in arranged 1, 2, 3... pages (printed areas don´t need to be sequential).
Thank you in advance for your patience to reed this!
Any suggestion how to do this?