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) | ||||||||
