Automated Process that Updates all Spreadsheets in a Folder

A

Adel Pascaris

Hi all,



I was wondering if there is a way to automate a process that automatically
runs a VB module which updates all spreadsheets in a folder. I have created
VB code that copies columns on a current worksheet (sheet 1) and transposes
them onto a new worksheet (sheet 2). I would like to do this for all the
spreadsheets in the folder, and I was wondering if there's a way to automate
the process. Meaning: Is there a way I could create a VB module that will
copy columns from all worksheets (sheet 1) of all spreadsheets (in the
folder) and transpose them onto the new worksheet (sheet 2) of all
spreadsheets?



Thanks in advance,



Adel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automated Process that Updates Multiple Spreadsheets 2
Extract all attachments from all received Outlook 365 (on my PC) emails to a Folder 1
Folder structure in teams channel. 0
Combine two spreadsheets into one 3
Setting column width in a table with a macro is not working 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
Macro to Consolidate Data from Various Excel Files 1
Outlook 2021 export question 0

Top