Devam Ediyor

490492 Excel 2007 - VBA Macro for Print

.

What I need is a VBA Macro (Module) that solves the following task:

I have an Excel sheet that calculates and fills cells after I entered 1 value in one cell (=$A$2).

Afterwards I want that several ranges are printed one after the other , each range on a separate page - maximum 8 pages by one value entered in A2. The header name of these pages is created from the following values:

$A$2 $B$2 Current Date ([url removed, login to view]) PageNo

Example: 92224 Amberg [url removed, login to view] Page 1

No other general info on these pages and no grid.

Page 1: A1:H36

Page 4: A37:H71

Page 3: A72:H100

Page 4: A101:H132

If value of $B$2 = 0 -> no more pages are printed

If value of $B$2 = 1 -> 4 more ranges are printed on 4 pages

Page 5: O1:J36

Page 6: O37:J71

Page 7: O72:J100

Page 8: O101:J132

Plus I want a routine that I can enter from 1 up to 10 different values in cell $A$2 and that these are worked on 1 by 1 and thus producing maximum 10 x 8 pages = 80 Pages

For an Excel expert this project should take some minutes only.

Thanks for your bids!

Beceriler: Her şey Kabul, Excel

Daha fazlasını görün: excel expert up, what is vba in excel, what is vba, what is macro in excel, vba for, print vba, excel sheet expert, yy, vba, vba expert, vba excel macro, project on vba, print only, need a excel expert, macro, Macro vba, for print, expert vba, excel vba macro, excel vba expert, excel to vba, Excel Macro VBA, excel expert, Excel and VBA, excel 7

İşveren Hakkında:
( 128 değerlendirme ) Mering, Germany

Proje NO: #2236403

Seçilen:

sbhask2k

Hey. I am interested in this work. Kindly let me know.

3 gün içinde 50$ USD
(35 Değerlendirme)
4.8