Power Query/BI to change multiple files from same folders

jzellman

New Member
Joined
Aug 12, 2015
Messages
13
I have about 200 files each with 5 header rows and then the data starts on line 6. I want to:

Copy this worksheet to a new worksheet in the same workbook and rename "Final"

There is a date field (Cell B3) in one of the "header rows" that I want to insert and copy down to all of the data lines.

Delete the 5 header rows.

Any ideas?
 

Forum statistics

Threads
1,077,721
Messages
5,335,812
Members
399,051
Latest member
WPO

Some videos you may like

This Week's Hot Topics

Top