Hello all,
As my first post, I'm looking for some help creating a macro for a summary page in a workbook. I did some searches, but I don't think the wording of my inquiry was effective.
Here's the jist; I have a 5 tab worksheet where sheets 2-5 have a lot of data, but only some of the data is needed for the summary. Column A has names, column C has a product name and column K has data that, if the value is greater than one, along with the product name and their name, need to be carried to specific columns in the summary worksheet. The intent is to have all of the information in sheets 2-5 updated weekly and once pasted, the macro would update the specifics automatically.
I'm a newb, but have a keen interest in developing my skills here. Hope someone can guide me a bit.
As my first post, I'm looking for some help creating a macro for a summary page in a workbook. I did some searches, but I don't think the wording of my inquiry was effective.
Here's the jist; I have a 5 tab worksheet where sheets 2-5 have a lot of data, but only some of the data is needed for the summary. Column A has names, column C has a product name and column K has data that, if the value is greater than one, along with the product name and their name, need to be carried to specific columns in the summary worksheet. The intent is to have all of the information in sheets 2-5 updated weekly and once pasted, the macro would update the specifics automatically.
I'm a newb, but have a keen interest in developing my skills here. Hope someone can guide me a bit.