Managing internal/ external inventory tables

[Travel_Guy]

Hi,

I have a master table used for internal inventory management. I would like to periodically create a table with only SOME of the data to be published to customers (I'm fine with creating it manually at the moment).

The master table holds both columns and rows that I would like to omit in the external version.

Any ideas on how I can accomplish this?

Any help would be appreciated

Thanks!

 

[My Aswer Is This]

We could copy some data to another sheet.
We would to need to know the location: Column and Row numbers you want copied to Sheet(2)
And any criteria on what data to copy over.

 

[Travel_Guy]

We could copy some data to another sheet.
We would to need to know the location: Column and Row numbers you want copied to Sheet(2)
And any criteria on what data to copy over.

Thanks!
I'll look into this option.

Any other ideas?

 

[wynn89]

Hi,

have you tried the advance filter function in excel?

Advanced Filter in Excel - Easy Excel Tutorial

Regards,
Wynn