werra2006
05-15-2013, 11:01 AM
Hi I have a challenge for the VBA savvy geniuses here. I am still a newbie hence here to seek your help.
I am automating processes and need a code to automate the tabulation of items in worksheets UK, EURO and TOTAL. The tabulation will be driven by information from the DATA Sheet. I am aware that I could do the sumifs and all, but the problem is that the data from the DATA SHEET in Columns D & G changes all the time. The file is attached here for you to look at:
http://www.mediafire.com/view/?oq88ldq0makydo6
I am automating processes and need a code to automate the tabulation of items in worksheets UK, EURO and TOTAL. The tabulation will be driven by information from the DATA Sheet. I am aware that I could do the sumifs and all, but the problem is that the data from the DATA SHEET in Columns D & G changes all the time. The file is attached here for you to look at:
http://www.mediafire.com/view/?oq88ldq0makydo6