-yes actually im trying to link 2 excel files in the first excel file the content of A1 in the first excel is an input in the B2 in the 2nd excel file.
-and how can you create your own shortcut key in a keyboard which executes a certain formula like showing the date and time.
OK - so if you have both workbooks open, and in file 1 click on cell A1, then hit the equals sign (=), then click on cell B2 in file 2. Excel will now know that both workbooks are linked and each time you input a value in B2 it will copy to A1.
You can show the date and time automatically without needing to add a keyboard shortcut. In any cell input this formula
- you can now format the cell to suit. This will update the date and time every time you open that sheet.
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!