Hi,
I am wondering how I can easily extract wanted data from a spread sheet that is connected to a SQL-database sorting values in random order.
Lets say the data is sorted like his: (as you can see, they are not sorted with same intervals all the time)
1 A E
2 Savings 55
3 Credit 22
4 Loan 10
5 Savings 52
6 Credit 20
7 Loan 9
8 Savings 70
9 Loan 12
10 Credit 15
11 Loan 15
12 Credit 10
13 Savings 40
I have tried Vlookup, Hloopup, Matc and If, also combining them. I am currently trying to build a macro in VBA...
How could I address this problem?
Kind Regards
Engineering student
EDIT:
https://www.dropbox.com/s/qaky7ti299....data.PNG?dl=0
This is an example of how it could look
I am wondering how I can easily extract wanted data from a spread sheet that is connected to a SQL-database sorting values in random order.
Lets say the data is sorted like his: (as you can see, they are not sorted with same intervals all the time)
1 A E
2 Savings 55
3 Credit 22
4 Loan 10
5 Savings 52
6 Credit 20
7 Loan 9
8 Savings 70
9 Loan 12
10 Credit 15
11 Loan 15
12 Credit 10
13 Savings 40
I have tried Vlookup, Hloopup, Matc and If, also combining them. I am currently trying to build a macro in VBA...
How could I address this problem?
Kind Regards
Engineering student
EDIT:
https://www.dropbox.com/s/qaky7ti299....data.PNG?dl=0
This is an example of how it could look
Last edited by a moderator: