Hi
I am still what I would describe as a "beginner" in Excel - but have something I urgently want fixed so if anyone can help it would be very much appreciated. I have uploaded the sheet so it will hopefully be clearer what I am trying to achieve - it is in attachments saves as "Acct Management" somewhere below hopefully! Basically this table will be linked into some external dynamic feed that will log people coming in dynamically. The data will feed into the top row (although this is blank at moment) ....so will feed into B1:I1
In columns in G and H you will see the "0" and "1"s - these can only be a zero or 1 - and the max value can only be 1.
Lets say "Rob" (in row 7 of my sheet) goes from 0+0=0 to 0+1=1.... this is automatically reflected in the SUM of the totals going up by 1 unit (Cell I20)
--> What I would like is a macro where if the Total in Cell I20 goes up by 1... then the entire row for Rob (Cells B7:I7) are copied and pasted as values (so they can no longer dynamically update) - and any new data in Cells B1:I1 is then copied and placed into a new row.... which would now be Cells B8:I8
Is this possible? The macro would have to be able to detect changes to Cell I20 - and then recognise the "Total" number (in cell I20) so that it could use that to calculate the offset of which to row to copy and paste values and where to copy and paste the new row
Hope that makes sense... If someone could re-work my sheet and re-upload I would be immensely grateful as my programming skills just aren't good enough but this would save me a huge amount of administrative work throughout my day!
Thank you v much in advance!
Jonnyforum.ozgrid.com/index.php?attachment/48552/forum.ozgrid.com/index.php?attachment/48552/