Printing an incrementing table value for each print

[DThib]

Hi,
I am trying to figure code to take a column of numbers (1-27) and when printed move the entire set to (28-55), etc.
The form is printed, and these numbers would be the line count for each sheet.

No idea how to start coding this, help!!!!!

 

[dreid1011]

As far as moving the set of numbers down, maybe this:

Private Sub PrintRows()
'Print code goes here
Range("A1:A27").Insert xlShiftDown
End Sub

More information is needed if you are expecting a different result.

 

[DThib]

I have an incrementing code in the template for this form:

Description/Reason	Receiving Report #	Origin (INT/DOM)
	RR 044479
	RR 044480
	RR 044481
	RR 044482

When a printed it goes into a logbook. The next print out should have the the next number inline going down the 27 rows.

 

[dreid1011]

That really doesn't tell me anything. I'm going to need a very specific example of the input and desired output.

 

[DThib]

Hi,
Thanks for looking at this. The only formula I tried is here:

=IF([@Date]="",CONCAT("RR ", G3+1),"")

in the column above if I use it.
Excel 365
I don't know where to begin writing a macro for what I need.

 

[dreid1011]

Hi,
Thanks for looking at this. The only formula I tried is here:

=IF([@Date]="",CONCAT("RR ", G3+1),"")

in the column above if I use it.
Excel 365
I don't know where to begin writing a macro for what I need.

And I don't know where to begin trying to help because I am now unsure what you want. First you asked about shifting rows down after printing, now you are saying you were using a formula? If I am to continue to help, I need you to explain step by step exactly what you are trying to achieve, and please provide sample data you start with, and the desired result.

 

[DThib]

Sorry for the confusion. My bad.

I am generating a sheet with these number IDs to account for each line on each page. I want to continue the iteration in each print. So if the last row on last print is RR 12345, the first row on the new print would start at RR 12346.

Not sure if it is possible.

 

[dreid1011]

Sorry for the confusion. My bad.

I am generating a sheet with these number IDs to account for each line on each page. I want to continue the iteration in each print. So if the last row on last print is RR 12345, the first row on the new print would start at RR 12346.

Not sure if it is possible.

Okay, that's a step in the right direction. What is the range being printed, and what happens to it after it is printed? Are you printing the same range on a sheet and changing the data each time or is the print range moving each time?

 

[DThib]

26 Rows per sheet.
The increment is one per row and 26 for the sheet. The sheet is printed, and the form filled out. When full, the next sheet is used.
The only online use at this time is the table to be printed. (paper based)

 

[dreid1011]

Where are these 26 rows? Are they on sheet 1, 2, 3 etc, what is the sheet name? Are they in column A, B, C etc? How many columns are included?

When full, the next sheet is used.

What next sheet? Is the print range moving down the sheet, is it moving to the next worksheet tab, is it staying in the same place on the same sheet and the data is moving somewhere else or being deleted?

When I asked for specific details, this is what I meant... I can't help if you just keep giving me vague descriptions. I know it makes sense to you, but I know absolutely nothing of your data and what it looks like.