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

Free Microsoft Excel 2013 Quick Reference

Fill in field

Is there a "fill-in" field command similiar to what is in MS Word?

I would like to create an Excel template that promts for fill ins when I open the template.

Thanks


Post your answer or comment

comments powered by Disqus
I have a 90 page financial report from MS word that I get each month.
I would like to find a software package or scripting tool that will
allow me to automate the process of grabbing #s from the ms word file
and filling in fields in an excel file. I have a feel that there may
be quite of programming involved in doing this. But perhaps there are
some more efficient solutions out there. I would appreciate any
advice. Thanks

I want to fill in a cell based on a information in another cell. For example:

If cell D1 hade the word box in it i want to fill in cell e1 to say $50 so every time the word box shows up in colum D i want it to fill in colum E to say $50

Hi
I'd like to send eg an e-mail with a link to this excel file with a form. it would open up with a pre-set value in a field that woul be related to this link.

eg: i send a link and it opens the file and fills in field "a" with value "123".
then afterwards i send another link and it opens the same file but then field "a" is field in with value "456".

Ok so here is my problem

I want to be able to enter a number (3 digit cost code) in a cell and i want the next cell to the right of it, to automatically fill in the description of that number.

I have a database in access with the cost codes and the descriptions.

Any help??

Hi,

I am trying to convert an excel spreadsheet to pdf but would need to have around 4 field which should become fill-in fields when converted to PDF, meaning that the enduser would be able enter some text into these fields and then save the PDF.

Any clues how I best go about this? I dont want to go for the 500 USD adobe acrobat solution if possible. Office 2007 at work here, but should be operated in an 2003 environment.

Any suggestions are welcome!
A2k

Is there a way to have a pivot table fill in all the blanks when you have multiple row fields? In the example below is there any way to have 217 fill in every row to the bottom and the same for each division?

Count of TerritoryRegionDivisionTerritoryTotal2172102481330136617181953121525212551328174013893581364173619521967139216513131757194816237321754194919691Grand Total22

Is it possible in Excel to restrict the user to fill out all the desired
fields before it can be sent via email. Example. A client needs to order a
certain product so he/she must now fill in his/her details. The particular
cell has an asteriks stating that this cell/field is a requirement before the
document can be sent.

What is the process to lock this particular cell so that the document is
unable to be sent unless this cell is filled in.

I hope I have made sense.

Is it possible to have required fill-in cells in a preformatted form? Say,
the completer cannot leave the field or save the file unless the required
fields are completed?

Thanks in advance for any help you can give me on this one.

How do I avoid fields being automatically filled in by default? For example,
the formula for C1 is:

=SUM(A1-B1)

If nothing is yet entered in A1 or B1, then C1 is given the value "0"
I would like it to remain blank as a default.

Thanks again for your help

Jason

I have an Excel file of about 3000 names, addresses, zip codes, etc. This
is used for a mailer database for addressing. Most of the records have a
first and/or last name field completed. However...as the xls file is
updated...there are occasionally records with no FirstName or LastName
available....only the street address...etc.

Is there a way that I can automatically have Excel fill in a text string if
and when my xls file contains records without a first name and last name.

In other words...if both the FirstName field and the LastName field are
empty in a record (row)...can I have Excel automatically enter a text string
(say "Current Resident") into the blank FirstName field...and how do I go
about this ?

Thanks in advance...

Tim R

I have an Excel file of about 3000 names, addresses, zip codes, etc. This
is used for a mailer database for addressing. Most of the records have a
first and/or last name field completed. However...as the xls file is
updated...there are occasionally records with no FirstName or LastName
available....only the street address...etc.

Is there a way that I can automatically have Excel fill in a text string if
and when my xls file contains records without a first name and last name.

In other words...if both the FirstName field and the LastName field are
empty in a record (row)...can I have Excel automatically enter a text string
(say "Current Resident") into the blank FirstName field...and how do I go
about this ?

Thanks in advance...

Tim R

Dear Experts,

When I start all fields are white (no fill) I want that if I enter an “Y” (for Yes) the field automatically colours into Yellow.

If I enter a N I want that the field automatically colours red.

I also want that if I enter a date it must be on or before the 7th of the month that field also need to change to Yellow.

If the date is after the 7th of the month the field need to be red.

When all fields are Yellow I want the total line to colour Green. Is that possible? Or should I put in a Yes in field O to get the whole line green?

Please see attached attachment for more clearity

How do I avoid fields being automatically filled in by default? For example,
the formula for C1 is:

=SUM(A1-B1)

If nothing is yet entered in A1 or B1, then C1 is given the value "0"
I would like it to remain blank as a default.

Thanks again for your help

Jason

Hi Guys,

I'm a little unsure if I can do this in Excel (and have had a hard time figuring out what to type in Google for advice), but the idea is this:

I'm trying to build some real world product. The product has several sets of instructions that vary depending on the components used to build that particular configuration of product. What I'd like to do is have several drop-down lists that are the different options of components and after selecting some variation, the document will tell me which instructions I need to use, essentially filling in another field with relevant information. Is this a possibility in Excel or do I need to look toward another program entirely? Thanks in advance for any advice/suggestions!

Hello!

I am creating a database to record patient enrolment in a program. I have modified a macro for turning the form input into a database. A mockup of the document is attached.

Two of the fields in the form are linked: Region and Rep_name. I would like to modify the macro so that when I enter the Region, the Rep_name is automatically filled in. Right now I have the two fields as drop down lists, but I'm worried about making sure that the correct rep and region are always picked together.

Here is the code that I am using right now . . . Can anyone help me modify it to incorporate the Rep/Region connection? Any help is much appreciated. Thanks!

'---------------------------------------------------------------------------------------
' Module    : Module1
' DateTime  : 13/08/2006 09:36
' Author    : Roy Cox (royUK)
' Website   : www.excel-it.com] more examples
' Purpose   : enter data from one sheet to a second sheet
' Disclaimer; This code is offered as is with no guarantees. You may use it in your
'             projects but please leave this header intact.
'---------------------------------------------------------------------------------------

Option Explicit
Dim wsData     As Worksheet
Dim wsForm     As Worksheet
Dim rNextCl    As Range
Sub Save_Data()

    'Set variables
    Set wsData = Sheet2
    Set wsForm = Sheet1
    'find the next empty row for data input
    Set rNextCl = wsData.Cells(65536, 1).End(xlUp).Offset(1, 0)

    'enter the data using Offset to find next Column
    'note use With....End With to let Excel that the following lines are working with rNextCl
    'also reduces typing!!

    With rNextCl
        .Value = wsForm.Cells(2, 2).Value
        .Offset(0, 1).Value = wsForm.Cells(3, 2).Value
        .Offset(0, 2).Value = wsForm.Cells(4, 2).Value
        .Offset(0, 3).Value = wsForm.Cells(5, 2).Value
        .Offset(0, 4).Value = wsForm.Cells(6, 2).Value
        .Offset(0, 5).Value = wsForm.Cells(7, 2).Value
        .Offset(0, 6).Value = wsForm.Cells(8, 2).Value
        .Offset(0, 7).Value = wsForm.Cells(9, 2).Value
        .Offset(0, 8).Value = wsForm.Cells(10, 2).Value
        .Offset(0, 9).Value = wsForm.Cells(11, 2).Value
        .Offset(0, 10).Value = wsForm.Cells(12, 2).Value
        .Offset(0, 11).Value = wsForm.Cells(13, 2).Value
        .Offset(0, 12).Value = wsForm.Cells(14, 2).Value
        .Offset(0, 13).Value = wsForm.Cells(15, 2).Value
        .Offset(0, 14).Value = wsForm.Cells(16, 2).Value
        .Offset(0, 15).Value = wsForm.Cells(17, 2).Value
        .Offset(0, 16).Value = wsForm.Cells(18, 2).Value
        .Offset(0, 17).Value = wsForm.Cells(19, 2).Value
        .Offset(0, 18).Value = wsForm.Cells(20, 2).Value
        .Offset(0, 19).Value = wsForm.Cells(21, 2).Value
        .Offset(0, 20).Value = wsForm.Cells(22, 2).Value
    End With

    'confirm data transferred
    MsgBox "Data transferred successfully" & vbCrLf & "", vbInformation, "Data
transfer"

    'clear input cells, note use of Named Range
    wsForm.Range("DataInput").ClearContents

    'clear variables
    Set wsData = Nothing
    Set wsForm = Nothing
    Set rNextCl = Nothing

End Sub


The problem I am trying to solve is building a userform where the user will enter 8 stock tickers, then i want the form to use a web query and pull specific information from finance.yahoo.com and fill in on the wksh for all 8 stocks. I have built the userform, but do not know how to code for the automatic query and filling in of the data.

Attached you can find the wksh, any code assistance would be greatly appreciated. If something is unclear please let me know. The fields I am desiring are found on the wksh.

I have a form where I fill in values. These values are working hours and can vary between 0 and 16 hours. I use an interval of a half hour. I developed this on my laptop where the decimal separator is a point.

My colleague is using other regional settings. He has the comma for a decimal separator.

Normally I build this so that I calculate the values to be inserted in the combo box when starting up the form. So, normally the fields are always filled in correctly according to the users own regional settings.

But I experience a problem. Even when I fill in a value of 8,5 in the combo box, when I drop down the list, I see 8.5

Anybody got an idea how to fix this ? Have I set up a property wrong of the combo box ?

I have a user form i created to be a front for a excel document and can't figure out how to fill in the user form with corresponding data based on filling out one of the fields. i have included a screen shot of the user form.

What i am trying to do:
1. find a row of information in excel sheet based off one of the text box's value.
2. fill in the rest of the box's with information from the same row

Example:
If I put in the user ID I want it to find said user ID in the form and fill in the other box's on the form.Find Userform.jpg

Currently using excel 2002.

Is there any way to make a button you could push that would fill in a printable form letter? I have a customer returns database. I would like to be able to click on a button and have it take relevant information and put it into a letter.

For example:

lets say i have fields like Customer, contact number , address, part number. could excel take that information and feed it into blanks of a pre made letter. kinda like mad libs?

here is what the letter could kind of look like

Dear CUSTOMER,

ADDRESS
PHONE NUMBER

This is to inform you that your PART NUMBER is currently 30 days overdue. Please check your stock and ship PART NUMBER to us.

I would like to expand this and add several fields, but if i can understand the basic coding, i should be ok.

THANKS!

When I try to "save as" if the mouse hovers over an existing file the save as
field is automatically filled in to the filename the mouse is hovering over.
How do I turn this feature off???? Is it a system feature or Microsoft
feature?

Thank you
Debbie

Hi,

I have a spreadsheet of information on patient data from the hospital I work
in. There are over 20,000 records in this sheet. I have not generated the
data but been given the file to work on. In each record (row) is a PatientID
followed by three procedural codes on the next three columns for procedures
A, B and C. My problem is that some patients have more that one procedure of
type A or B or indeed C resulting in potentially one patient have say three
or four rows of data. Trouble is each new row for the same patient doesn't
have the PatientID field filled in. To save the extremely time consuming
process of manually copying the PatientID into the empty cells below it
(until the next new PatientID appears) I wondered if anyone knows of a way to
automate this. This would really help as I will from time to time get update
files that need tobe handled in the same way. Maybe a VBA procedure or macro??

Thanks in advance for any help.

having trouble filling in a spreadsheet sent to me by email.

I have an expenses spreadsheet with two tabs (car-related and other). Each
sheet requires the user to fill in their name, payroll number, and date.
Everything else is calculated for the user.
Would it be possible to have a dialog box open when the template is opened
(similar to what Word can do), whereby a user can complete these fields only
once and the dats is entered on both sheets.
TIA
Amanda

I am creating an application form to be used electronically. I want to make
sure that users fill in certain fields (cells). How can I make Excel tell the
user that when they click on 'close', they can not close or save the file
until all fields are populated? This is driving me mad!!!!


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