Hi Folks,
New to the group and this is my first post, sorry if I have missed any protocols! I am limited to using Excel for Mac (version 16.47.1) and have a problem I cannot find a solution for. I believe this problem would be fairly well supported on the full Excel version on a Windows machine. Since Excel for Mac does not support that I have guessed this is the right subgroup in which to post!
Say I have "N" number of CSV input text files (only 2 shown):
data1.txt:
name,value1,value2, value3
Tom,100,200,alpha
Jane,1000,2000,beta
Raj,10,20,gamma
data2.txt:
name,value1,value2,value3
Larry,800,900,delta
Vin,8000,9000,epsilon
The task is to allow the data files to be imported AND refreshed. The end result is required to be a Table that combines the results of the input files - that would be 5 total rows plus the common header. Since the input files can be refreshed, if a fourth line was added to data1.txt then the Table should update to combine the refreshed results.
The columns of the input files will always be the same. The total number of input files will also not change. I am not certain of the total yet though - it will be between 5-8 though. There can be any number of sheets, and any number of tables as long as one finally exists with the combined results.
I believe a Macro would be required to make this work in Excel for Mac? Is that a lot of work - I do not really know Excel Macros so it would not be something i could easily achieve on my own.
UPDATE:
As noted, I am new here. I just learned about the "Commercial Services" forum. If someone can assure me that what I want is achievable within Excel for Mac and let me know an appropriate number of points, I will move or add this post there with the requisite points!
Bookmarks