|
Answer» Hi All,
I have a spreadsheet that has a group of cells. We call them a quality rating. Once a week on Fridays we fill in the cell information to the left and if the user had an error we put them in the small boxes. This changes the 100% rating on the left side of the PAGE. We then copy the 5 far right cells and over write or shift them one cell to the left to open up a empty cell on the far right. In that cell we copy the new data so we always have a display of 6 weeks on each user's QC rating.
I hope that this makes since. I am going to add a screenshot to help show what I am trying to explan.
My goal is to MAKE it so what I type in the totals for a user on the left a set of cells can auto insert the cells and add the data on the right side of the SHEET I just typed. I was thinking about trying a MACRO but I would like to know if anyone could do this any cleaner.
Thanks
[recovering disk SPACE, attachment deleted by admin]
|
