Hello dear forum members,
I'm trying to create a report for my monthly bills. I want to copy the invoice for water supply and extract automatically the numbers in a second tab where I can see historical data. The challenge:
1) when I paste the invoice in the first tab, the data may not be in the same cells as for previous months
2) some fields contain numbers and text and in the second tab only numbers are necessary
Could you please help me with these challenges?
Bookmarks