M
Mldapril17
I have a Large Workbook on one worksheet; (8600 records & 20 Columns)!
I need to set up the worksheet so that I can use the records for my Word
03's mail merge data source. I have attended an Excel 2 day training, Cd
tutorials, and online training and searching and now I am turning to you for
guidance.
1. I created a header row on the first row for the field names.
2. I sorted the worksheet by state which placed a blank row between the last
record of that State, and the first record of the following State. 3. Next I
copied the header from the first row and pasted it above the first row of
each state.
4. I highlighted each States records then named them by that states
abbreviation.
I am stuck with these issues:
A. Can I use the same worksheet for the entire spreadsheet, or should I cut
and paste the states individually on different worksheets?
B. The data that will be merged into Word is not in sequencial order.
C. There are many records that have NULL in the cells. What are the steps
to sort them after the records that actually has data in them?
D. This PC is running Vista,and my other PC has XP Prof OS.
I would be so grateful if you would help me with obtaining the steps
necessary to set up my merging letter.
Thank you.
Marla
I need to set up the worksheet so that I can use the records for my Word
03's mail merge data source. I have attended an Excel 2 day training, Cd
tutorials, and online training and searching and now I am turning to you for
guidance.
1. I created a header row on the first row for the field names.
2. I sorted the worksheet by state which placed a blank row between the last
record of that State, and the first record of the following State. 3. Next I
copied the header from the first row and pasted it above the first row of
each state.
4. I highlighted each States records then named them by that states
abbreviation.
I am stuck with these issues:
A. Can I use the same worksheet for the entire spreadsheet, or should I cut
and paste the states individually on different worksheets?
B. The data that will be merged into Word is not in sequencial order.
C. There are many records that have NULL in the cells. What are the steps
to sort them after the records that actually has data in them?
D. This PC is running Vista,and my other PC has XP Prof OS.
I would be so grateful if you would help me with obtaining the steps
necessary to set up my merging letter.
Thank you.
Marla