Pull selected data from a table

[zJenkins]

Hi,

I'll try to explain the basic idea of what I'm trying to do. I have two Worksheets, 10 columns by 34 rows. Each row is for one product. The first 5 columns are for product description purposes, and the last 5 columns are numbers that are updated each month. I want to be able to fill out the new numbers for each product each month on the first worksheet and copy the information over to the second worksheet, however, I only want to copy the products that have new numbers associated with them (ie some products don't get used so the cells 6-10 will be left blank. Let me know if that makes sense or if you need more information.

Thanks for your input!

 

[RudiS]

If I am envisioning your scenario correctly, you can copy the new month data and pastespecial (Sskip blanks and possibly use Operation: Add ) over the data in the second worksheet. This will result in the new data being added to the second worksheet (adding to values in the same position if there are) or just filling the value in if the cell is blank. Any blank cells that were copied won't overwrite the cells with valid data in sheet 2.