I have put together (my meager skill level prohibits me from using the word "developed") a workbook with multiple sheets with tables and formulas, the end result of which is a "Results" sheet that is a summary of data that has been entered and/or calculated through the process. What I would like to do is have a "button" or even a macro that will take the resultant column of results and copy it to another workbook (or at least another sheet) as a row - basically a poor man's database. I know there are many other programs including Access that are better suited for this, but due to my skill and my company's software "library", I am limited to Excel.
Here's a quick simulation - after making entries on a worksheet, another sheet crunches that information and produces a "Results" page like this:
Date 9/30/15
Product Widget
Size Large
Price 9.95
Buyer Joe's Plumbing
I want a macro or a "button" to "click" and have that information added to another sheet or book on the next available row as:
9/30/15 Widget Large 9.95 Joe's Plumbing
Then I can use the data table that is produced to analyze and massage data in groups.
Is there any way to do this in Excel??
Here's a quick simulation - after making entries on a worksheet, another sheet crunches that information and produces a "Results" page like this:
Date 9/30/15
Product Widget
Size Large
Price 9.95
Buyer Joe's Plumbing
I want a macro or a "button" to "click" and have that information added to another sheet or book on the next available row as:
9/30/15 Widget Large 9.95 Joe's Plumbing
Then I can use the data table that is produced to analyze and massage data in groups.
Is there any way to do this in Excel??