[cryingvalor]

-hey guys how do you link worksheet and workbooks in excel?

 

[Glaswegian]

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?

 

[cryingvalor]

-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.

 

[Glaswegian]

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?

 

[cryingvalor]

-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:

 

[Glaswegian]

There already is a shortcut for entering the time in a cell - Ctrl+Shift+; Just set your format first.