Forum Discussion

Pushpa985's avatar
Pushpa985
Copper Contributor
Jan 22, 2024
Solved

macro to search headers and copy/paste values into another worksheet

Hi, I'm new to macros and learning now.I want to get my excel files arranged in specific order.For e.g,Name,Age,Phone,Address,Sum.     The headers are not in order in all the files.So I wan...
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jan 23, 2024

    Pushpa985 As I don't know how you have organized your files it's difficult to give a distinct answer. A good place to start learning about PQ would be the site in the link below. Read through the first page to understand what it's all about. Then, towards the end you'll find a list with 20 articles. Number 9 is probably going to be most useful to you (connecting to files from a folder). But take your time and scan through everything from the beginning so that you don't miss some of the basic principles.

     

    https://exceloffthegrid.com/power-query-introduction/ 

Resources