Nov-30-2018, 12:16 AM
Hello,
I am new to python so apologies advance if this question doesn’t make sense.
I have an excel file that has 2 sheets.
Sheet 1 is where the formulas are and sheet 2 is where the raw data is.
Can someone point me in the right direction as to how I can automatically get the raw data for each day put it into the formulas record the output to a separate sheet then move on to the raw data for the next day and keep repeating the process until all the raw has been put into the formula and the output recorded.
I would like if someone can point me in the right direction and if possible give me some code that I can modify for my application.
Thanks in advance.
I am new to python so apologies advance if this question doesn’t make sense.
I have an excel file that has 2 sheets.
Sheet 1 is where the formulas are and sheet 2 is where the raw data is.
Can someone point me in the right direction as to how I can automatically get the raw data for each day put it into the formulas record the output to a separate sheet then move on to the raw data for the next day and keep repeating the process until all the raw has been put into the formula and the output recorded.
I would like if someone can point me in the right direction and if possible give me some code that I can modify for my application.
Thanks in advance.