Macro to define a range of serial numbers in Excel

Good Day Forum Members

I have a little query which I present to you all for a possible solution. I have an excel workbook with two sheets. First sheet is named “Data” and second is named “Deposit Slip”.

I have a few columns in “Data” in which the details of various banking instruments are input. Column A in “Data” is of serial number whereby every new entry is given a numeric progressive serial number e.g. 5431, 5432, 5433 and so forth.

“Deposit Slip” consists of a bank’s replica of a pay-in slip in which the information from “Data” is gathered using various formulae including VLOOKUP etc. The focal point of all this is the serial number which allows for the data sorting, selection and displaying information from “Data” to “Deposit Slip”.

Problem:
Now the problem is that, everyday almost 50 new entries are made in “Data” and then all the serial numbers are needed to be typed in one be one in “Deposit Slip” and print out is taken after each and every input of serial number in cell 4 of column AC of “Deposit Slip”.

Example:
New entries made in “Data” from serial number 5450 to serial number 5500. Now, I need to input one by one the serial number in Cell 4 of Column AC of “Deposit Slip” so that the formulae will pick up and display information in “Deposit Slip” and then I will print out the sheet. It means that I have to input 50 serial numbers and press print 50 times.

Requirement:
I wish to define a range of serial numbers in “Deposit Slip” like FROM 5450 TO 5500 so that I had to input the range only and all 50 different pay in slips are printed out with a single command. I wish to have macro for that. Unfortunately, I have no expertise in recording macros. Any help will be genuinely appreciated.

Hi

I am attaching a sample file for easy reference in perusal of my earlier post.

Regards

Dear Forum Members

I have also uploaded a sample worksheet and have posted my problem as well. I would appreciate help from all of you.

Regards

In sheet "Data': select cells A11:A12.
Drag down this selection further in column A, using the 'cross' on the right-undercorner of cell A12.

Dear Roy

Thank you for your help. But I fear this is not what I was hoping for. Maybe I am unable to get my point across clearly. I am attaching the modified worksheet for your perusal.

All I require is as follows:

a) I input a serial number that starts the range in Cell K2 of sheet named "Deposit Slip"
b) I input a serial number that ends the range in Cell K5 of sheet named "Deposit Slip"
c) The information in sheet named "Deposit Slip" changes when the serial number in Cell K2 changes.
d) I require a macro that changes the serial number, one by one, in Cell K2 upto the serial number mentioned in cell K5 and subsequently prints out the sheet named "Deposit Slip" for every change in the serial number (within the range defined respectively in Cell K2 and Cell K5) all by simply running that macro. I do not wish to have a print preview.

Hope it clarifies the matter.

Thanks Roy for your assistance. I really appreciate it. Just one simple question more. How do I copy your macro with the command button in your file to use it with the original file? I had attached a sample worksheet. I wish to use your code in a separate worksheet that has identical sheets and almost identical data.

Awaiting your response.
Regards