Sorting question

[Lena111]

Hi all! My name is Lena and I am pretty excited to have found you I know excel is a powerhouse and I know less than a fraction of what this program can do. Here is something I am working on now. I have 4 columns of data. The first 2 columns are the name and quanity sold of our inventory from Quickbooks (imported in). The other 2 columns are the name and quanity on hand of our inventory also imported from Quickbooks. I was really hoping I could just import them and they would all match up and make it easy to run a report of what percentage of our total inventory we have sold for the year. Unfortunately there are hundreds of items listed in our inventory that did not come in our sales report from quickbooks. I am currently having to cut these extra items out manually and put them on another sheet to mess with later. I need the four columns to stay together so I don't lose the correct numbers that are associated with the names. After I have them all in order I am sorting them by type and then sorting these groups by quanity sold, largest to smallest. My sorting macro works great lol but is there anyway I can get these columns to match up by exact name and keep the quanity columns associated with them to remain with them?? We have thousands of plants and going through these one by one is crazy time consuming, any thoughts?? Thanks in advance!!!

[vlady]

Welcome to the forum.

May I suggest you post your query to the proper subforum for discussion. Be sure to name the thread that best describe your problem and if possible attach a sample workbook.

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Lena111]

You got it, thanks so much vlady!!!