Pull out numbers and text from 10+ excel files in a folder
Hello everyone, I am looking to build a macro that goes through all the excel files (and their tabs) in a folder and pull out numbers which start with 01 or 02 and copy paste it into a new excel sheet. I want it to go through those sale excel files (and their tabs) and pull out text in a certain font colour and paste that in a new excel sheet. NOTE: 1.) The text and numbers are in text box and not cells. 2.) There is a password prompt at the start and option for 'Read-Only' - the macro needs to click that to access file Thank you
In this project you compete with other providers. The best outcome is chosen by the buyer and its provider is rewarded. For more information see the FAQ.
Use the "Project Type" filter on the left to filter all contest projects.In this project you place a bid to offer the price you wish to receive for performing it. The buyer chooses the provider by price and impression. For more information see the FAQ.
Use the "Project Type" filter on the left to filter all bidding projects.