kojak43
Active Member
- Joined
- Feb 23, 2002
- Messages
- 270
I would like to have a worksheet to hold data. The fields would run from A:Q.
Once data is entered in the initial worksheet, I would like certain fields from that data worksheet, to populate a second and a third worksheet. Those next two sheets would be formatted to produce a report and a pivot table.
I can do much of the formatting for sheets 2 and 3, but do not have the ability to write the necessary code to fill the 2nd and 3rd sheets.
The field headers in sheets 2/3 would mirror header in sheet 1.
I tried to search previous posts to get some direction for this, but could not figure out a successful term to ge the search to work.
I am reasonably confident this can be done, I'm just not experienced enough to do this.
Any help is appreciated.
K
Once data is entered in the initial worksheet, I would like certain fields from that data worksheet, to populate a second and a third worksheet. Those next two sheets would be formatted to produce a report and a pivot table.
I can do much of the formatting for sheets 2 and 3, but do not have the ability to write the necessary code to fill the 2nd and 3rd sheets.
The field headers in sheets 2/3 would mirror header in sheet 1.
I tried to search previous posts to get some direction for this, but could not figure out a successful term to ge the search to work.
I am reasonably confident this can be done, I'm just not experienced enough to do this.
Any help is appreciated.
K