Transfer data from one sheet to another and make report

[sujittalukde]

I want get an automate procedure to make a report.

The user will enter data in sheet 1. each row will be treated as a record and will containn some fields. This fields will be transferred to sheet 2 at appropriate cells for each record but the user can print only one report alias record at a time That is the same format will be used in sheet 2 report for all the records but only one report will be printed at a time. A button will be placed on sheet 1 which will on clicking pop up an input box

Wherein the user will put the serial number of the record and the sheet 2 will copy the data of that record to sheet2.

Suppose, sheet 1, row 2 is the serial number 1. the user will click the button, named “select record to print” and an input box will poop up wherein he will put 1 (the serial number). If he goes to sheet 2, he will see the data of serial no. 1

A screen shot is given as a sample. Please make the code dynamic so that I can change the same to suit my needs.

For sheet1 (Data Entry)

VBAX - sujittalukde - ShowSheetBasedOnROW.xls
	A	B	C	D	E	F	G
1	Sl No.	Name	Address	Phone number	Year	Amount	Bank
2	1	ABC	XYZ	22	2007	25000	A BANK
3	2	DEF	SDF	332	2006	30000	TEK BANK
4	3
DataEntry

Sheet 2 (Report)

VBAX - sujittalukde - ShowSheetBasedOnROW.xls
	A	B	C	D	E	F	G	H	I
3	Name			Bank			Year
4
5	Phone Number
6
7
8
9
10
11	Address
12
13
14
15
16	Amount
17
18	Add: 10%
19
20	Total
21
Report

 

[sujittalukde]

Please help