Run one formula to all 80 excel workbook in a folder

**vando-kun** · 03-31-2020, 04:46 AM

Hello Excel Genius

I need your help.

So I have 80 CSV files in one folder, each file averages 97,000 rows. I want to perform a formula on column F (F = A-50) for all the workbooks. Is it possible to run a macro that doesn't require me to open up each workbook file?

Keep safe everyone. thanks in advance

**alansidman** · 03-31-2020, 04:55 AM

https://www.thespreadsheetguru.com/t...a-given-folder

**vando-kun** · 03-31-2020, 05:18 AM

Originally Posted by alansidman

https://www.thespreadsheetguru.com/t...a-given-folder

Thank you so much, Alan.

**ibuhary** · 03-31-2020, 05:29 AM

You could run a Power Query process instead of a Macro.

You can do wonders using Power Query. Just explore the endless possibilities.

Run one formula to all 80 excel workbook in a folder

LinkBack

Thread Tools

Rate This Thread

Display

Run one formula to all 80 excel workbook in a folder

Re: Run one formula to all 80 excel workbook in a folder

Re: Run one formula to all 80 excel workbook in a folder

Re: Run one formula to all 80 excel workbook in a folder

Thread Information

Users Browsing this Thread

Similar Threads

A Class Module for storing Images from folder for reuse in Excel Workbook Excel VBA

[SOLVED] Copy Range from multiple Workbooks in folder, to Summary Workbook also in same folder?

Creating a folder if it doesn't exist and saving an active workbook in that folder

Using Excel VBA to move workbook to new folder

How to Process all Excel Workbook in one Folder and Paste into a Master Workbook

[SOLVED] Stop an excel workbook or worksheet from opening if workbook isn't in a certain folder

Code to create New Folder (if doesn't exist) and then Save Workbook to folder

Bookmarks

Bookmarks

Posting Permissions