Copying select information from a row to another sheet
Is there a way to auto copy selected columns to a single budgeting sheet without manual cell linking?
We use multiple sheets to plan and track our ongoing projects but need key pieces of information brought over to a master sheet for budgeting. The individual sheets are used by our marketing department for planning events and the master sheet is used by our accounting department. The marketing department sheets have much more information (columns) than the accounting department needs and yet does not include key information that needs to be added/manipulated by accounting.
We can't use a report as accounting needs to have the ability to add additional information to the master budget sheet in columns that do not exist on the individual sheets.
It would be perfect if there was a way to auto copy rows and select the columns I want to copy rather than copy the entire row?
Help Article Resources
Check out the Formula Handbook template!