Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Need help with Microsoft Excel PLEASE!!!

by Joelfan41 May 9, 2007 4:08AM PDT

I have tried researching arrays and macros, but I don't know how to complete this project! Here's the set up: trying to track sales with an easy to use Excel sheet. I have an Excel document that has worksheet pages labeled "Master", "Manager", "John", "Paul", "George", and so on. The master page has columns labeled "Date", "Stock#", "Customer", "Salesperson 1", & Salesperson 2". So my question is, how do I populate the entire ROW of information onto the other worksheets for each salesperson? If someone knows and can help, I have a sample document I can email if you can input the formula or array once, I can reproduce it as needed.

Discussion is locked

1 Posts

- Collapse + Expand Details

- Collapse -

To me ...

by Kees Bakker May 9, 2007 6:56AM PDT

it seems you'd better create an easy to use database solution, in MS Access for example. Although it might be possible in Excel (I can't tell, because your requirements aren't clear to me in the first place), a database program is MEANT for such an application and not just MAYBE USABLE.

Kees

Back to Office & Productivity Software forum