Hi All,
I have a consolidated report for two locations that I wish to split into individual locations. The report has a unique code number in the first column, then a description in the next column and finally a dollar value in the last column. I want to extract all code numbers in a range and then copy the code, description and $'s to a new sheet so I end up with 2 sheets, one for each location and that the two locations include all codes in the consolidated report. The range of code numbers are as follows 4-0001 to 4-0099 are one location, 4-0101 to 4-0199 are the second location. I have 3 groups of numbers 4-xxxx, 5-xxxx & 6-xxxx and all of the groups need to be sub totalled by group. I realise I can match each individual number but I want to allow for the fact that new codes will be created from time to time and these need to be copied as well. (Not all numbers are in use between the ranges) I am not sure if there is a formula that can do this or if it's even possible in excel? My excel skills are quite basic so if you could please explain any possible solutions in simple to understand instructions that would be greatly appreciated!
Bookmarks