I currently have the following issue which I would appreciate if someone could help me answer! I currently use two spreadsheets at the same time, one that I use all the time (my 'main' sheet) and one that I detach from an email. Basically, on the sheet that gets sent I am interested in only two columns - the refernce and the status (call these columns C and G). I have to look up all the refernces, and dependent on the status amend cells in my 'main' sheet accordingly. I therefore presume I have to do some kind of lookup reference from the sent sheet into the mainr, and then use the 'if' command to amend where appropriate. the only other headaches is that certain status means I have to change 6 cells in my main spreadsheet (though the same text in each cells - bar the date in part of one cell), and some status' means that I cannot alter my main spreadsheet. Is this possible?
Apologies if this mail is not coherent!