yurble_vn
02-14-2008, 01:02 AM
Hi All,
I have an excel file which content 18 imported data block from an other excel file.
My trouble is that when ever I edit the source file, I have to manually update 18 data-blocks.
So:
1.Is there any way to not use imported data but still can have 18 block data copied from one source?
2.If not, is there anyway to update on imported data just in one time.
(the purpose of import data is to have 18 identical data-block copied from one soucre, and that imported data can autofill adherent formula)
thanks in advance.
regards,
I have an excel file which content 18 imported data block from an other excel file.
My trouble is that when ever I edit the source file, I have to manually update 18 data-blocks.
So:
1.Is there any way to not use imported data but still can have 18 block data copied from one source?
2.If not, is there anyway to update on imported data just in one time.
(the purpose of import data is to have 18 identical data-block copied from one soucre, and that imported data can autofill adherent formula)
thanks in advance.
regards,