i have workbook many tabs, of identical in format. want have same embedded charts in each worksheet. can't seem copy charts 1 tab other tabs without new data range being tied original worksheet tab name. first choice refer data range b6:b87 or =b6:b87 without reference being ='tabname'!b6:b87, excel doesn't seem allow it.
make copy's of data range on same page cut , past on page want.it wont have sheet name copied.
Comments
Post a Comment