Exchanging information from one sheet to another.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet with basically inventory on it. I want to make another sheet for a wholesale price list. I want the information from sheet1 to move automatically into sheet2 if a certain cell is empty in sheet1. To be more detailed, I have a list of slabs of granite, if they are not on hold for a customer i want them to be included in the wholesale price list. There is a column for last names of customers who put slabs on hold. If the cell for the customer's name is empty the slab is available to sell. Each slab has it's own row on the spreadsheet. there are about 9 columns for each row. I want to move the whole row into sheet2 if it is an available slab automatically. (I would prefer only a couple of rows be moved into sheet2, but i think it will be easier with the whole row.) Let me know if this is possible. If you need more information let me know. Any suggestions will help.
 
Kile,

I believe your setup requires VBA programming for entering - and removing - rows
on sheet2.

As an alternative you may use Data>Filter>Autofilter on the customer column
(empty/not empty) to show the slabs that are either on hold or not.
To hide columns, depending on what you filter on, you can use View>Custom Views

HTH
Anders Silven

Kile said:
I have a spreadsheet with basically inventory on it. I want to make another
Click to expand...
sheet for a wholesale price list. I want the information from sheet1 to move
automatically into sheet2 if a certain cell is empty in sheet1. To be more
detailed, I have a list of slabs of granite, if they are not on hold for a
customer i want them to be included in the wholesale price list. There is a
column for last names of customers who put slabs on hold. If the cell for the
customer's name is empty the slab is available to sell. Each slab has it's own
row on the spreadsheet. there are about 9 columns for each row. I want to move
the whole row into sheet2 if it is an available slab automatically. (I would
prefer only a couple of rows be moved into sheet2, but i think it will be easier
with the whole row.) Let me know if this is possible. If you need more
information let me know. Any suggestions will help.
 
Back
Top