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.