I have 21 "individual" spreadsheets that are updated each day with data that has been collected into another spreadsheet template. A template is used to collect the data so it is always in the same format and the files are named based upon the date. Example: Worksheet mm.dd.yyyy (with multiple...
Happy holidays! And thank you in advance!
In summary: I need a macro that would copy all the columns A:C starting from Row 2 if the sheet name is "Apply" or "apply", of all the excels in a specific folder. I need to paste all these values on another Excel.
Example:
Specific folder(changes...
I am trying create a macro that will open a .csv file. The file name changes daily. The file name is YYYYMMDD_7dat.csv. Is there a formula that I can put in VBA that will format the open from to this format?
First I'll let you know what I have and then let you know what I'm trying to accomplish.
I have a file - products.xlsm with a copy row macro that will copy from "XYZ worksheet" and paste to "Quote worksheet"
This is all working fine and no issues.
What I'm trying to accomplish is to be...
Hey All, I am trying to copy data from one workbook into another. The data that is being copied is in an excel file that exported from a website that has a changing file name (something that I do not have control over). The front half of the file name remains the same, but it is the back...
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.