Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hard One.
I'm exporting a product sales summary from Quickbooks. I want to build
excell sheet that will look at each product that is comming in and check to see if that product fits certain variables, if it does see the quanity. Now i'm also adding together different products because they share simliar parts. So what would be the best way to go about doing this when you have a few hundred item #'s. I know I could write one really really long If then statement but that seems a bit insane. (I could check each item against every possible item # and then assign it a number and then use a second if then to find all the item #'s that match the assigned # and grab the quanity value.. is there an easier way to do this, maybe using arrays or something? |
#2
|
|||
|
|||
You can probably do this with some variation of SUMPRODUCT. However you
haven't provided enough information to enable me to be more specific than that. Keep in mind that you can modify the Quickbooks report (click on modify report and change the columns to include and use filters as needed) to include/exclude a great deal of information so use that to your advantage. Possibly you can get a partial answer using QB and then use XL to get you to the finish line. HTH PC "Chris S." <Chris wrote in message ... I'm exporting a product sales summary from Quickbooks. I want to build excell sheet that will look at each product that is comming in and check to see if that product fits certain variables, if it does see the quanity. Now i'm also adding together different products because they share simliar parts. So what would be the best way to go about doing this when you have a few hundred item #'s. I know I could write one really really long If then statement but that seems a bit insane. (I could check each item against every possible item # and then assign it a number and then use a second if then to find all the item #'s that match the assigned # and grab the quanity value.. is there an easier way to do this, maybe using arrays or something? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to remove hard returns, which show as little boxes | Excel Discussion (Misc queries) | |||
Excel hard code those #'s without deleting the formula or typing# | Excel Discussion (Misc queries) | |||
Linked cells, make the data go hard manually | Excel Discussion (Misc queries) | |||
Automatic backup in excel with copy to hard drive and to cd-rw | Excel Discussion (Misc queries) | |||
hard return | New Users to Excel |