G
Guest
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?
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?