Hi guys, I can’t seem to find any resources online regarding my problem. In fact, I don’t even know how to start! Basically:
- An investor can choose to acquire a maximum of 8 stocks for his/her portfolio
- So for example, investor1 just chooses stock1, stock2 & stock3
- The problem here is how to export these 3 stocks into the 8 fields as given in excel(I have to follow the excel template) . I cant just simply use “.cells(… , …)” as it needs to be in order eg cell 1 = stock1 , cell 2 = stock2, cell3= stock 3 , the rest of the 5 cells is left empty
- So how do I sort of like “count” from access and export these data to fill in the excel cells accordingly based on the investorID (as different investors can purchase different no. of stocks)
I hope this is possible to do so as it seems rather complex… I sincerely hope you guys can help me out here and I thank you all in advance for any advice