christianhau
New Member
- Joined
- Aug 29, 2008
- Messages
- 1
Hi!
I am trying to streamline the product overview making it easier to view the sales of three different departments in one overview file. How it works today is that a responsible person in each of the departments adds information to an excel file consisting of columns such as order number, order date, customer, price and so on. It is a day to day update job that adds a unknown number of sales to the overview.
What I want to do is to combine a subset of the sale information added by the three responsible people to a a overview excel sheet that should record these entries and store them meaning that the list till dynamically grow over time. Is this possible? If it is here is a subquestion:
- How do I import an unknown number of rows from three different sheets to one holder sheet without overwriting eachother? All the rows that I want to import are independant of eachother.
An example list would be:
Sheet 1:
Price Order_number Customer
2 k5 IBM
Sheet 2:
Price Order_number Customer Weight
5 l6 Compaq 200
Sheet 3:
Price Order_number Customer
1 m2 Ziggy int.
Combined sheet:
Price Order_number Customer
2 k5 IBM
1 m2 Ziggy int.
5 l6 Compaq
Sorry for the bad example but found it a bit hard to describe it... Thanks for looking into it!
I am trying to streamline the product overview making it easier to view the sales of three different departments in one overview file. How it works today is that a responsible person in each of the departments adds information to an excel file consisting of columns such as order number, order date, customer, price and so on. It is a day to day update job that adds a unknown number of sales to the overview.
What I want to do is to combine a subset of the sale information added by the three responsible people to a a overview excel sheet that should record these entries and store them meaning that the list till dynamically grow over time. Is this possible? If it is here is a subquestion:
- How do I import an unknown number of rows from three different sheets to one holder sheet without overwriting eachother? All the rows that I want to import are independant of eachother.
An example list would be:
Sheet 1:
Price Order_number Customer
2 k5 IBM
Sheet 2:
Price Order_number Customer Weight
5 l6 Compaq 200
Sheet 3:
Price Order_number Customer
1 m2 Ziggy int.
Combined sheet:
Price Order_number Customer
2 k5 IBM
1 m2 Ziggy int.
5 l6 Compaq
Sorry for the bad example but found it a bit hard to describe it... Thanks for looking into it!
