Forum

Luis Pirla
@lupirla
New Member
Joined: Aug 26, 2021
Topics: 0 / Replies: 3
Reply
RE: Save multiple Workbooks based a List, Change Sheet Name & Insert Sheet Name in Cell D3

For doing this programatically you need to master loops. I recommend you to loop through the list of ID numbers and puting it as a variable name fo...

4 years ago
Forum
Reply
RE: SUMMARIZE EXCEL FILE USING POWER QUERY

Hi I suggest to use the Indirect formula This formula can capture the cell values from diferent sheets or books

4 years ago
Forum
Reply
RE: Excel Power Query - Merge two cells

Hi David My sugestion is 1.- Transpose de data 2.- fill down the column1 3.- select column1 and column2 and merge them 4.- tranpose the...

4 years ago
Forum