I am basically taking a raw data set, and importing it into another workbook that is heavily used by me with formulas/values/formatting/column grouping already existing in the target workbook.

I have the basic Pandas copy, and understand that this will copy over the spreadsheet, and delete all the other values. I think my logic may be wrong, and I need to grab the data set I want copied and turn it into a Pandas Data Frame, and copy that to the target column/row and maybe that won’t delete/change the existing values in the cells?

import pandas as pd

data = pd.read_excel(‘/Users/mikey/Desktop/Automating Financial Reporting/QBO Spreadsheets/Statement of Cash Flows/StatementofCashFlows-ABC.xlsx’, sheet_name=”Month”)

data.to_excel(‘/Users/mikey/Desktop/Automating Financial Reporting/QBO Spreadsheets/Statement of Cash Flows/StatementofCashFlows-ABCReporting.xlsx’,sheet_name=”ABC Cash Flows”,startcol=17,startrow=9,index=False,header=None)