Forum Discussion
Copying excel worksheet saving dropdown menus
Hi, Ive created a spreadsheet. I require 4 x spreadsheets and x 5 books. each sheet representing a week of the month and a book for each month until `December at least. When I've copied the worksheet...
I'm not sure, because the translation is not the best, I send two suggested solutions.
1)move or copy a worksheet in the same workbook to organize your workbook exactly how you want.
https://support.microsoft.com/en-gb/office/move-or-copy-worksheets-or-worksheet-data-47207967-bbb2-4e95-9b5c-3c174aa69328?ui=en-us&rs=en-gb&ad=gb
2)As a manual solution
Use the key combination CTRL KOMMA (,) to apply the formula of the cell above the active cell. The key combination CTRL SHIFT KOMMA takes values from the cell above the active cell. KOMMA means the key with which you insert the comma separator.
The key combination STRG KOMMA also helps if the copy of the formula should end up in any cell. To do this, first copy the formula with STRG KOMMA into the cell directly below. Then move them to the desired location on your spreadsheet. When moving in this way, in contrast to copying, the relative references remain unchanged
3)As a smal VBA solution proposal
Sub Formeln_kopieren()
Range("C1:C6").Formula = Range("A1:A6").Formula
End Sub
If you find this helpful, please mark it as "Best Answer" and as Like (click thumbs up), it will be beneficial to more Community members reading here.
Nikolino
I know I don't know anything (Socrates)
1)move or copy a worksheet in the same workbook to organize your workbook exactly how you want.
https://support.microsoft.com/en-gb/office/move-or-copy-worksheets-or-worksheet-data-47207967-bbb2-4e95-9b5c-3c174aa69328?ui=en-us&rs=en-gb&ad=gb
2)As a manual solution
Use the key combination CTRL KOMMA (,) to apply the formula of the cell above the active cell. The key combination CTRL SHIFT KOMMA takes values from the cell above the active cell. KOMMA means the key with which you insert the comma separator.
The key combination STRG KOMMA also helps if the copy of the formula should end up in any cell. To do this, first copy the formula with STRG KOMMA into the cell directly below. Then move them to the desired location on your spreadsheet. When moving in this way, in contrast to copying, the relative references remain unchanged
3)As a smal VBA solution proposal
Sub Formeln_kopieren()
Range("C1:C6").Formula = Range("A1:A6").Formula
End Sub
If you find this helpful, please mark it as "Best Answer" and as Like (click thumbs up), it will be beneficial to more Community members reading here.
Nikolino
I know I don't know anything (Socrates)