I am trying to make a simple formula that will allow me take some data out of workbook A and transfer in Workbook B. Is that possible to transfer a whole
column at once but keep the possibilty to move data cell by cell if needed.
Open both workbooks, type in the destination cell in workbook B a "=", go to workbook A and select the cell you wish to take the data from and press enter. Look at the formula in the formulabar and remove both $ symbols. Drag the destination cell in workbook B down to take the data from the entire column of workbook A.
Thanks to Trowa for this tip on the forum.
Published by aakai1056
Latest update on January 15, 2010 at 09:42 AM by aakai1056.