Thanks for your response. I've attached a Jpeg of the sheet i'm working on. the user would enter data on the left hand side (pale blue boxes, Columns B-C & E-J), my code then copies the info skiping blanks to Columns AE-AG then Summarises it in AI-AK. Its from here i would like to display these summarised results in a messagebox but as you can see on this occasion there would be 8 machines displayed, next time the might be 20 machines displayed and i'm unsure how to handle this. Yes i realise this would be alot easier just to display the result on the workbook but i'd like to try something abit new. Any help would be appreciated, thanks
What i'd like to see in the message box:
Machine1 1 £5
Machine2 2 £10
Machine3 3 £2
Machine4 4 £2
Total = £......
etc... incuding all machines in the summarised list
Bookmarks