P
petemccarthy
Ok, this should be fairly simple but I'm a excel novice. I have two
worksheets. One contains all data with each row representing a
different store. I then have another worksheet that is a form. I
need to fill out a form for each store. The information maps the same
every time, just one row down. It looks like this...
WORKSHEET1
A B C D E
1 A1 B1 C1 D1 E1
2 A2 B2 C2 D2 E2
WORKSHEET2
Name: =Worksheet1!A1
Company: Worksheet1!B1
Parts: Worksheet1!C1
----------------------------------------------------------
How do I have it so I can be on Worksheet2 and automatically have the
data move down one row and then print off the form. I have 500 of
these to do with lots of info.
I tried this:
WORKSHEET2
Name: =Worksheet1!A(1 + Worksheet2!F6) and then changing the value
of F6 by 1 each time....but obviously that didn't work.
What's the trick.
Thanks in advance.
worksheets. One contains all data with each row representing a
different store. I then have another worksheet that is a form. I
need to fill out a form for each store. The information maps the same
every time, just one row down. It looks like this...
WORKSHEET1
A B C D E
1 A1 B1 C1 D1 E1
2 A2 B2 C2 D2 E2
WORKSHEET2
Name: =Worksheet1!A1
Company: Worksheet1!B1
Parts: Worksheet1!C1
----------------------------------------------------------
How do I have it so I can be on Worksheet2 and automatically have the
data move down one row and then print off the form. I have 500 of
these to do with lots of info.
I tried this:
WORKSHEET2
Name: =Worksheet1!A(1 + Worksheet2!F6) and then changing the value
of F6 by 1 each time....but obviously that didn't work.
What's the trick.
Thanks in advance.