Formula data from sheet 1 to sheet 2 - Microsoft Community
Office / Excel / Windows 10
hello, have issue data linked between sheets. use sheet 1 , sheet 2 reference.i want sheet 1 model sheet 1,2,3,4...n when want change in sheets change in sheet 1. while there mere formula displaying data sheet 1 sheet 2: =sheet1!a1 exemple , dont know use formulas. concrete example have =colorfunction(a11;e13:i28;true) in a1 sheet 1 , dont know should write in a1 sheet 1,2,3 etc if want change in formula in sheet 1 rather in sheets.
i wonder if there way can cell format too, when change font color, borders etc in a1 sheet 1 sheets.
if group sheets (select sheet1/left sheet in tab order, holddown shift key , select tab n (last sheet in tab order) sheets selected), change make in activesheet should reflected in sheets. have remember ungroup sheets don't make stray changes sheets (right click on selected sheet tab , choose ungroup sheets).
you can group non-contiguous subsets of sheets using ctrl key when selecting each sheet after first sheet selected.
--
regards,
tom ogilvy
Office / Excel / Windows 10
Comments
Post a Comment