Overwhelmed trying to resolve this.
Hi, I have a list of counties and the assigned rep for that county. I then have a fill rate report by county. I am trying to get a formula that will compare the counties then pull the name of the assigned rep into a column on the fill rate report by county. Its late, I've overthought this. Now I am hoping someone sees a simple answer to this. Thanks!
DATA ANALYSIS HISTOGRAM FUNCTION 'MACRO'
I am doing a repetitive task use of the Data Analysis Histogram function on #4 sheets within a workbook - I am seeking is it possible for an automating of the process - which produces a Histogram Result from a bin Range of a Colum of Data. In each case, I need to press the Data Analysis, select histogram, enter the Input Range, Bin Range and Output Range (selecting a cell) each data piece of which are the same for all #4 sheets. On each sheet I open the above enter the data and press 'OK'. I step through each sheet and this takes about 2-3 mins, but would be great if its possible to write a Macro or press one button. Any ideas would be amazing. Thank you.............
