Hi some very kind user has already been a great help to me and written some code for retrieving data from a database file and copying a sum of values into a specific cell as follows.
Database contains 24 rows per day and has a columns (column c) which is sales for every hour of that day.
the code that is already written takes the sum of those 24 hours rows in column c and pasted the answer in the next available cell in a range on another sheet.
It is easy to see when you look at the attached file.
However can anyone see why it might not be copying data from the 5th to the 12th specifically, because I am stuck.
Thanks in advance,
Dan.
Bookmarks