Hi All,
Basically I am trying to copy hundreds of new files weekly into one Master.
Each file (see https://ufile.io/bh1z1) has a "GPI" sheet with data in D4:D300, which I need to transpose and paste as values into a Master.
I have hit some roadblocks with my current code. It is running but...
I have the following macro to generate combinations, which works fine. But, I need to add conditions to create the combinations. My data is something like this
<tbody>
a
b
c
d
e
f
bulter
10
keeper
brown
8
Keeper
smit
8
all-rounder
ryan
9
all-rounder...
I found this excellent code on this site and it works great. What do I need to do when copying from the source documents to paste the information into rows rather than columns? The first row would be Row 4 and then go down by 1 row each time until completed.
Sub FolderCrawler()
FileType =...
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.