Programming Questions? Ask a Programmer for Answers ASAP
Thanks for using JustAnswer. My name is***** will do whatever I can to answer your question and will be back in a moment with my reply.
can you send an example file gthat shows data, and what you want the output to look like
ok, so based on the values in column C, if it = 0 it goes to one set of columns, if it is between 0 and 10 it goes in 2nd, set 10 to 20 goes in 3rd set, 20 to 35 in 4th set, and >35 in 5th set?
or did I not undestand
so are the number ranges always the same?
And also what if it is between 0 and 10 you don't have a category for that
well basically need an extra range then.
ALso do the ranges always stay the same?
this will require a macro vba code which I will write to populate this.
There is an additional fee do to the complexity of the problem.
I am sending an additional service offer now, once accepted I could work on it/.
also need to know what version of excel it is you use
well yes, it is included in the file.
tommaro by end of day, too late now
ok, here it is
had to put in zip file to upload xlsm file
if you have never used a macro before, you may get some kind of security thing when you start excel, near the top of the screen. "enable macros", "enable content". something like that, you have to click that or it wont work. Then click the populate button that I added to the first sheet.
If you change the data, just run it again and the 2nd sheet will be updated.
To view the code press "ALT" + "F11" key at the same time.