Hi,
I need to extract a value from sheet1 in workbook A to sheet1 in Workbook B. Workbook A and Workbook B exits in 2 different folders.
How do it?
Hi,
I need to extract a value from sheet1 in workbook A to sheet1 in Workbook B. Workbook A and Workbook B exits in 2 different folders.
How do it?
Hi Peach
Open both Workbooks. Select Sheet1 of Workbook "A". In any cell Enter:
=A1
Now select this cell and go to Edit>Cut. Go to Window>Workbook "B". Select Sheet1 and paste wherever needed.
Or, copy the needed cell, go to Workbook "B", select sheet1 then go to Edit>Paste Special-Paste link.
Thank you Dave. :flower:
Don’t have an account yet? Register yourself now and be a part of our community!