counting flowers on the wall

[Lawrence Dodge]

Hi all --
I have a workbook that has 30 tabs, each worksheet represents one day of the month and is basically the same throughout, though some worksheets have extra rows000. Each worksheet has approximately 450 rows and in column G product information is recorded if a certain product (shown on the rows) is made that day. My question is -- how can I condense a worksheet down to only show the rows in which a number (not text) is entered into column G, if that is too difficult then in which anything (of any format) is entered.
Thanks
L.Dodge

 

[Luke M]

Apply a filter to col G, filter for anything > 0.

 

[bobhc]

Turn your data into a table and filter on anything you want, just make sure you include headers

 

[Lawrence Dodge]

Hi all --
I have a workbook that has 30 tabs, each worksheet represents one day of the month and is basically the same throughout, though some worksheets have extra rows000. Each worksheet has approximately 450 rows and in column G product information is recorded if a certain product (shown on the rows) is made that day. My question is -- how can I condense a worksheet down to only show the rows in which a number (not text) is entered into column G, if that is too difficult then in which anything (of any format) is entered.
Thanks
L.Dodge

Please refresh me -- how do I convert it to a table?

 

[Lawrence Dodge]

Apply a filter to col G, filter for anything > 0.

thanks

 

[Somendra Misra]

@Lawrence Dodge

To convert data in to Excel table, select any one cell of data and use shortcut Ctrl+L to convert it to data table. If you data has header, check the option of headers. Just make sure your data has one empty row after the last row of data and one empty column after the last column, otherwise it will select the data (if any) after your main data which you dont want to include in data table.

You can also go through Insert option to create data table if you are using Excel 2010.

Regards,