S
SFA
I am using Office v.X for mac. I have a workbook that that has master
worksheet with A1:AK4 column headings and A5:AK265 has data with
different formats (date,text,number etc.) I want to create new
worksheet as a diiferent catagories with linking data from the master
worksheet. So when i edit the master worksheet it edits the other
worksheet simultaneous. For example rows 5,15,70,100 belongs to
catagory1 being worksheet2 and rows 10,50,200 being another catagory as
another worksheet and so on. Different rows will make up 6 catagories
in turns 6 worksheets.
I have tried using paste link but i loose formating and in blank cells
it introduces zeros.
How can I copy/link data from master worksheet to the catagory
worksheet? I also want to copy the formating of the cells/rows. Is
there any formulas or macros to do these?
Any help is greatly appreciated.
Thanks
-Shah
worksheet with A1:AK4 column headings and A5:AK265 has data with
different formats (date,text,number etc.) I want to create new
worksheet as a diiferent catagories with linking data from the master
worksheet. So when i edit the master worksheet it edits the other
worksheet simultaneous. For example rows 5,15,70,100 belongs to
catagory1 being worksheet2 and rows 10,50,200 being another catagory as
another worksheet and so on. Different rows will make up 6 catagories
in turns 6 worksheets.
I have tried using paste link but i loose formating and in blank cells
it introduces zeros.
How can I copy/link data from master worksheet to the catagory
worksheet? I also want to copy the formating of the cells/rows. Is
there any formulas or macros to do these?
Any help is greatly appreciated.
Thanks
-Shah