reneresendez
New Member
- Joined
- Jun 27, 2002
- Messages
- 43
I pull data from a Database source, that always needs to be copied to a new sheet, so it can be formated for charting. My issue is that the data changes based on different requirements. How can I use VBA to move the data to a new sheet for charting.
Thanks for your help
Thanks for your help
Mr Excel File.xls | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | DATAPAGE | |||||||
2 | 2 | ACCOUNTA | ||||||
3 | 1 | PRODUCT1 | Notes | |||||
4 | 3 | BaseSales | IncrementalSales | A2=#ofAccounts | ||||
5 | 1-Jan-06 | $51,352 | $1,530 | A3=#ofDataWeeks | ||||
6 | A4=#ofProducts | |||||||
7 | PRODUCT2 | |||||||
8 | BaseSales | IncrementalSales | UserFormwillbeusedforA2,A3,A4 | |||||
9 | 1-Jan-06 | $0 | $0 | |||||
10 | ||||||||
11 | PRODUCT3 | |||||||
12 | BaseSales | IncrementalSales | ||||||
13 | 1-Jan-06 | $23 | $0 | |||||
14 | ||||||||
15 | ACCOUNTB | |||||||
16 | PRODUCT1 | |||||||
17 | BaseSales | IncrementalSales | ||||||
18 | 1-Jan-06 | $158 | $58 | |||||
19 | ||||||||
20 | PRODUCT2 | |||||||
21 | BaseSales | IncrementalSales | ||||||
22 | 1-Jan-06 | $0 | $0 | |||||
23 | ||||||||
24 | PRODUCT3 | |||||||
25 | BaseSales | IncrementalSales | ||||||
26 | 1-Jan-06 | $99 | $2 | |||||
Data Page (2) |