Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

How do I merge data from excel into a Word template?

I am trying to put together a calendar events list for my organization that
will be publicized in the local press. I have set up a web page that allows
folks to input specific information about their event which I can then
download to an Excel spreadsheet. From there I want to be able to import the
data (what, when, where, etc.) into a Word document. Copy and paste takes way
too much time and I don't know a thing about macros. How can I create one
Word template that includes data fields that links to specific cells in
Excel? Mail Merge would seem to be the obvious answer however I am not trying
to create several form letters, I am trying to create one document that lists
several different events. Any help in layman's terms is greatly appreciated!


Post your answer or comment

comments powered by Disqus
I am trying to put together a calendar events list for my organization that
will be publicized in the local press. I have set up a web page that allows
folks to input specific information about their event which I can then
download to an Excel spreadsheet. From there I want to be able to import the
data (what, when, where, etc.) into a Word document. Copy and paste takes way
too much time and I don't know a thing about macros. How can I create one
Word template that includes data fields that links to specific cells in
Excel? Mail Merge would seem to be the obvious answer however I am not trying
to create several form letters, I am trying to create one document that lists
several different events. Any help in layman's terms is greatly appreciated!

How do i merge numbers from excel to word without them changing? I have tried
everything, but when the merge is complete all number fields have added about
9 decimal points?? do you have any suggestions?

how do i transfer data from excel to my maximer

How do I get data automatically entered into a cell when I enter data into an
adjoining cell? I'm doing a payroll project, and I basically want to enter a
name in one cell and have that person's hourly wage data automatically
entered in the next cell without having to type in the dollar amount every
time.

Hi, how do i import data from a closed Excel spreadsheet into an open Excel
spreadsheet? (wihtout having to open the source file spreadheet)

Hi all
I have two columns in my spreadsheet:

Name and amount due:

I have 100 records of a name of a person and amount due for each.

I wanna be able to Extract Each data from the spreadsheet
and put it into a general Word Document Template for example

Dear [name goes here],

Please advised that you have $[amount due] left and this should be
paid by the end of the month.

Sincerely,
Your accountant.

How do i go about extracting this data and just basically automating the whole process?

Thank you
-Khaled

Can I merge data from Excel or Word document into a PowerPoint presentation.
I know I can cut and paste individual entries but can I merge all information/

How do I get data from invoice template into Excel proper. I have invoices of
my customers as single files. I am trying to extract data from each field in
the invoice template, such as first name, last name etc. Can someone suggest
a way of doing this?

How do I reference data from one worksheet to another worksheet cell with a
combo box and then have the data relating to this appear in the nesxt cell in
a combo box.

ie.- Workssheet 2, cell D6 need to reference worksheet 1 cells C2 & C3
(Documents) then have cells A2 to A12 ( Document Issues) in worksheet 1
appear in cell E6 in Worksheet 2.
Also I will have multiple cell references from worksheet 1 to worksheet 2
following this simular format into cell D & E6. Then it needs to put this
information into individual rows on worksheet 2.
ie- choose data for D6 then E6 and goto the next row for adding additional

Thanks in advance for your help.

How do I reference data from one worksheet to another worksheet cell with a
combo box and then have the data relating to this appear in the nesxt cell in
a combo box.

ie.- Workssheet 2, cell D6 need to reference worksheet 1 cells C2 & C3
(Documents) then have cells A2 to A12 ( Document Issues) in worksheet 1
appear in cell E6 in Worksheet 2.
Also I will have multiple cell references from worksheet 1 to worksheet 2
following this simular format into cell D & E6. Then it needs to put this
information into individual rows on worksheet 2.
ie- choose data for D6 then E6 and goto the next row for adding additional

Thanks in advance for your help.

Does someone know how you can do a mail merge with data from excel to a word document in which the word document contains a chart that is unique to each record? Once the mail merge is completed I should have a one page doc for each record that contains a chart that is unique to that particular records data.

Many thanks!

How do I display data from rows using SpinButton in a form?

I have a form to add data to a sheet and I am looking for some way to add a Spin Button to "go back" or go to first/last record so I can edit them.

Private Sub CloseForm_Click()
  Unload Me
End Sub


Private Sub Enter_Click()
Dim iRow As Long
Dim ws As Worksheet
Set ws = Worksheets("RawData")

'find first empty row in database
iRow = ws.Cells(Rows.Count, 1) _
  .End(xlUp).Offset(1, 0).Row

'copy the data to the database
ws.Cells(iRow, 1).Value = Me.PlaFirstName
ws.Cells(iRow, 2).Value = Me.PlaLastName
ws.Cells(iRow, 3).Value = Me.PlaDOB
ws.Cells(iRow, 4).Value = Me.PlaSchool
ws.Cells(iRow, 5).Value = Me.PlaLastYrTeam
ws.Cells(iRow, 6).Value = Me.PlaJersSize
ws.Cells(iRow, 7).Value = Me.PlaPantSize
ws.Cells(iRow, 8).Value = Me.PlaBats
ws.Cells(iRow, 9).Value = Me.PlaPitch
ws.Cells(iRow, 10).Value = Me.PlaPos
ws.Cells(iRow, 11).Value = Me.PlaNewDraft1
ws.Cells(iRow, 11).Value = Me.PlaNewDraft2
ws.Cells(iRow, 12).Value = Me.ParentInfo1FirstName
ws.Cells(iRow, 13).Value = Me.ParentInfo1LastName
ws.Cells(iRow, 14).Value = Me.ParentInfo1Relationship
ws.Cells(iRow, 15).Value = Me.ParentInfo1Street
ws.Cells(iRow, 16).Value = Me.ParentInfo1Apt
ws.Cells(iRow, 17).Value = Me.ParentInfo1City
ws.Cells(iRow, 18).Value = Me.Parent1State
ws.Cells(iRow, 19).Value = Me.ParentInfo1Zip
ws.Cells(iRow, 20).Value = Me.ParentInfo1HomePhone
ws.Cells(iRow, 21).Value = Me.ParentInfo1MobilePhone
ws.Cells(iRow, 22).Value = Me.ParentInfo1Email
ws.Cells(iRow, 23).Value = Me.ParentInfo1CoachYes
ws.Cells(iRow, 23).Value = Me.ParentInfo1CoachNo
ws.Cells(iRow, 24).Value = Me.ParentInfo1StandYes
ws.Cells(iRow, 24).Value = Me.ParentInfo1StandNo
ws.Cells(iRow, 25).Value = Me.ParentInfo1Notes
ws.Cells(iRow, 26).Value = Me.ParentInfo2FirstName
ws.Cells(iRow, 27).Value = Me.ParentInfo2LastName
ws.Cells(iRow, 28).Value = Me.ParentInfo2Relationship
ws.Cells(iRow, 29).Value = Me.ParentInfo2Street
ws.Cells(iRow, 30).Value = Me.ParentInfo2Apt
ws.Cells(iRow, 31).Value = Me.ParentInfo2City
ws.Cells(iRow, 32).Value = Me.ParentInfo2State
ws.Cells(iRow, 33).Value = Me.ParentInfo2Zip
ws.Cells(iRow, 34).Value = Me.ParentInfo2HomePhone
ws.Cells(iRow, 35).Value = Me.ParentInfo2MobilePhone
ws.Cells(iRow, 36).Value = Me.ParentInfo2Email
ws.Cells(iRow, 37).Value = Me.ParentInfo2CoachYes
ws.Cells(iRow, 37).Value = Me.ParentInfo2CoachNo
ws.Cells(iRow, 38).Value = Me.ParentInfo2StandYes
ws.Cells(iRow, 38).Value = Me.ParentInfo2StandNo
ws.Cells(iRow, 39).Value = Me.ParentInfo2Notes

'clear the data
Me.PlaFirstName.Value = ""
Me.PlaLastName.Value = ""
Me.PlaDOB.Value = ""
Me.PlaSchool.Value = ""
Me.PlaLastYrTeam.Value = ""
Me.PlaJersSize.Value = ""
Me.PlaPantSize.Value = ""
Me.PlaBats.Value = ""
Me.PlaPitch.Value = ""
Me.PlaPos.Value = ""
Me.PlaNewDraft1.Value = ""
Me.PlaNewDraft2.Value = ""
Me.ParentInfo1FirstName.Value = ""
Me.ParentInfo1LastName.Value = ""
Me.ParentInfo1Relationship.Value = ""
Me.ParentInfo1Street.Value = ""
Me.ParentInfo1Apt.Value = ""
Me.ParentInfo1City.Value = ""
Me.Parent1State.Value = ""
Me.ParentInfo1Zip.Value = ""
Me.ParentInfo1HomePhone.Value = ""
Me.ParentInfo1MobilePhone.Value = ""
Me.ParentInfo1Email.Value = ""
Me.ParentInfo1CoachYes.Value = ""
Me.ParentInfo1CoachNo.Value = ""
Me.ParentInfo1StandYes.Value = ""
Me.ParentInfo1StandNo.Value = ""
Me.ParentInfo1Notes.Value = ""
Me.ParentInfo2FirstName.Value = ""
Me.ParentInfo2LastName.Value = ""
Me.ParentInfo2Relationship.Value = ""
Me.ParentInfo2Street.Value = ""
Me.ParentInfo2Apt.Value = ""
Me.ParentInfo2City.Value = ""
Me.ParentInfo2State.Value = ""
Me.ParentInfo2Zip.Value = ""
Me.ParentInfo2HomePhone.Value = ""
Me.ParentInfo2MobilePhone.Value = ""
Me.ParentInfo2Email.Value = ""
Me.ParentInfo2CoachYes.Value = ""
Me.ParentInfo2CoachNo.Value = ""
Me.ParentInfo2StandYes.Value = ""
Me.ParentInfo2StandNo.Value = ""
Me.ParentInfo2Notes.Value = ""

Me.PlaFirstName.SetFocus

'clear the data
End Sub



Private Sub SpinButton1_Change()

End Sub

Private Sub UserForm_Click()

End Sub
Private Sub UserForm_Initialize()
PlaJersSize.AddItem "Youth Small"
PlaJersSize.AddItem "Youth Med"
PlaJersSize.AddItem "Youth Large"
PlaJersSize.AddItem "Youth XL"
PlaJersSize.AddItem "Adult Small"
PlaJersSize.AddItem "Adult Med"
PlaJersSize.AddItem "Adult Large"
PlaJersSize.AddItem "Adult XL"
PlaPantSize.AddItem "Youth Small"
PlaPantSize.AddItem "Youth Med"
PlaPantSize.AddItem "Youth Large"
PlaPantSize.AddItem "Youth XL"
PlaPantSize.AddItem "Adult Small"
PlaPantSize.AddItem "Adult Med"
PlaPantSize.AddItem "Adult Large"
PlaPantSize.AddItem "Adult XL"
PlaPantSize.AddItem "Youth Small"
PlaBats.AddItem "Right"
PlaBats.AddItem "Left"
PlaBats.AddItem "Both"
PlaPitch.AddItem "Right"
PlaPitch.AddItem "Left"
PlaPitch.AddItem "Both"
    PlaPos.AddItem "Catcher"
    PlaPos.AddItem "Pitcher"
    PlaPos.AddItem "First Base"
    PlaPos.AddItem "Second Base"
    PlaPos.AddItem "Third Base"
    PlaPos.AddItem "Short Stop"
    PlaPos.AddItem "Left Field"
    PlaPos.AddItem "Center Field"
    PlaPos.AddItem "Right Field"
End Sub
Private Sub Form_Load()
UserForm.Image1 = App.Path & "cll.png"
End Sub
Private Sub UserForm_QueryClose(Cancel As Integer, _
  CloseMode As Integer)
  If CloseMode = vbFormControlMenu Then
    Cancel = True
    MsgBox "Please use the button!"
  End If
End Sub

If there is another way besides the spin button I can use that too.

Thanks,
Mark

how do I remove data from cells ex. (232)-555-1212 to 2325551212

I have two sheets in my workbook: sheet 1 with 22000+ rows of data in 7 columns (column A is identifier and B through G is data), sheet 2 with 80 entries that occur somewhere in sheet 1 and I need the data extracted for. How do I extract data from sheet 1 for the list in sheet 2?

how do i generate invoice from excel datafile?
--
jm

how do i clear data in excel and not lose the formula

I have an excel workbook containing many sheets, of which I wish to export
the data residing on one worksheet only. I would like to know how to do 2
things.
1) export the data into an email so that it appears as flat text, not an
embedded picture, so that I am able to have a robot scrape the data to go
into an HTML ODBC. There will be approx 6 columns by 60 lines and the
workbook has many macros embedded in it.
2) export the data directly into an HTML ODBC
I am not a developer, but asking the questions for one, so appreciate layman
terms if possible, but happy to accept any and all help.
Thanks

I have an excel workbook containing many sheets, of which I wish to export
the data residing on one worksheet only. I would like to know how to do 2
things.
1) export the data into an email so that it appears as flat text, not an
embedded picture, so that I am able to have a robot scrape the data to go
into an HTML ODBC. There will be approx 6 columns by 60 lines and the
workbook has many macros embedded in it.
2) export the data directly into an HTML ODBC
I am not a developer, but asking the questions for one, so appreciate layman
terms if possible, but happy to accept any and all help.
Thanks

How do I merge data from an excel worksheet into an excel template? I have a
large data worksheet I would like to merge into a template. I know how to do
this in Word but have not been able to find enough help to accomplish the
merge form Excel worksheet to Excel templates. Thanks in advance for any help.

Hi,

I have some data in excel in a table of 5 columns. I want to copy the 3 last columns and paste these into powerpoint. I can do that manually, but the problem is the data is longer than i can display in one powerpoint slide, its likely to span dozens. I dont want to have to manually paste a group of rows at a time for each slide.

I think what i need is a way to copy and paste, and for Powerpoint to work out how many slides it needs and span the table across multiple slides. There may be other solutions which would work too.
Any help is greatly appreciated.

Regards
Joel

I am trying to import data from RightFax into Excel. Any ideas?

Thank-you!

Need help.

I am a student from a business school. We have a project of making a online questionair and enterpreneurs will fill in later.
We use Excel to make it. Therefore we created some simple macros. Now we need a function which I do not know how to write.
When this online questionair is filled in, and submit, then the result will come out. This result needs to be send back to our sponsers and the enterpreneur himself by emails. I wonder how to copy it into a word and then send automatically.
In this sheet, we have a graph with contents below, and the range is A1:A100

Since enterpreneurs will open it from their computers, I am not sure they use outlook or outlookexpress, may I send it flexiblly with no restriction of outlook or outlookexpress?

Some of our enterpreneurs have very little knowledge about computer.

Great thanks in advance for any help.

I have created a spreadsheet that has columns that automatically totals test
scores. I have noticed that on more that one occasion I accidentally entered
an amount in the totals column which screwed up my calculation. How do I
prevent myself from accidentally entering data in a totals column?

I have data in excel, now I need to use SPSS to analyse the data. How can I
export the data from excel to SPSS?


No luck finding an answer? You could always try Google.