Recent content by msmigraine

Thanks for the quick response Skip, I'm not able to wrap my head around this? Here's an example of my data: JOB CD JOB TITLE SR MGMT/ADMIN LI040 SECRETARY II QV102 UNIT DIR MFG OPS QV103 UNIT DIR FOC FACT LI040 SECRETARY II PA053 DIR PRO QA LC...

I have two columns of data each column has multiple groupings of (A)Job Codes and (B)Job Titles, within each grouping a Job Code can be repeated several times. The formula needs to be able to calculate how many times a job code is repeated and then list under the given group the job code and...

I believe that you have hit the nail right on the head flan - unfortunatly I must keep the present layout, although I do agree that the shortcut (Ctrl + ') would be much more functional. My skill level with this application is fairly low and I have no clue how to create the macro you are...

Thank you for the reply flan - sorry for the confusion. I have no issue with displaying the formulas on Sheet 2 (Sheet 2 is simply a copy of Sheet 1 created for the sole purpose of displaying the formulas). My question is how can I then link Sheet 2 to Sheet 1 so that any updates I make to...

I have a workbook which contains 2 sheets. Sheet 2 is a copy of Sheet 1 only difference being that I have opted to display sheet 2 as formulas vs. data. My quandry is that I want to "link" sheet 2 to sheet 1 so that any updates I make to sheet 1 automatically update on sheet 2...