han77729
New member
- Joined
- Dec 12, 2012
- Messages
- 31
- Reaction score
- 0
- Points
- 0
Hello All,
Going to go straight to the point.
Questions one: I'm having trouble to linking values in cells to another sheets.. I know it is as easy as having "=.. and whatever the cell you want to link to" But the problem I'm having is that I'm trying to make the linking thing not only links the value, but the color set inside that cell. Could anyone help?
Questions two: As I'm working on linking the cells together from multiple sheets (sheet 1, sheet 2.. etc) into one sheet (collaboration sheet), I came across another issue. I'm trying to let sheet "1"'s value always stays on the top of the "collaboration sheet" and sheet "2"'s value always go underneath "sheet 1"'s values and sheet "3"'s value stay under sheet "2"'s value. (easy right?) BUT, in addition.. when I "add" more values into the original sheet 1,2 and 3.. it needs to stay in order on the collaboration sheet.
Could anyone please help me fix this problem?
I've attached a setup workbook so you guys can mess around with the formula/functions.
Thank you,
HanView attachment Excel Help.xlsxView attachment Excel Help.xlsx
Going to go straight to the point.
Questions one: I'm having trouble to linking values in cells to another sheets.. I know it is as easy as having "=.. and whatever the cell you want to link to" But the problem I'm having is that I'm trying to make the linking thing not only links the value, but the color set inside that cell. Could anyone help?
Questions two: As I'm working on linking the cells together from multiple sheets (sheet 1, sheet 2.. etc) into one sheet (collaboration sheet), I came across another issue. I'm trying to let sheet "1"'s value always stays on the top of the "collaboration sheet" and sheet "2"'s value always go underneath "sheet 1"'s values and sheet "3"'s value stay under sheet "2"'s value. (easy right?) BUT, in addition.. when I "add" more values into the original sheet 1,2 and 3.. it needs to stay in order on the collaboration sheet.
Could anyone please help me fix this problem?
I've attached a setup workbook so you guys can mess around with the formula/functions.
Thank you,
HanView attachment Excel Help.xlsxView attachment Excel Help.xlsx