Hi,
I have an excel file that is 80mb in size. I have daily files for several years that I upload each day. I would like to see if I could save time by storing prior years already. They are csv file format 365 files x 4 years and take 30 minutes to upload each day.
I think if I could save...
Hi Folks
I have a large CSV, where each row/entry has a date in it, in the format dd-MM-yyyy. I would like to import it, but create a new sheet per date, and preferably (although not a requirement) order the sheets chronologically. The date is 7th of 14 columns and there are multiple entries...
So I'm trying to build an excel spreadsheet that I can distribute to other schools that will allow for the following functions,
Essentially, they will use the first tab to add rows and create their schedule, which then will generate a CSV sheet on tab 3 that they can import into excel or Gmail...
Hello dear Excel users!
I got hung up on my lacking knowledge regarding Excel.
My aim is to get a CSV input, which has several coloums, but only 2 is of interest: one which determines the type of data and a number value, which is to be copied unchanged. The output would have a completely...
Hi,
I’m trying to create a .CSV file separated by semicolon instead of a comma, like this exemplary file here, but some of the rows contain special characters and all the data must be wrapped by double quotes.
I have changed the list separator under the Region in my windows control panel to be...
Hi all,
I've got 170 csv files that I'm looking to compile into excel so as to analyse them, but am hoping to avoid having to do that one by one, adding each as a seperate tab.
Does anyone have any ideas of how I could do this, e.g. a macro or script, or if there's an "add all as tabs" add-in...
Hi,
This is my first post to this forum, although I am working on a potential project for my University and was curious if what I need to do is going to be possible.
1] Have Excel document save every second.
* Found some people discussing this with code so I know that this is...
Hi All.
For my businesses CMS - I need for several excel workbooks to communicate with each other.
I'm trying to save a sheet as a csv... then import it into another workbook.
The problem I'm encountering is that no matter whether I comma or tab delimit, when I try to import the sheet, excel...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.