Tech Support banner
Status
Not open for further replies.
1 - 6 of 6 Posts

·
Security Manager, Analyst , Rangemaster, TSF Acade
Joined
·
39,538 Posts
Hi

Excel will normally do this automatically if you have a formula that references a cell in another workbook. Can you be a bit more specific? Do you have an example of what you are trying to achieve?
 

·
Registered
Joined
·
510 Posts
Discussion Starter · #3 ·
-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.
 

·
Security Manager, Analyst , Rangemaster, TSF Acade
Joined
·
39,538 Posts
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

=NOW()

- you can now format the cell to suit. This will update the date and time every time you open that sheet.

Does this help?
 

·
Registered
Joined
·
510 Posts
Discussion Starter · #5 ·
-yes it does help...but in the "time" is there a way were i can create a shortcut key like "ctrl+T" that will put the current time in the cell with this format (h:mm:ss).:smile:
 
1 - 6 of 6 Posts
Status
Not open for further replies.
Top