I am trying to put together a very simple "inventory kits" workbook for a
friend's retail store. I have a sheet that has a master list of parts,
individual sheets for products that are made up of those parts, and a sheet
that lists only customer prices for each of those products.

When comprising the lists of parts that the products are made of, how can I
reference multiple cells from sheet one to sheet 2? In other words, I want
cells a4 through d4 in sheet 2 to reference cells a32 through d32 in sheet 1.
Can I do that with one motion rather than having to put an = sign in each of
the four cells and then refer back to sheet 1 after every = sign?

Try this: type '=' into a4 in sheet 2, click on a32 in sheet 1, press enter.
Then go back to sheet 2, select a4, and then drag the tiny box in the bottom
left corner of the cell down to d4. Check to make sure each cell in sheet 2
refers to the proper one in sheet 1. Hope this helps!

"Penny Cooper" wrote:

I am trying to put together a very simple "inventory kits" workbook for a
friend's retail store. I have a sheet that has a master list of parts,
individual sheets for products that are made up of those parts, and a sheet
that lists only customer prices for each of those products.

When comprising the lists of parts that the products are made of, how can I
reference multiple cells from sheet one to sheet 2? In other words, I want
cells a4 through d4 in sheet 2 to reference cells a32 through d32 in sheet 1.
Can I do that with one motion rather than having to put an = sign in each of
the four cells and then refer back to sheet 1 after every = sign?