Copying specific information to another sheet
I would like to move specific information from a row and copy it to another sheet. I don't want to copy the entire row. Part of the information I want copied is the "Billing Month" (pull down menu format) and the "Overall Projected Volume" from the Master Sheet and have that amount from the "Overall Projected Volume" appear in the month (there is a column for each month) in the other sheet. In addition, if the "Billing Month" changes in the Master Sheet, I would like the volume in the other sheet to adjust to whatever month it is changed to from the Master Sheet.
Does that make any sense? Your help would open up a new world for us!
Help Article Resources
Check out the Formula Handbook template!