I have data in excel and have columns date, description, debit, credit, balance and respective data underneath. Theses headers are repeating after every page and so loading one extra row in QV. I only want actual dates, description, etc and not these headers. I can label column A, B, C as these headers.
the headers are repeating. and I take data in excel format from source on weekly basis. so it's headache to go to tables and load again and again all files. I just want that I keep copying in one folder all weekly files and then can load all thru script.
If I want to load bank statement direct from saved web page, as it would give reliance in data to manager, how I can do that. It has several tables where the actual data resides. All compnay and account details is coming after every page and then there is separate tables where the bank statement is Date, Desc, debit, credit, balance.
Can you please advise how we can load all the tables in one go? Then I can try to omit blank and other text cells as did above.
Excel file is attached after omitting company details and transactions detail. In web data looks like this.
