data export

I export data with the same columns & headers every quarter or so from different regions. I was wondering if there was a way to have a pre-formatted table with the same column sizes, formatting, headers, etc that I could just import the data to. As of right now I export the data, turn it into a...

Hi All We hold our data in Salesforce Professional. Every day I have to go through the process (in Salesforce) of exporting .csv reports to Excel 2013 to then manipulate the data. I am presently in the process of automating the Excel part with macros. Can anybody advise whether there is a...

Goodmorning, Since a few days im trying to get data from my PLC. I fixed to get 1 data unit from the plc and place it in a cell (A1). Ive got this working with the programm UniDDE. This is a connection between the PC(excel) and the PLC. Now when there is a new incomming data the last data will...

Hello, I am trying to export data sets from 3 files into a new "Weekly Summary" file. However, the file names change each week to match up with the start date of the week (ex. Line 1 6-26-17). Whenever I try to reference a sheet by having the user select a file by using...

I have a spreadsheet with 64 rows and 111 columns (DATA). Each row has a unique identifier. I need to output 18 (always the same) of the 111 columns into individual sheets (TEMPLATE by unique identifier) Can anyone tell me a way to do this so I dont have to manually input all of these items...

Hello collective consciousness of MrExcel.com. I'm hoping you can help me out with a project. I am trying to : -Take a serial # from excel and enter it in to a search form on a site -Return specific info from the results back in to the excel document -Rinse and repeat for the next serial number...