Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
AUTO INSERT PAGE BREAK FOR EACH COPIED HEADING
I have a Macro that hides and copies visible cells to worksheet 3, but, I
have a certain row (the heading description for the next page) that needs to wait till the next page break befor copying so that I don't have to manually adjust them. Moving them manually takes 25 minutes 2-3 times a day, if there is a way it would really save me. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
AUTO INSERT PAGE BREAK FOR EACH COPIED HEADING
Not clear from your description what needs doing.
Is the heading description the same for each page or is it different on each page? Post your code and maybe we can figure out where to place a pagebreak command. Gord Dibben Excel MVP On Tue, 20 Dec 2005 15:10:03 -0800, "wil4d" wrote: I have a Macro that hides and copies visible cells to worksheet 3, but, I have a certain row (the heading description for the next page) that needs to wait till the next page break befor copying so that I don't have to manually adjust them. Moving them manually takes 25 minutes 2-3 times a day, if there is a way it would really save me. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
AUTO INSERT PAGE BREAK FOR EACH COPIED HEADING
The heading is different for every page
"Gord Dibben" wrote: Not clear from your description what needs doing. Is the heading description the same for each page or is it different on each page? Post your code and maybe we can figure out where to place a pagebreak command. Gord Dibben Excel MVP On Tue, 20 Dec 2005 15:10:03 -0800, "wil4d" wrote: I have a Macro that hides and copies visible cells to worksheet 3, but, I have a certain row (the heading description for the next page) that needs to wait till the next page break befor copying so that I don't have to manually adjust them. Moving them manually takes 25 minutes 2-3 times a day, if there is a way it would really save me. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
AUTO INSERT PAGE BREAK FOR EACH COPIED HEADING
And where do these headings come from? When in the code sequence do they get copied? Post your code. Gord On Tue, 20 Dec 2005 16:20:02 -0800, "wil4d" wrote: The heading is different for every page "Gord Dibben" wrote: Not clear from your description what needs doing. Is the heading description the same for each page or is it different on each page? Post your code and maybe we can figure out where to place a pagebreak command. Gord Dibben Excel MVP On Tue, 20 Dec 2005 15:10:03 -0800, "wil4d" wrote: I have a Macro that hides and copies visible cells to worksheet 3, but, I have a certain row (the heading description for the next page) that needs to wait till the next page break befor copying so that I don't have to manually adjust them. Moving them manually takes 25 minutes 2-3 times a day, if there is a way it would really save me. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
AUTO INSERT PAGE BREAK FOR EACH COPIED HEADING
I have been trying to make a template for bidding home restoration.
The bid needs to have two lists of work descriptions with quantities and prices. Then any rows with quantities left with zero will be hidden in each list independently of each other. There is a diagram and room name at the top of each page. The problem I am having with the lists being on the same worksheet is when I hide the rows with zero values on one side it hides the other side. I have put the lists on separate worksheets and then run these two macros which hides then copies to worksheet3. I then manually adjust the lists to get them lined up and move page breaks. I would really like to have two ranges on the same page. Either way, I need an auto adjusting page break, or maybe a way to auto line up the room headings. Thanks, Wil Sub HideWD() Dim rn As Range Dim rng As Range Set rng = Range("F11:F900") '<< For Each rn In rng.Cells '<< If (rn.Value = 0 And rn.Value < "") Then Rows(rn.Row).Hidden = True End If Next ActiveSheet.UsedRange.SpecialCells(xlCellTypeVisib le).copy _ Destination:=Sheet3.Range("A1") End Sub Sub HideR() Dim rn As Range Dim rng As Range Set rng = Range("F11:F900") '<< For Each rn In rng.Cells '<< If (rn.Value = 0 And rn.Value < "") Then Rows(rn.Row).Hidden = True End If Next ActiveSheet.UsedRange.SpecialCells(xlCellTypeVisib le).copy _ Destination:=Sheet3.Range("H1") End Sub "Gord Dibben" wrote: And where do these headings come from? When in the code sequence do they get copied? Post your code. Gord On Tue, 20 Dec 2005 16:20:02 -0800, "wil4d" wrote: The heading is different for every page "Gord Dibben" wrote: Not clear from your description what needs doing. Is the heading description the same for each page or is it different on each page? Post your code and maybe we can figure out where to place a pagebreak command. Gord Dibben Excel MVP On Tue, 20 Dec 2005 15:10:03 -0800, "wil4d" wrote: I have a Macro that hides and copies visible cells to worksheet 3, but, I have a certain row (the heading description for the next page) that needs to wait till the next page break befor copying so that I don't have to manually adjust them. Moving them manually takes 25 minutes 2-3 times a day, if there is a way it would really save me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert copied cells | Excel Discussion (Misc queries) | |||
Page Break | New Users to Excel | |||
Removing a page break from excel | Excel Worksheet Functions | |||
page break preview | Excel Discussion (Misc queries) | |||
slow page break previews | Excel Discussion (Misc queries) |