Ok now I can understand this much better thank you. One last question though, do you plan to keep adding columns on to row 8 or will you just be changing values that are already in there? In other words will values extend beyond column AA?
---------- Post added at 11:01 AM ---------- Previous post was at 10:20 AM ----------
Ok I have it working. for some reason there is an error when I try to upload the file so here is the code:
Put this in your "Sheet10(Staffing)" and when you change a value in the yellow row it will automatically update the column beneath it. What the code does is every time a value in a yellow cell changes it pastes it into the other sheet and then pastes the resulting column beneath the yellow cell value. I am sure there is a more efficient way to do this (instead of code for each cell do it by range) but I am also new to vb and do not know how to do that. This works just as well though. If in the future you need to add more columns to your "Staffing" sheet copy the code:
and change the letters in red above to the letters of the new column.
hth
EDIT: I figured out the more efficient way:
hth
Bookmarks