looping around several pages

Hi everyone!!

basically all i need it to do now is do this for multiple sheets selected from a drop down, (listed on a separate page). each sheet is a date for e.g 07.02.13 and basically the below code works mite be a bit long winded but it works lol!!

now the additional thing that i need it to do is store each i instead of writing it direct to cell_count i need it to total each i and then write it, ive tried a few things but its been a while since i used vb for 1 plus im only a novice! lol any help would be much appreciated!! i hope someone can help

Cheers

Excel / VB community

Please Login or Register  to view this content.

Please Login or Register  to view this content.

hmmm i see what your trying to do (i think) but it doesnt work.... what i need is the bit where it writes to columns c d e f g , i need it to retain the current values and then add the new value i tried this :-

Please Login or Register  to view this content.

but it didnt work.... just says cell value is empty when i break on next i each time it progress's it still says cell.value is empty any clues.... hopefully you understand what i mean

I think I had the data columns and the destination columns swapped. Try this...

Please Login or Register  to view this content.

this is the document im working on mite make more sense i get what your trying to do and its because im not explaining myself thanks for all your efforts so far