T
tarynnl
i have data coming in from various sources in worksheets which i have t
merge into one main workbook but if i change the original worksheets th
main sheet must update. copy and paste takes too long even if i lin
it.. thought i could use an hlookup function to lookup the data bu
cause the source is from various workbooks that doesnt work, so i hav
landed up using the merge workbook function. problem there is if
change an original it doesnt automatically update the main on
merge into one main workbook but if i change the original worksheets th
main sheet must update. copy and paste takes too long even if i lin
it.. thought i could use an hlookup function to lookup the data bu
cause the source is from various workbooks that doesnt work, so i hav
landed up using the merge workbook function. problem there is if
change an original it doesnt automatically update the main on