breilly192
Technical User
I need to create some code to loop through multiple sheets of an Excel workbook, same format for each sheet, and extract the relevent data - acct nbr, amount, etc - where the amounts are <> 0 and either dump into a table or another sheet. From there, will dump into flat file.
Any tips on pulling the selected columns - ex. col B, col. C, col. D, col F - without pulling all rows and columns? The sheets are set up in report format with summaries, etc, which I will ignore to pull only rows that have acct nbs and where amount <> 0.
Would it work cleaner to write into an Accesss table and create the flat file from there?
Any tips on pulling the selected columns - ex. col B, col. C, col. D, col F - without pulling all rows and columns? The sheets are set up in report format with summaries, etc, which I will ignore to pull only rows that have acct nbs and where amount <> 0.
Would it work cleaner to write into an Accesss table and create the flat file from there?