Loading data into excel raw data tab thats calculated in another tab

  • Hey guys, I've been tasked with automating an excel sheet which has 2 tabs. One called "Raw Data" is where I'm loading the data and there's another tab that has excel calculations on the data in the raw tab. I have a template for the excel file where I deleted all of the rows in the Raw Data tab. I have the package copying the excel file from a template folder over to the folder where I load it and concat the date on the end of the filename then I load the Raw Data tab. My problem is that the tab with the calculations aren't changing to show the values from the new data in the Raw Data tab. Is there a way to do this?

    Thanks

  • dndaughtery (11/10/2016)


    Hey guys, I've been tasked with automating an excel sheet which has 2 tabs. One called "Raw Data" is where I'm loading the data and there's another tab that has excel calculations on the data in the raw tab. I have a template for the excel file where I deleted all of the rows in the Raw Data tab. I have the package copying the excel file from a template folder over to the folder where I load it and concat the date on the end of the filename then I load the Raw Data tab. My problem is that the tab with the calculations aren't changing to show the values from the new data in the Raw Data tab. Is there a way to do this?

    Thanks

    Presumably you're not happy with 'Open the Excel file and hit the 'calculate' button'?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply