przyklad.xls

EXCEL - Lista rozwijana - import danych z innego arkusza

Dziękuję za odpowiedź - do przykładowego pliku wkradł się jakiś błąd (502). Załączam plik na którym "próbuję" pracować.

" SOS " , " WAR "
 " STORE " , " SOS " ,,
" WEEK 05/05/14 " ,,,
" Name " , " Quantity " , " Sales " , " % "
" EQU " , " 11 " , " 1146.02 " , " 0.199200431071944 "
" RUC " , " 12 " , " 1147.02 " , " 0.19937425040413 "
" KID " , " 13 " , " 1148.02 " , " 0.199548069736316 "
" OUT " , " 14 " , " 1149.02 " , " 0.199721889068502 "
" FTW " , " 15 " , " 1150.02 " , " 0.199895708400688 "
" LIT " , " 16 " , " 1151.02 " , " 0.200069527732874 "
" MEN " , " 17 " , " 1152.02 " , " 0.200243347065061 "
" ACT " , " 18 " , " 1153.02 " , " 0.200417166397247 "
" BAS " , " 19 " , " 1154.02 " , " 0.200590985729433 "
" FTW " , " 20 " , " 1155.02 " , " 0.200764805061619 "
" LIT " , " 21 " , " 1156.02 " , " 0.200938624393805 "
" OUT " , " 22 " , " 1157.02 " , " 0.201112443725991 "
" WRS+3SF " , " 23 " , " 1158.02 " , " 0.201286263058177 "
" WAR " , " 24 " , " 1159.02 " , " 0.201460082390363 "
" WMN " , " 25 " , " 1160.02 " , " 0.20163390172255 "
" ACT " , " 26 " , " 1161.02 " , " 0.201807721054736 "
" BAS " , " 27 " , " 1162.02 " , " 0.201981540386922 "
" FTW " , " 28 " , " 1163.02 " , " 0.202155359719108 "
" LIT " , " 29 " , " 1164.02 " , " 0.202329179051294 "
" OUT " , " 30 " , " 1165.02 " , " 0.20250299838348 "
" WRS+3SF " , " 31 " , " 1166.02 " , " 0.202676817715666 "
" WAR " , " 32 " , " 1167.02 " , " 0.202850637047852 "
, " 78 " , " 5753.1 " , " 1 "
 " STORE " , " WAR " ,,
" WEEK 05/05/14 " ,,,
" Name " , " Quantity " , " Sales " , " % "
" EQU " , " 11 " , " 1146.02 " , " 0.199200431071944 "
" RUC " , " 12 " , " 1147.02 " , " 0.19937425040413 "
" KID " , " 13 " , " 1148.02 " , " 0.199548069736316 "
" OUT " , " 14 " , " 1149.02 " , " 0.199721889068502 "
" FTW " , " 15 " , " 1150.02 " , " 0.199895708400688 "
" LIT " , " 16 " , " 1151.02 " , " 0.200069527732874 "
" MEN " , " 17 " , " 1152.02 " , " 0.200243347065061 "
" ACT " , " 18 " , " 1153.02 " , " 0.200417166397247 "
" BAS " , " 19 " , " 1154.02 " , " 0.200590985729433 "
" FTW " , " 20 " , " 1155.02 " , " 0.200764805061619 "
" LIT " , " 21 " , " 1156.02 " , " 0.200938624393805 "
" OUT " , " 22 " , " 1157.02 " , " 0.201112443725991 "
" WRS+3SF " , " 23 " , " 1158.02 " , " 0.201286263058177 "
" WAR " , " 24 " , " 1159.02 " , " 0.201460082390363 "
" WMN " , " 25 " , " 1160.02 " , " 0.20163390172255 "
" ACT " , " 26 " , " 1161.02 " , " 0.201807721054736 "
" BAS " , " 27 " , " 1162.02 " , " 0.201981540386922 "
" FTW " , " 28 " , " 1163.02 " , " 0.202155359719108 "
" LIT " , " 29 " , " 1164.02 " , " 0.202329179051294 "
" OUT " , " 30 " , " 1165.02 " , " 0.20250299838348 "
" WRS+3SF " , " 31 " , " 1166.02 " , " 0.202676817715666 "
" WAR " , " 32 " , " 1167.02 " , " 0.202850637047852 "
, " 78 " , " 5753.1 " , " 1 "
 " STORE " , " GLI " ,,
" WEEK 05/05/14 " ,,,
" Name " , " Quantity " , " Sales " , " % "
" EQU " , " 11 " , " 1146.02 " , " 0.199200431071944 "
" RUC " , " 12 " , " 1147.02 " , " 0.19937425040413 "
" KID " , " 13 " , " 1148.02 " , " 0.199548069736316 "
" OUT " , " 14 " , " 1149.02 " , " 0.199721889068502 "
" FTW " , " 15 " , " 1150.02 " , " 0.199895708400688 "
" LIT " , " 16 " , " 1151.02 " , " 0.200069527732874 "
" MEN " , " 17 " , " 1152.02 " , " 0.200243347065061 "
" ACT " , " 18 " , " 1153.02 " , " 0.200417166397247 "
" BAS " , " 19 " , " 1154.02 " , " 0.200590985729433 "
" FTW " , " 20 " , " 1155.02 " , " 0.200764805061619 "
" LIT " , " 21 " , " 1156.02 " , " 0.200938624393805 "
" OUT " , " 22 " , " 1157.02 " , " 0.201112443725991 "
" WRS+3SF " , " 23 " , " 1158.02 " , " 0.201286263058177 "
" WAR " , " 24 " , " 1159.02 " , " 0.201460082390363 "
" WMN " , " 25 " , " 1160.02 " , " 0.20163390172255 "
" ACT " , " 26 " , " 1161.02 " , " 0.201807721054736 "
" BAS " , " 27 " , " 1162.02 " , " 0.201981540386922 "
" FTW " , " 28 " , " 1163.02 " , " 0.202155359719108 "
" LIT " , " 29 " , " 1164.02 " , " 0.202329179051294 "
" OUT " , " 30 " , " 1165.02 " , " 0.20250299838348 "
" WRS+3SF " , " 31 " , " 1166.02 " , " 0.202676817715666 "
" WAR " , " 32 " , " 1167.02 " , " 0.202850637047852 "
, " 78 " , " 5753.1 " , " 1 "
 " STORE " , " KRA " ,,
" WEEK 05/05/14 " ,,,
" Name " , " Quantity " , " Sales " , " % "
" EQU " , " 11 " , " 1146.02 " , " 0.199200431071944 "
" RUC " , " 12 " , " 1147.02 " , " 0.19937425040413 "
" KID " , " 13 " , " 1148.02 " , " 0.199548069736316 "
" OUT " , " 14 " , " 1149.02 " , " 0.199721889068502 "
" FTW " , " 15 " , " 1150.02 " , " 0.199895708400688 "
" LIT " , " 16 " , " 1151.02 " , " 0.200069527732874 "
" MEN " , " 17 " , " 1152.02 " , " 0.200243347065061 "
" ACT " , " 18 " , " 1153.02 " , " 0.200417166397247 "
" BAS " , " 19 " , " 1154.02 " , " 0.200590985729433 "
" FTW " , " 20 " , " 1155.02 " , " 0.200764805061619 "
" LIT " , " 21 " , " 1156.02 " , " 0.200938624393805 "
" OUT " , " 22 " , " 1157.02 " , " 0.201112443725991 "
" WRS+3SF " , " 23 " , " 1158.02 " , " 0.201286263058177 "
" WAR " , " 24 " , " 1159.02 " , " 0.201460082390363 "
" WMN " , " 25 " , " 1160.02 " , " 0.20163390172255 "
" ACT " , " 26 " , " 1161.02 " , " 0.201807721054736 "
" BAS " , " 27 " , " 1162.02 " , " 0.201981540386922 "
" FTW " , " 28 " , " 1163.02 " , " 0.202155359719108 "
" LIT " , " 29 " , " 1164.02 " , " 0.202329179051294 "
" OUT " , " 30 " , " 1165.02 " , " 0.20250299838348 "
" WRS+3SF " , " 31 " , " 1166.02 " , " 0.202676817715666 "
" WAR " , " 32 " , " 1167.02 " , " 0.202850637047852 "
, " 78 " , " 5753.1 " , " 1 "
 " STORE " , " POZ " ,,
" WEEK 05/05/14 " ,,,
" Name " , " Quantity " , " Sales " , " % "
" EQU " , " 11 " , " 1146.02 " , " 0.199200431071944 "
" RUC " , " 12 " , " 1147.02 " , " 0.19937425040413 "
" KID " , " 13 " , " 1148.02 " , " 0.199548069736316 "
" OUT " , " 14 " , " 1149.02 " , " 0.199721889068502 "
" FTW " , " 15 " , " 1150.02 " , " 0.199895708400688 "
" LIT " , " 16 " , " 1151.02 " , " 0.200069527732874 "
" MEN " , " 17 " , " 1152.02 " , " 0.200243347065061 "
" ACT " , " 18 " , " 1153.02 " , " 0.200417166397247 "
" BAS " , " 19 " , " 1154.02 " , " 0.200590985729433 "
" FTW " , " 20 " , " 1155.02 " , " 0.200764805061619 "
" LIT " , " 21 " , " 1156.02 " , " 0.200938624393805 "
" OUT " , " 22 " , " 1157.02 " , " 0.201112443725991 "
" WRS+3SF " , " 23 " , " 1158.02 " , " 0.201286263058177 "
" WAR " , " 24 " , " 1159.02 " , " 0.201460082390363 "
" WMN " , " 25 " , " 1160.02 " , " 0.20163390172255 "
" ACT " , " 26 " , " 1161.02 " , " 0.201807721054736 "
" BAS " , " 27 " , " 1162.02 " , " 0.201981540386922 "
" FTW " , " 28 " , " 1163.02 " , " 0.202155359719108 "
" LIT " , " 29 " , " 1164.02 " , " 0.202329179051294 "
" OUT " , " 30 " , " 1165.02 " , " 0.20250299838348 "
" WRS+3SF " , " 31 " , " 1166.02 " , " 0.202676817715666 "
" WAR " , " 32 " , " 1167.02 " , " 0.202850637047852 "
, " 78 " , " 5753.1 " , " 1 "
 " STORE " , " ANN " ,,
" WEEK 05/05/14 " ,,,
" Name " , " Quantity " , " Sales " , " % "
" EQU " , " 11 " , " 1146.02 " , " 0.199200431071944 "
" RUC " , " 12 " , " 1147.02 " , " 0.19937425040413 "
" KID " , " 13 " , " 1148.02 " , " 0.199548069736316 "
" OUT " , " 14 " , " 1149.02 " , " 0.199721889068502 "
" FTW " , " 15 " , " 1150.02 " , " 0.199895708400688 "
" LIT " , " 16 " , " 1151.02 " , " 0.200069527732874 "
" MEN " , " 17 " , " 1152.02 " , " 0.200243347065061 "
" ACT " , " 18 " , " 1153.02 " , " 0.200417166397247 "
" BAS " , " 19 " , " 1154.02 " , " 0.200590985729433 "
" FTW " , " 20 " , " 1155.02 " , " 0.200764805061619 "
" LIT " , " 21 " , " 1156.02 " , " 0.200938624393805 "
" OUT " , " 22 " , " 1157.02 " , " 0.201112443725991 "
" WRS+3SF " , " 23 " , " 1158.02 " , " 0.201286263058177 "
" WAR " , " 24 " , " 1159.02 " , " 0.201460082390363 "
" WMN " , " 25 " , " 1160.02 " , " 0.20163390172255 "
" ACT " , " 26 " , " 1161.02 " , " 0.201807721054736 "
" BAS " , " 27 " , " 1162.02 " , " 0.201981540386922 "
" FTW " , " 28 " , " 1163.02 " , " 0.202155359719108 "
" LIT " , " 29 " , " 1164.02 " , " 0.202329179051294 "
" OUT " , " 30 " , " 1165.02 " , " 0.20250299838348 "
" WRS+3SF " , " 31 " , " 1166.02 " , " 0.202676817715666 "
" WAR " , " 32 " , " 1167.02 " , " 0.202850637047852 "
, " 78 " , " 5753.1 " , " 1 "
 " STORE " , " SZC " ,,
" WEEK 05/05/14 " ,,,
" Name " , " Quantity " , " Sales " , " % "
" EQU " , " 11 " , " 1146.02 " , " 0.199200431071944 "
" RUC " , " 12 " , " 1147.02 " , " 0.19937425040413 "
" KID " , " 13 " , " 1148.02 " , " 0.199548069736316 "
" OUT " , " 14 " , " 1149.02 " , " 0.199721889068502 "
" FTW " , " 15 " , " 1150.02 " , " 0.199895708400688 "
" LIT " , " 16 " , " 1151.02 " , " 0.200069527732874 "
" MEN " , " 17 " , " 1152.02 " , " 0.200243347065061 "
" ACT " , " 18 " , " 1153.02 " , " 0.200417166397247 "
" BAS " , " 19 " , " 1154.02 " , " 0.200590985729433 "
" FTW " , " 20 " , " 1155.02 " , " 0.200764805061619 "
" LIT " , " 21 " , " 1156.02 " , " 0.200938624393805 "
" OUT " , " 22 " , " 1157.02 " , " 0.201112443725991 "
" WRS+3SF " , " 23 " , " 1158.02 " , " 0.201286263058177 "
" WAR " , " 24 " , " 1159.02 " , " 0.201460082390363 "
" WMN " , " 25 " , " 1160.02 " , " 0.20163390172255 "
" ACT " , " 26 " , " 1161.02 " , " 0.201807721054736 "
" BAS " , " 27 " , " 1162.02 " , " 0.201981540386922 "
" FTW " , " 28 " , " 1163.02 " , " 0.202155359719108 "
" LIT " , " 29 " , " 1164.02 " , " 0.202329179051294 "
" OUT " , " 30 " , " 1165.02 " , " 0.20250299838348 "
" WRS+3SF " , " 31 " , " 1166.02 " , " 0.202676817715666 "
" WAR " , " 32 " , " 1167.02 " , " 0.202850637047852 "
, " 78 " , " 5753.1 " , " 1 "
 " STORE " , " ZAK " ,,
" WEEK 05/05/14 " ,,,
" Name " , " Quantity " , " Sales " , " % "
" EQU " , " 11 " , " 1146.02 " , " 0.199200431071944 "
" RUC " , " 12 " , " 1147.02 " , " 0.19937425040413 "
" KID " , " 13 " , " 1148.02 " , " 0.199548069736316 "
" OUT " , " 14 " , " 1149.02 " , " 0.199721889068502 "
" FTW " , " 15 " , " 1150.02 " , " 0.199895708400688 "
" LIT " , " 16 " , " 1151.02 " , " 0.200069527732874 "
" MEN " , " 17 " , " 1152.02 " , " 0.200243347065061 "
" ACT " , " 18 " , " 1153.02 " , " 0.200417166397247 "
" BAS " , " 19 " , " 1154.02 " , " 0.200590985729433 "
" FTW " , " 20 " , " 1155.02 " , " 0.200764805061619 "
" LIT " , " 21 " , " 1156.02 " , " 0.200938624393805 "
" OUT " , " 22 " , " 1157.02 " , " 0.201112443725991 "
" WRS+3SF " , " 23 " , " 1158.02 " , " 0.201286263058177 "
" WAR " , " 24 " , " 1159.02 " , " 0.201460082390363 "
" WMN " , " 25 " , " 1160.02 " , " 0.20163390172255 "
" ACT " , " 26 " , " 1161.02 " , " 0.201807721054736 "
" BAS " , " 27 " , " 1162.02 " , " 0.201981540386922 "
" FTW " , " 28 " , " 1163.02 " , " 0.202155359719108 "
" LIT " , " 29 " , " 1164.02 " , " 0.202329179051294 "
" OUT " , " 30 " , " 1165.02 " , " 0.20250299838348 "
" WRS+3SF " , " 31 " , " 1166.02 " , " 0.202676817715666 "
" WAR " , " 32 " , " 1167.02 " , " 0.202850637047852 "
, " 78 " , " 5753.1 " , " 1 "
 " STORE " , " GDA " ,,
" WEEK 05/05/14 " ,,,
" Name " , " Quantity " , " Sales " , " % "
" EQU " , " 11 " , " 1146.02 " , " 0.199200431071944 "
" RUC " , " 12 " , " 1147.02 " , " 0.19937425040413 "
" KID " , " 13 " , " 1148.02 " , " 0.199548069736316 "
" OUT " , " 14 " , " 1149.02 " , " 0.199721889068502 "
" FTW " , " 15 " , " 1150.02 " , " 0.199895708400688 "
" LIT " , " 16 " , " 1151.02 " , " 0.200069527732874 "
" MEN " , " 17 " , " 1152.02 " , " 0.200243347065061 "
" ACT " , " 18 " , " 1153.02 " , " 0.200417166397247 "
" BAS " , " 19 " , " 1154.02 " , " 0.200590985729433 "
" FTW " , " 20 " , " 1155.02 " , " 0.200764805061619 "
" LIT " , " 21 " , " 1156.02 " , " 0.200938624393805 "
" OUT " , " 22 " , " 1157.02 " , " 0.201112443725991 "
" WRS+3SF " , " 23 " , " 1158.02 " , " 0.201286263058177 "
" WAR " , " 24 " , " 1159.02 " , " 0.201460082390363 "
" WMN " , " 25 " , " 1160.02 " , " 0.20163390172255 "
" ACT " , " 26 " , " 1161.02 " , " 0.201807721054736 "
" BAS " , " 27 " , " 1162.02 " , " 0.201981540386922 "
" FTW " , " 28 " , " 1163.02 " , " 0.202155359719108 "
" LIT " , " 29 " , " 1164.02 " , " 0.202329179051294 "
" OUT " , " 30 " , " 1165.02 " , " 0.20250299838348 "
" WRS+3SF " , " 31 " , " 1166.02 " , " 0.202676817715666 "
" WAR " , " 32 " , " 1167.02 " , " 0.202850637047852 "
, " 78 " , " 5753.1 " , " 1 "