keithb
04-16-2011, 03:43 PM
I have a code in sheet2 of this attached workbook that I need help modifing. I want to add 2 more columns to the extraction process.
This code pulls data from 7 different worksheets into one summary page based on sale inputs. All I need to do is enter 2 more columns and have this code pull out the new columns. This code also does calculations on the data it pulls as you will see. I will also need a calculation performed on the second column I am going to enter (The column titled "Down"). If someone can get me to that point I know how to make changes to the calculation amounts.
I will place the 2 columns into the 1st worksheet titled "Monday" so you may see what I am trying to accomplish.
I would really appreciate help on this.
Keithb
This code pulls data from 7 different worksheets into one summary page based on sale inputs. All I need to do is enter 2 more columns and have this code pull out the new columns. This code also does calculations on the data it pulls as you will see. I will also need a calculation performed on the second column I am going to enter (The column titled "Down"). If someone can get me to that point I know how to make changes to the calculation amounts.
I will place the 2 columns into the 1st worksheet titled "Monday" so you may see what I am trying to accomplish.
I would really appreciate help on this.
Keithb