Luis Pirla
New Member
Joined: Aug 26, 2021
Follow
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
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
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