Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to be more precise:
I have a 3 sheets workbook: 1 Main, and the other 2 are to input the data. At the end of the day, when all the data is input in the 2 worksheets, a button is pressed and this button will start a macro which will select all data, copy it, open the sheet calle main, paste the cut data in the first available empty place and then delete the data in the workbook. Only 1 cell per row in this worksheet has a formula (i.e. =H2 - E2). When the macro deletes all the data in the input sheet, it also deletes the formula... how can I prevent it from happening? is it possible to create a macro or a code that will restore the formula in the given cell(s)? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Answers to questions posing more questions in a workbook | Excel Worksheet Functions | |||
View Questions and Answer to questions I created | Excel Discussion (Misc queries) | |||
HLOOKUP() explanation | Excel Worksheet Functions | |||
Explanation of when & how to use ( ) { } : ; , ! etc? | New Users to Excel | |||
Formula Explanation Please | Excel Discussion (Misc queries) |