How can I read specific rows from another worksheet?

[Dazed]

I am not an in-depth Excel user, but I have a question I hope somebody can help me with. Here's what I'm trying to do: I have a worksheet that will have data imported into it. It consists of about 30 columns and, depending on the file I import, up to several hundred rows. That part I've figured out. What I want to do is to have another worksheet where I can review each row individually. I need to do something so that when I click a button, it will import the data from, say, row 2. The next time I click the button it will get the data from row 3 and so on. This worksheet will not have the rows and columns laid out the same as the worksheet with the raw data (so column "f" on the raw data worksheet might be column "m" on this worksheet). Does this make any sense and if so, can you offer any suggestions? Thanks for whatever advice you can provide! :D

[just_jon]

Can you provide details as to which columns from the one sheet should appear in which columns on the other sheet?

[Dazed]

I haven't gotten that far along in the process yet. I wanted to make sure that it was possible before I went any further. The whole purpose I am putting this together is so that the data for each individual (each row will represent one individual) can be reviewed on its own on a unique page. Not every column from the raw data worksheet will be used, but most of them will be. I know I'm probably not explaining myself very well, so feel free to ask me to clear up whatever doesn't make sense. Thanks again! :D

[Dazed]

I tried the following - ='Data Sheet'!A:'Account Review'!D1

It didn't work. What I thought I'd try is selecting the column from the raw data sheet and then having a number in D1 of the sheet in which I am viewing. By changing the number in cell D1, it would show the appropriate column and row from the raw data sheet. Is something like this possible?

[just_jon]

I haven't gotten that far along in the process yet. I wanted to make sure that it was possible before I went any further. The whole purpose I am putting this together is so that the data for each individual (each row will represent one individual) can be reviewed on its own on a unique page. Not every column from the raw data worksheet will be used, but most of them will be. I know I'm probably not explaining myself very well, so feel free to ask me to clear up whatever doesn't make sense. Thanks again! :D

what you seem to want to do should not be too hard. If I might make a suggestion, when constructing the layout of the master sheet (which would hold all individuals) try to have the name in the first column. Additionally, the use of column headings may also become of use on down the road. If I get time, I will try to post a sample of what I have in mind. Check back.

[just_jon]

Something like this (the items in blue are your entries, restricted via data validation and able to be filled via drop-down box) --

******** ******************** ************************************************************************>

Microsoft Excel - Book1 ___Running: xl2000 : OS = Windows ME
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
B2C2D2E2F2 =
	A	B	C	D	E	F
1	Emp*Name	SSN	Supv*Name	DOB	Phone	Address
2	AJ*Foyt	999-00-4567	None	02/14/38	555-4444	101*Texas*Ave
Single *

[HtmlMaker 2.32] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

from something like this --

******** ******************** ************************************************************************>

Microsoft Excel - Book1 ___Running: xl2000 : OS = Windows ME
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
G3 =
	A	B	C	D	E	F	G
1	Emp*Name	DOB	SSN	Grade	Supv*Name	Phone	Address
2	Mario*Andretti	3/13/1940	123-99-0987	16	P.*Jones	555-1212	100*Oak*Street
3	AJ*Foyt	2/14/1938	999-00-4567	17	None	555-4444	101*Texas*Ave
Master *

[HtmlMaker 2.32] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

[Dazed]

It's very close. My "output" worksheet data will not be in the same location (data in a2 in the raw data may be in c15 in the "output" worksheet) as the raw data, though, and I will not be selecting records by name as in your example, but it is very close. :D

[just_jon]

When you're further along in your devolpment post back. It should be very straight forward ... FLM :o {Famous Last Words}

[Dazed]

Well, my raw data sheet has titles in row 1. Data can be filled in from A2 through BJ1001. My first column (A) is account number. Cell A1 is "Account Number" and cell A2 is 1 (the first account). On my "output" worksheet, I want the account number "1" to post in cell B3. Then, with whatever I can work out, each time they click on a button (I've yet to figure out exactly how), it would select the next record from the raw data worksheet. I have not yet assigned cell locations for the 25 or so fields that I want filled from the raw data worksheet, but they would all have to advance to the next record when the button is clicked. Am I making any sense? :D

[just_jon]

When you get your destination sheet firmed up, we can fix it, I believe.