Help newbie to excel

B

Boggyfen

New Member
Joined
Oct 4, 2017
Messages
2
First of All Hi to All out there in MRExcel world.:biggrin:

I am fairly new to excel and I have been tasked with a pig of a query, I need to automate a report in one spread sheet to draw data from certain cells on tabs in another spread sheet held on a server.basically the report has to show the tonnages from a weekly (1 -52) from three cells Quay, Road & Rail.

What I would like to do is create a dropdown menu for weeks 1 - 52 in one cell in the report so that if I pick a week it will link the corresponding tab/cells in a separate workbook, to the cells in the report.

I had looked at '=indirect' statement but I have struggled to get this to work.

Any help in this will be greatly appreciated.

Regards & Thanks

Darren
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Sort by date Sort by votes
[TABLE="width: 336"]
<colgroup><col width="64" style="width: 48pt;" span="7"> <tbody>[TR]
[TD="width: 64, bgcolor: transparent"]stand alone workbook[/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: left"]<v:shapetype id="_x0000_t75" stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o:preferrelative="t" o:spt="75" coordsize="21600,21600"> <v:stroke joinstyle="miter"> <v:formulas> <v:f eqn="if lineDrawn pixelLineWidth 0"> <v:f eqn="sum @0 1 0"> <v:f eqn="sum 0 0 @1"> <v:f eqn="prod @2 1 2"> <v:f eqn="prod @3 21600 pixelWidth"> <v:f eqn="prod @3 21600 pixelHeight"> <v:f eqn="sum @0 0 1"> <v:f eqn="prod @6 1 2"> <v:f eqn="prod @7 21600 pixelWidth"> <v:f eqn="sum @8 21600 0"> <v:f eqn="prod @7 21600 pixelHeight"> <v:f eqn="sum @10 21600 0"> </v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas> <v:path o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"> <o:lock aspectratio="t" v:ext="edit"> </o:lock></v:path></v:stroke></v:shapetype><v:shape id="TextBox_x0020_1" style="width: 245.25pt; height: 52.5pt; margin-top: 78.75pt; margin-left: 6pt; visibility: visible; position: absolute; z-index: 2; mso-wrap-style: square; v-text-anchor: top;" type="#_x0000_t75" o:insetmode="auto" o:gfxdata="UEsDBBQABgAIAAAAIQC75UiUBQEAAB4CAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbKSRvU7DMBSF
dyTewfKKEqcMCKEmHfgZgaE8wMW+SSwc27JvS/v23KTJgkoXFsu+P+c7Ol5vDoMTe0zZBl/LVVlJ
gV4HY31Xy4/tS3EvRSbwBlzwWMsjZrlprq/W22PELHjb51r2RPFBqax7HCCXIaLnThvSAMTP1KkI
+gs6VLdVdad08ISeCho1ZLN+whZ2jsTzgcsnJwldluLxNDiyagkxOquB2Knae/OLUsyEkjenmdzb
mG/YhlRnCWPnb8C898bRJGtQvEOiVxjYhtLOxs8AySiT4JuDystlVV4WPeM6tK3VaILeDZxIOSsu
ti/jidNGNZ3/J08yC1dNv9v8AAAA//8DAFBLAwQUAAYACAAAACEArTA/8cEAAAAyAQAACwAAAF9y
ZWxzLy5yZWxzhI/NCsIwEITvgu8Q9m7TehCRpr2I4FX0AdZk2wbbJGTj39ubi6AgeJtl2G9m6vYx
jeJGka13CqqiBEFOe2Ndr+B03C3WIDihMzh6RwqexNA281l9oBFTfuLBBhaZ4ljBkFLYSMl6oAm5
8IFcdjofJ0z5jL0MqC/Yk1yW5UrGTwY0X0yxNwri3lQgjs+Qk/+zfddZTVuvrxO59CNCmoj3vCwj
MfaUFOjRhrPHaN4Wv0VV5OYgm1p+LW1eAAAA//8DAFBLAwQUAAYACAAAACEAzbVDvJkDAAAADgAA
HwAAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWzUV8tu2zgU3Q8w/3DBxXQxSRzZ8iOe
ygWaNsEAxTRIUnRNU5QlmCI1JP3q1/deio5ctw3Qx8YbPch7r845fB29fLWtFayldZXRGUsuLhlI
LUxe6UXGPjzenE8YOM91zpXRMmM76dir2Z9/vOTTheVNWQnACtpNecZK75tpr+dEKWvuLkwjNfYV
xtbc46td9HLLN1i5Vr3+5eWoV/NKs1lX6g33HFa2+olSyoilzK+5XnOHJZWYHrZEjEr8emU+1etb
2zw0d5aQi//WdxaqPGOonOY1SsR6sSOG4WvvKGvRFdgWtqZ4UxSwzdhoMpxcYqkdDgZqlAyTtpzc
ehDYP0iSdDQeMhAYMUrHYwxuv1e+f76CKN8+XwNBtmDw4QCgawieXn/NuL9n/IjoXpstRKyoCQWD
32Ij8iCAQYF9CRfF+z3cn3DzaWOdv5WmBnrImJXCh/nF1++cb1HsQ4iUM6rKbyqlwgtNW3mtLKy5
ypjye9xfRCkNm4xdDfs0BHWD4+70Inzji7CwBrpiXAipv1UQsSsd1Nlr4rcPQXASL98RsDneUU1c
pP49XgplEIFQVcOgNPbTcdsGlyWi+n/FrWRgvbo2SAenFNcC4zPm2wmjnH/wOyXpE2qtEhqxmtt3
IbbSOQKmR+rOZXGPve4TDmaCEy7I9Yx2+fLb2nFfafC7RhZc4EL5u9bnKqKR/KhD8jiv3VGHcHE+
taiCeBF/pNLvqKTDMa4iBqfHh0hEPoOOz1WSpqfJh0hEPmnHJxmMk9FpEiIWkdDwgNCkPwkb+OnN
OGIRCY06Qv3+BAfoJJcQsYiExgeExungRPcEYhEJTTpCxOZENwViEQldHRAaDccnuikQi/ZEOjhd
w3keeFo8RRUnay31+e1rtNb7IzV4OD/7WEpNXsmHIm0OCfT9RJhzJ1VF3jw6QT+DnVkBHvbGSfCl
hI2US0jO+mcDkF4Ad8AhB2sayM1GQy316gL+hY1ZqRxUtcQsg3e9pPuLR+n8C3CNlTwHV0rpqdmV
ZhOKe+O5glx6XimHBy0IqfBhnp6JFP7idfMP5OnFESmp8ztuObmK7+qBMqByJMaTFVo5+dDco6tr
vdzeK7knH6PvZYFuHF1ndCnCLubk6dD34B6GwuN1HqUK5gsTSOACXeAP5sYUypZFgaB+MP8pKXzf
6C6/rrSxjJqPfGRnrIo2PugT6SMd8uq9o3+fEBL/1egH6/B99hkAAP//AwBQSwMEFAAGAAgAAAAh
AP3BWu/OBgAAPRwAABoAAABjbGlwYm9hcmQvdGhlbWUvdGhlbWUxLnhtbOxZT28bRRS/I/EdRntv
4/+NozpV7NgNtGmj2C3qcbwe704zu7OaGSf1DbVHJCREQVyQuHFAQKVW4lI+TaAIitSvwJuZ3fVO
vCZJG4EozSHeffub9/+9ebN79dqDiKFDIiTlccerXq54iMQ+n9A46Hh3RoNL6x6SCscTzHhMOt6c
SO/a5vvvXcUbPqPJmGMxGYUkIggYxXIDd7xQqWRjbU36QMbyMk9IDM+mXERYwa0I1iYCH4GAiK3V
KpXWWoRp7G0CR6UZ9Rn8i5XUBJ+JoWZDUIwjkH57OqU+MdjJQVUj5Fz2mECHmHU84DnhRyPyQHmI
YangQcermD9vbfPqGt5IFzG1Ym1h3cD8pevSBZODmpEpgnEutDpotK9s5/wNgKllXL/f7/WrOT8D
wL4Pllpdijwbg/VqN+NZANnLZd69SrPScPEF/vUlndvdbrfZTnWxTA3IXjaW8OuVVmOr5uANyOKb
S/hGd6vXazl4A7L41hJ+cKXdarh4AwoZjQ+W0Dqgg0HKPYdMOdspha8DfL2SwhcoyIY8u7SIKY/V
qlyL8H0uBgDQQIYVjZGaJ2SKfcjJHo7GgmItAG8QXHhiSb5cImlZSPqCJqrjfZjg2CtAXj3//tXz
p+jV8yfHD58dP/zp+NGj44c/Wl7Owh0cB8WFL7/97M+vP0Z/PP3m5eMvyvGyiP/1h09++fnzciBU
0MLCF18++e3Zkxdfffr7d49L4FsCj4vwEY2IRLfIEdrnEdhmHONqTsbifCtGIabOChwC7xLWfRU6
wFtzzMpwXeI6766A5lEGvD677+g6DMVM0RLJN8LIAe5yzrpclDrghpZV8PBoFgflwsWsiNvH+LBM
dg/HTmj7swS6ZpaUju97IXHU3GM4VjggMVFIP+MHhJRYd49Sx6+71Bdc8qlC9yjqYlrqkhEdO4m0
WLRDI4jLvMxmCLXjm927qMtZmdXb5NBFQkFgVqL8iDDHjdfxTOGojOUIR6zo8JtYhWVKDufCL+L6
UkGkA8I46k+IlGVrbguwtxD0Gxj6VWnYd9k8cpFC0YMynjcx50XkNj/ohThKyrBDGodF7AfyAFIU
oz2uyuC73K0QfQ9xwPHKcN+lxAn36Y3gDg0clRYJop/MREksrxPu5O9wzqaYmC4DLd3p1BGN/65t
Mwp920p417Y73hZsYmXFs3OiWa/C/Qdb9DaexXsEqmJ5i3rXod91aO+t79Cravni+/KiFUOX1gOJ
nbXN5B2tHLynlLGhmjNyU5rZW8IGNBkAUa8zB0ySH8SSEC51JYMABxcIbNYgwdVHVIXDECcwt1c9
zSSQKetAooRLOC8acilvjYfZX9nTZlOfQ2znkFjt8okl1zU5O27kbIxWgTnTZoLqmsFZhdWvpEzB
ttcRVtVKnVla1ahmmqIjLTdZu9icy8HluWlAzL0Jkw2CeQi83IIjvhYN5x3MyET73cYoC4uJwkWG
SIZ4QtIYabuXY1Q1QcpyZckQbYdNBn12PMVrBWltzfYNpJ0lSEVxjRXisui9SZSyDF5ECbidLEcW
F4uTxeio47WbtaaHfJx0vCkcleEySiDqUg+TmAXwkslXwqb9qcVsqnwRzXZmmFsEVXj7Yf2+ZLDT
BxIh1TaWoU0N8yhNARZrSVb/WhPcelEGlHSjs2lRX4dk+Ne0AD+6oSXTKfFVMdgFivadvU1bKZ8p
Iobh5AiN2UzsYwi/TlWwZ0IlvPEwHUHfwOs57W3zyG3OadEVX4oZnKVjloQ4bbe6RLNKtnDTkHId
zF1BPbCtVHdj3PlNMSV/QaYU0/h/ZoreT+AVRH2iI+DDu16Bka6UjseFCjl0oSSk/kDA4GB6B2QL
vOKFx5BU8GLa/ApyqH9tzVkepqzhJKn2aYAEhf1IhYKQPWhLJvtOYVZN9y7LkqWMTEYV1JWJVXtM
Dgkb6R7Y0nu7h0JIddNN0jZgcCfzz71PK2gc6CGnWG9OJ8v3XlsD//TkY4sZjHL7sBloMv/nKubj
wWJXtevN8mzvLRqiHyzGrEZWFSCssBW007J/TRXOudXajrVkca2ZKQdRXLYYiPlAlMCLJKT/wf5H
hc/sRwy9oY74PvRWBN8vNDNIG8jqS3bwQLpBWuIYBidLtMmkWVnXpqOT9lq2WV/wpJvLPeFsrdlZ
4n1OZ+fDmSvOqcWLdHbqYcfXlrbS1RDZkyUKpGl2kDGBKfuYtYsTNA6qHQ8+KEGgH8AVfJLygFbT
tJqmwRV8Z4JhyX4c6njpRUaB55aSY+oZpZ5hGhmlkVGaGQWGs/QzTEZpQafSX07gy53+8VD2kQQm
uPSjStZUnS9+m38BAAD//wMAUEsDBBQABgAIAAAAIQCcZkZBuwAAACQBAAAqAAAAY2xpcGJvYXJk
L2RyYXdpbmdzL19yZWxzL2RyYXdpbmcxLnhtbC5yZWxzhI/NCsIwEITvgu8Q9m7SehCRJr2I0KvU
BwjJNi02PyRR7Nsb6EVB8LIws+w3s037sjN5YkyTdxxqWgFBp7yenOFw6y+7I5CUpdNy9g45LJig
FdtNc8VZ5nKUxikkUigucRhzDifGkhrRykR9QFc2g49W5iKjYUGquzTI9lV1YPGTAeKLSTrNIXa6
BtIvoST/Z/thmBSevXpYdPlHBMulFxagjAYzB0pXZ501LV2BiYZ9/SbeAAAA//8DAFBLAQItABQA
BgAIAAAAIQC75UiUBQEAAB4CAAATAAAAAAAAAAAAAAAAAAAAAABbQ29udGVudF9UeXBlc10ueG1s
UEsBAi0AFAAGAAgAAAAhAK0wP/HBAAAAMgEAAAsAAAAAAAAAAAAAAAAANgEAAF9yZWxzLy5yZWxz
UEsBAi0AFAAGAAgAAAAhAM21Q7yZAwAAAA4AAB8AAAAAAAAAAAAAAAAAIAIAAGNsaXBib2FyZC9k
cmF3aW5ncy9kcmF3aW5nMS54bWxQSwECLQAUAAYACAAAACEA/cFa784GAAA9HAAAGgAAAAAAAAAA
AAAAAAD2BQAAY2xpcGJvYXJkL3RoZW1lL3RoZW1lMS54bWxQSwECLQAUAAYACAAAACEAnGZGQbsA
AAAkAQAAKgAAAAAAAAAAAAAAAAD8DAAAY2xpcGJvYXJkL2RyYXdpbmdzL19yZWxzL2RyYXdpbmcx
LnhtbC5yZWxzUEsFBgAAAAAFAAUAZwEAAP8NAAAAAA==
" o:spid="_x0000_s1026"> <v:imagedata o:title="" src="file:///C:\DOCUME~1\DELLER~1\LOCALS~1\Temp\f\msohtmlclip1\01\clip_image001.png"> <o:lock aspectratio="f" v:ext="edit"> <x:clientdata ObjectType="Pict"> <x:sizewithcells><x:cf>When you choose the week 1,2,3 etc as adrop down menu. I would like to link to 'Test' spread sheet to show the totaldetails in cells b4,c4 & d4.</x:cf><x:autopict> </x:autopict></x:sizewithcells></x:clientdata> </o:lock></v:imagedata></v:shape><v:shape id="Straight_x0020_Arrow_x0020_Connector_x0020_3" style="width: 13.5pt; height: 70.5pt; margin-top: 9.75pt; margin-left: 150pt; visibility: visible; position: absolute; z-index: 3;" type="#_x0000_t75" o:gfxdata="UEsDBBQABgAIAAAAIQC75UiUBQEAAB4CAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbKSRvU7DMBSF
dyTewfKKEqcMCKEmHfgZgaE8wMW+SSwc27JvS/v23KTJgkoXFsu+P+c7Ol5vDoMTe0zZBl/LVVlJ
gV4HY31Xy4/tS3EvRSbwBlzwWMsjZrlprq/W22PELHjb51r2RPFBqax7HCCXIaLnThvSAMTP1KkI
+gs6VLdVdad08ISeCho1ZLN+whZ2jsTzgcsnJwldluLxNDiyagkxOquB2Knae/OLUsyEkjenmdzb
mG/YhlRnCWPnb8C898bRJGtQvEOiVxjYhtLOxs8AySiT4JuDystlVV4WPeM6tK3VaILeDZxIOSsu
ti/jidNGNZ3/J08yC1dNv9v8AAAA//8DAFBLAwQUAAYACAAAACEArTA/8cEAAAAyAQAACwAAAF9y
ZWxzLy5yZWxzhI/NCsIwEITvgu8Q9m7TehCRpr2I4FX0AdZk2wbbJGTj39ubi6AgeJtl2G9m6vYx
jeJGka13CqqiBEFOe2Ndr+B03C3WIDihMzh6RwqexNA281l9oBFTfuLBBhaZ4ljBkFLYSMl6oAm5
8IFcdjofJ0z5jL0MqC/Yk1yW5UrGTwY0X0yxNwri3lQgjs+Qk/+zfddZTVuvrxO59CNCmoj3vCwj
MfaUFOjRhrPHaN4Wv0VV5OYgm1p+LW1eAAAA//8DAFBLAwQUAAYACAAAACEAHxLmHtQBAACDBAAA
HwAAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWykVMGO0zAQvSPxD5bvbNIuRW206QqV
ZS8IVlvgPnLsxsIZR7bJpn/POHHSqkKVYC+JnZn35r3xOHf3fWNYJ53XFku+uMk5kyhspfFQ8h/f
P79bc+YDYAXGoiz5UXp+v3375g6Kg4O21oIRA/oCSl6H0BZZ5kUtG/A3tpVIMWVdA4G27pBVDl6I
uTHZMs8/ZA1o5NsT1ScIwH47/R9UxopfstoBduCJ0oji/EvSaMTrmaHA7tG1+/bJReXia/fkmK5K
Tp1DaKhFPEuBlEbb7AJ1OBH0yjUx3yrF+pIvV5t8nRPXseS3m3y1XI10sg9MUHwTvzBB0fVis1gt
UrH623W4qB+uEJC8UQYtzqSJHvdt1IbdLi4vHb+fHO+DA32oA/vonH1hO4soRbCO3c69SARTL874
fOKNCpgyuv1JczhMxStaMjuConU+PErbsLgouU9aZ5FjLei++DCqmwDRucH4DKDNA1YsHFs6X4gm
ozEqEuP0mjz4cDRyxD1LRWNBJzbyD5dC7oxjHRjiEEJiGE5vYKHsCFPamBmYD024Ckz5ESqVop7/
C3hGDJUtnsCNRuv+Vj30k2Q15o/uR9dkJE1MdnH9hqz0u4h3/Hy//QMAAP//AwBQSwMEFAAGAAgA
AAAhAP3BWu/OBgAAPRwAABoAAABjbGlwYm9hcmQvdGhlbWUvdGhlbWUxLnhtbOxZT28bRRS/I/Ed
Rntv4/+NozpV7NgNtGmj2C3qcbwe704zu7OaGSf1DbVHJCREQVyQuHFAQKVW4lI+TaAIitSvwJuZ
3fVOvCZJG4EozSHeffub9/+9ebN79dqDiKFDIiTlccerXq54iMQ+n9A46Hh3RoNL6x6SCscTzHhM
Ot6cSO/a5vvvXcUbPqPJmGMxGYUkIggYxXIDd7xQqWRjbU36QMbyMk9IDM+mXERYwa0I1iYCH4GA
iK3VKpXWWoRp7G0CR6UZ9Rn8i5XUBJ+JoWZDUIwjkH57OqU+MdjJQVUj5Fz2mECHmHU84DnhRyPy
QHmIYangQcermD9vbfPqGt5IFzG1Ym1h3cD8pevSBZODmpEpgnEutDpotK9s5/wNgKllXL/f7/Wr
OT8DwL4Pllpdijwbg/VqN+NZANnLZd69SrPScPEF/vUlndvdbrfZTnWxTA3IXjaW8OuVVmOr5uAN
yOKbS/hGd6vXazl4A7L41hJ+cKXdarh4AwoZjQ+W0Dqgg0HKPYdMOdspha8DfL2SwhcoyIY8u7SI
KY/VqlyL8H0uBgDQQIYVjZGaJ2SKfcjJHo7GgmItAG8QXHhiSb5cImlZSPqCJqrjfZjg2CtAXj3/
/tXzp+jV8yfHD58dP/zp+NGj44c/Wl7Owh0cB8WFL7/97M+vP0Z/PP3m5eMvyvGyiP/1h09++fnz
ciBU0MLCF18++e3Zkxdfffr7d49L4FsCj4vwEY2IRLfIEdrnEdhmHONqTsbifCtGIabOChwC7xLW
fRU6wFtzzMpwXeI6766A5lEGvD677+g6DMVM0RLJN8LIAe5yzrpclDrghpZV8PBoFgflwsWsiNvH
+LBMdg/HTmj7swS6ZpaUju97IXHU3GM4VjggMVFIP+MHhJRYd49Sx6+71Bdc8qlC9yjqYlrqkhEd
O4m0WLRDI4jLvMxmCLXjm927qMtZmdXb5NBFQkFgVqL8iDDHjdfxTOGojOUIR6zo8JtYhWVKDufC
L+L6UkGkA8I46k+IlGVrbguwtxD0Gxj6VWnYd9k8cpFC0YMynjcx50XkNj/ohThKyrBDGodF7Afy
AFIUoz2uyuC73K0QfQ9xwPHKcN+lxAn36Y3gDg0clRYJop/MREksrxPu5O9wzqaYmC4DLd3p1BGN
/65tMwp920p417Y73hZsYmXFs3OiWa/C/Qdb9DaexXsEqmJ5i3rXod91aO+t79Cravni+/KiFUOX
1gOJnbXN5B2tHLynlLGhmjNyU5rZW8IGNBkAUa8zB0ySH8SSEC51JYMABxcIbNYgwdVHVIXDECcw
t1c9zSSQKetAooRLOC8acilvjYfZX9nTZlOfQ2znkFjt8okl1zU5O27kbIxWgTnTZoLqmsFZhdWv
pEzBttcRVtVKnVla1ahmmqIjLTdZu9icy8HluWlAzL0Jkw2CeQi83IIjvhYN5x3MyET73cYoC4uJ
wkWGSIZ4QtIYabuXY1Q1QcpyZckQbYdNBn12PMVrBWltzfYNpJ0lSEVxjRXisui9SZSyDF5ECbid
LEcWF4uTxeio47WbtaaHfJx0vCkcleEySiDqUg+TmAXwkslXwqb9qcVsqnwRzXZmmFsEVXj7Yf2+
ZLDTBxIh1TaWoU0N8yhNARZrSVb/WhPcelEGlHSjs2lRX4dk+Ne0AD+6oSXTKfFVMdgFivadvU1b
KZ8pIobh5AiN2UzsYwi/TlWwZ0IlvPEwHUHfwOs57W3zyG3OadEVX4oZnKVjloQ4bbe6RLNKtnDT
kHIdzF1BPbCtVHdj3PlNMSV/QaYU0/h/ZoreT+AVRH2iI+DDu16Bka6UjseFCjl0oSSk/kDA4GB6
B2QLvOKFx5BU8GLa/ApyqH9tzVkepqzhJKn2aYAEhf1IhYKQPWhLJvtOYVZN9y7LkqWMTEYV1JWJ
VXtMDgkb6R7Y0nu7h0JIddNN0jZgcCfzz71PK2gc6CGnWG9OJ8v3XlsD//TkY4sZjHL7sBloMv/n
KubjwWJXtevN8mzvLRqiHyzGrEZWFSCssBW007J/TRXOudXajrVkca2ZKQdRXLYYiPlAlMCLJKT/
wf5Hhc/sRwy9oY74PvRWBN8vNDNIG8jqS3bwQLpBWuIYBidLtMmkWVnXpqOT9lq2WV/wpJvLPeFs
rdlZ4n1OZ+fDmSvOqcWLdHbqYcfXlrbS1RDZkyUKpGl2kDGBKfuYtYsTNA6qHQ8+KEGgH8AVfJLy
gFbTtJqmwRV8Z4JhyX4c6njpRUaB55aSY+oZpZ5hGhmlkVGaGQWGs/QzTEZpQafSX07gy53+8VD2
kQQmuPSjStZUnS9+m38BAAD//wMAUEsDBBQABgAIAAAAIQCcZkZBuwAAACQBAAAqAAAAY2xpcGJv
YXJkL2RyYXdpbmdzL19yZWxzL2RyYXdpbmcxLnhtbC5yZWxzhI/NCsIwEITvgu8Q9m7SehCRJr2I
0KvUBwjJNi02PyRR7Nsb6EVB8LIws+w3s037sjN5YkyTdxxqWgFBp7yenOFw6y+7I5CUpdNy9g45
LJigFdtNc8VZ5nKUxikkUigucRhzDifGkhrRykR9QFc2g49W5iKjYUGquzTI9lV1YPGTAeKLSTrN
IXa6BtIvoST/Z/thmBSevXpYdPlHBMulFxagjAYzB0pXZ501LV2BiYZ9/SbeAAAA//8DAFBLAQIt
ABQABgAIAAAAIQC75UiUBQEAAB4CAAATAAAAAAAAAAAAAAAAAAAAAABbQ29udGVudF9UeXBlc10u
eG1sUEsBAi0AFAAGAAgAAAAhAK0wP/HBAAAAMgEAAAsAAAAAAAAAAAAAAAAANgEAAF9yZWxzLy5y
ZWxzUEsBAi0AFAAGAAgAAAAhAB8S5h7UAQAAgwQAAB8AAAAAAAAAAAAAAAAAIAIAAGNsaXBib2Fy
ZC9kcmF3aW5ncy9kcmF3aW5nMS54bWxQSwECLQAUAAYACAAAACEA/cFa784GAAA9HAAAGgAAAAAA
AAAAAAAAAAAxBAAAY2xpcGJvYXJkL3RoZW1lL3RoZW1lMS54bWxQSwECLQAUAAYACAAAACEAnGZG
QbsAAAAkAQAAKgAAAAAAAAAAAAAAAAA3CwAAY2xpcGJvYXJkL2RyYXdpbmdzL19yZWxzL2RyYXdp
bmcxLnhtbC5yZWxzUEsFBgAAAAAFAAUAZwEAADoMAAAAAA==
" o:spid="_x0000_s1027"> <v:imagedata o:title="" src="file:///C:\DOCUME~1\DELLER~1\LOCALS~1\Temp\f\msohtmlclip1\01\clip_image002.png"> <o:lock aspectratio="f" v:ext="edit"> <x:clientdata ObjectType="Pict"> <x:sizewithcells> <x:autopict> </x:autopict></x:sizewithcells></x:clientdata> </o:lock></v:imagedata></v:shape>
<tbody> [TD="width: 64, bgcolor: transparent"][/TD]
</tbody>
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]WEEK1[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"] road [/TD]
[TD="bgcolor: transparent"] rail [/TD]
[TD="bgcolor: transparent"] quay [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: #F2DCDB"] [/TD]
[TD="class: xl63, bgcolor: #F2DCDB"] [/TD]
[TD="class: xl63, bgcolor: #F2DCDB"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]----------------------------------------
separate workbook
[TABLE="width: 237"]
<colgroup><col width="64" style="width: 48pt;"> <col width="63" style="width: 47pt; mso-width-source: userset; mso-width-alt: 2304;" span="3"> <col width="64" style="width: 48pt;"> <tbody>[TR]
[TD="width: 64, bgcolor: transparent"]week 1[/TD]
[TD="width: 63, bgcolor: transparent"][/TD]
[TD="width: 63, bgcolor: transparent"][/TD]
[TD="width: 63, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]road[/TD]
[TD="bgcolor: transparent"]rail[/TD]
[TD="bgcolor: transparent"]quay[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]600.256 [/TD]
[TD="bgcolor: transparent, align: right"]1000.156[/TD]
[TD="bgcolor: transparent, align: right"] 1501.106[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]750.256 [/TD]
[TD="bgcolor: transparent, align: right"]1120.156[/TD]
[TD="bgcolor: transparent, align: right"]1601.106[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]550.256[/TD]
[TD="bgcolor: transparent, align: right"] 1350.156[/TD]
[TD="bgcolor: transparent, align: right"]1901.106[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]200.256[/TD]
[TD="bgcolor: transparent, align: right"]1500.156[/TD]
[TD="bgcolor: transparent, align: right"]901.106[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Total[/TD]
[TD="class: xl63, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DA9694]#DA9694[/URL] , align: right"]2101.024[/TD]
[TD="class: xl63, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DA9694]#DA9694[/URL] , align: right"]4970.624[/TD]
[TD="class: xl63, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DA9694]#DA9694[/URL] , align: right"]5904.424[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]----------------------[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]







[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]week 2
[TABLE="width: 288"]
<colgroup><col width="64" style="width: 48pt;" span="6"> <tbody>[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]road[/TD]
[TD="bgcolor: transparent"]rail[/TD]
[TD="bgcolor: transparent"]quay[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]500.256[/TD]
[TD="bgcolor: transparent, align: right"] 2000.156[/TD]
[TD="bgcolor: transparent, align: right"] 1901.106[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]850.256[/TD]
[TD="bgcolor: transparent, align: right"]2120.156[/TD]
[TD="bgcolor: transparent, align: right"]1801.106[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]750.256[/TD]
[TD="bgcolor: transparent, align: right"]1550.156[/TD]
[TD="bgcolor: transparent, align: right"]1701.106[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]900.256[/TD]
[TD="bgcolor: transparent, align: right"]2300.156[/TD]
[TD="bgcolor: transparent, align: right"]1801.106[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Total[/TD]
[TD="class: xl65, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DA9694]#DA9694[/URL] , align: right"]3001.024[/TD]
[TD="class: xl65, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DA9694]#DA9694[/URL] , align: right"]7970.624[/TD]
[TD="class: xl65, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DA9694]#DA9694[/URL] , align: right"]7204.424[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]--------------[/TD]
[TD="bgcolor: transparent"]

week 3
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][TABLE="width: 240"]
<colgroup><col width="64" style="width: 48pt;" span="5"> <tbody>[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]road[/TD]
[TD="bgcolor: transparent"]rail[/TD]
[TD="bgcolor: transparent"]quay[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]550.256[/TD]
[TD="bgcolor: transparent, align: right"] 2100.156[/TD]
[TD="bgcolor: transparent, align: right"] 1901.106[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]875.256[/TD]
[TD="bgcolor: transparent, align: right"]2010.156[/TD]
[TD="bgcolor: transparent, align: right"]1701.106[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]7460.256[/TD]
[TD="bgcolor: transparent, align: right"]1850.156[/TD]
[TD="bgcolor: transparent, align: right"]1901.106[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]1200.256[/TD]
[TD="bgcolor: transparent, align: right"]2600.156[/TD]
[TD="bgcolor: transparent, align: right"]1901.106[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Total[/TD]
[TD="class: xl65, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DA9694]#DA9694[/URL] , align: right"]10086.02[/TD]
[TD="class: xl65, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DA9694]#DA9694[/URL] , align: right"]8560.624[/TD]
[TD="class: xl65, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DA9694]#DA9694[/URL] , align: right"]7404.424[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]
Thankyou[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
ok, could you add a column to hold the week number immediately before your totals? (could be hidden if required)

send me a pm with your email, and I can send a worked example
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

ChrisMac1
  • Question Question
VBA - Compare specific data in one column on one sheet, with the same column on 4 other sheets, copy specific cells if match found.
Replies
1
Views
390
ChrisMac1
ChrisMac1
D
  • Question Question
Generating Reports in Word Using Data in Excel
Replies
1
Views
338
Dan_W
D
B
  • Question Question
Help with VBA code to copy/paste into another workbook then email
Replies
1
Views
426
bh24524
B
P
  • Question Question
Automating copying of columns within same sheet in excel using VBA.
Replies
1
Views
645
MountainFog
M
A
  • Question Question
Excel - looking up data with multiple criteria from table/array, date must be same or nearest before the target cell
Replies
8
Views
561
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,223,910
Messages
6,175,320
Members
452,635
Latest member
laura12345

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top