I have a Excel sheet it’s having 2 sheets
- Input data ( Everytime it changes )
- Output data ( This need to be updated from input data based on formulas)
Input data sheet - this data every 2 hours i will be replacing existing data with new data
Output data sheet - it’s having formulas to get data from input data sheet.
Now i got struck how to update output data sheet without disturbing the formulas
I have tried some auto fill range kind but I’m unable to do that completely I’m not getting exact output.
Can anyone help me how to do that. I’m attaching sample excel for reference.
I’m using - VB, windows in studio
Input sheet - is the input
Output sheet - is the output
Sample input 2 sheet - i just added additional data for testing.
Sample Records Testing formulas.xlsx (15.3 KB)