Is there anyway to setup a template in Excel using Microsoft Query, whereby it can be refreshed to include new data and the new data will fit into the template under its appropriate heading?
For Example
I have the following data:
AssetID Descr1 DivID User3 User4 DocAmt Perpost User1
000984 MVP REMOTE AUDIT SWITCH AKFRGAM 3000 1695 1695.00 200301 GAM-03-E22
It is all expressed in headings etc. What I want to be able to do is for each User1 field setup a template in a spreadsheet that I can refresh every month that new data under each of the headings associated with the User1 field are listed under those headings such as follows:
AssetID Descr1 DivID User3 User4 DocAmt Perpost User1
000984 MVP REMOTE AUDIT SWITCH AKFRGAM 3000 1695 1695.00 200301 GAM-03-E22
001126 SPRINTQUIP COIN SCALES AKFRGAM 3000 1695 622.22 200302 GAM-03-E22
The new AssetID ‘001126’ is now listed under its appropriate User1 field.
So the new data for the new period 200302 has gone to the appropriate User1 and so on and so forth. This would save a lot of time formatting the spreadsheet each month.
Any suggestions/ideas?
Regards
Brick
For Example
I have the following data:
AssetID Descr1 DivID User3 User4 DocAmt Perpost User1
000984 MVP REMOTE AUDIT SWITCH AKFRGAM 3000 1695 1695.00 200301 GAM-03-E22
It is all expressed in headings etc. What I want to be able to do is for each User1 field setup a template in a spreadsheet that I can refresh every month that new data under each of the headings associated with the User1 field are listed under those headings such as follows:
AssetID Descr1 DivID User3 User4 DocAmt Perpost User1
000984 MVP REMOTE AUDIT SWITCH AKFRGAM 3000 1695 1695.00 200301 GAM-03-E22
001126 SPRINTQUIP COIN SCALES AKFRGAM 3000 1695 622.22 200302 GAM-03-E22
The new AssetID ‘001126’ is now listed under its appropriate User1 field.
So the new data for the new period 200302 has gone to the appropriate User1 and so on and so forth. This would save a lot of time formatting the spreadsheet each month.
Any suggestions/ideas?
Regards
Brick
