Using Excel To Generate A Letter?
Apr 16, 2013
I'm using creating a spreadsheet where data inserted into Sheet 1, is used to fill the blanks in a letter in Sheet 2. The formatting is all fine and I've managed to get it working with the data coming through to the correct place.
However there is the issue that parts of the letter are not always applicable to all people. Is there a way I can create a formula that say hides a paragraph of the letter (or a row/cell to be more precise) if a certain value is 'true'? Would need to be done in a way that allows cells beneath the hidden ones to move upwards so there are no large gaps when printing the letter.
View 2 Replies
ADVERTISEMENT
Mar 31, 2014
As you can see I have only one attached file which has a two sheet tab, one is the "DATALIST" and the other is "FORM" in which this tab will be the one to be generated with blank highlighted yellow, and get data from datalist tab.....
View 4 Replies
View Related
Jun 18, 2014
I am looking for Excel to auto generate an email (to myself) when the following happens:
Basically, I have products with promotions which each have a start and end date. I have an excel sheet which we manually enter the promotions start and end dates into. I have a seperate column which has a basic formula to indicate the days remaining until the promotion comes to an end.
I would like excel to automatically send me an email to notify me when the promotion is due to end one week in advance.
So I will have a column which effectively shows the days remaining (number) until the promotion ends, when this number hits 7, I would like the email to be sent to myself stating (Model number XYZ. Promo ending soon).
View 1 Replies
View Related
Jul 30, 2014
How to generate barcode labels in excel? I would like to have them ready for use (without "demo" or any similar text on them).
View 2 Replies
View Related
Dec 10, 2012
In Excel 2010, I can manually enter the GetPivotData function (and it works), but with Generate GetPivotData selected / enabled (in PivotTable Tools --> Options --> PivotTable --> Options), the GetPivotData function isn't automatically generated.
View 1 Replies
View Related
Feb 19, 2013
I need to generate conditional formatting in Excel 2010.
For the planned date of material submittable should turn yellow before 10 days ago & planned date of material submittable should turn Red when overdue.
View 1 Replies
View Related
Mar 10, 2014
I have a spreadsheet that contains an email address (Each row will most likley have the same email address but there are occasions when it could be different). Ideally I want a button that when clicked will open up an email, popoulate it with the persons email (that is in a specific column and row), add a subject and some text to the main body of the email and then attach the spreadhseet itself.
View 4 Replies
View Related
Mar 11, 2012
I have a sheet with 500 rows and 20 columns. I want to put an input box and a button on a different sheet. What I would like to happen is that when you put the criteria in the input box and click the button it opens the form for the row corresponding to the criteria and allows you to edit the 20 columns. Excel 2007.
View 6 Replies
View Related
Nov 5, 2012
I've 3 series that are
1- From 0-9
2- From 0-3, and
3- From 0-27
I want to generate possible combination of these 3 series in Excel 2007.
I think total combinations would be (10*4*28=1,120)
View 1 Replies
View Related
Sep 16, 2013
We have an Office issues spreadsheet where our staff post questions/issues they have. These items are then allocated to a member of staff to look into and resolve. Each issue is entered on a seperate row on the spreadsheet, with the issue in column C, the allocated persons initials in column H, their e-mail address in column I (pulled in from a look-up table based on their initials), and the response required date in J.
I would like the spreadsheet to automatically send an e-mail when the issue is allocated to a person, or is re-allocated to someone else, ie when the 'allocated to' cell changes.
The e-mail message would only need to inform them that an issue on "column C text" in "filename" has been allocated to them and that a response is required by "column J date". We use Excel and Outlook 2003.
View 1 Replies
View Related
Feb 19, 2014
I am thinking to make a excel file which can generate a headre file for my c++ source file. Previoulsy we used to generate .h files using excel but i dont know the logic behind that(Hope some macros using for that).
MY header file contains this many data and my intention is to give "MYapp Alpha 0.0.3" through excel file because the version number changes for each release. If i used excel file then I can edit that excel and it creates .h file for me, later some more informations i can make configurable through excel file
#define APP_FLASH_APP_ID 0x123
#define APP_VERSION_NUM "MYapp Alpha 0.0.3 "
#define APP_PRODUCT_NAME "TPI "
#define APP_DESCRIPTION_STR APP_PRODUCT_NAME APP_VERSION_NUM
#define APP_RELEASE_DATE_STR "10/11/13"
#define APP_SOFTWARE_PARTNUM_LEN 10
View 3 Replies
View Related
Feb 20, 2014
I am using Excel 2013 on a windows 8 machine. It may be easier for me to explain the problem, before posting about the formulas. I maintain a retirement residence with alot of phone numbers. I have a list of all the numbers we own in one column and the numbers assigned to the PBX systems in a second column. By using a If formula I can tell which numbers have not been assigned (The true statement). My problem is when a resident passes away, I need to reuse that "phone number", but I dont want to reuse the number too soon. I am hoping to use the "true" from the if statement to generate a time stamp. I plan on using that time stamp against the "today()" in a days formula, I believe this will spit out the number of days a number has been idle. The time stamp would be constantly changing or removed as the if statement would always be changing. So column C gives the True statement and says "Number not Assigned" - this should create a time stamp in Column W
A
B
C
[Code].....
View 4 Replies
View Related
Mar 2, 2009
When I type a single lower case letter into a cell, what formula or conditional formatting should I use to always convert it to a capital letter automatically?
View 9 Replies
View Related
Dec 31, 2009
For the below formula is it possible to replace the B's (column location) with a cell Say Z146 which contains the letter B (or a number if thats easier and someone can tell me the numbers for each column).
When the formula is dragged into the next cell (down) it takes its column reference from Z147 and then my life becomes so much easier.
=IF(INDEX('Overs-Unders'!B:B,MATCH($C145,'Overs-Unders'!$A:$A,0))"",INDEX('Overs-Unders'!B:B,MATCH($C145,'Overs-Unders'!$A:$A,0)),"")
View 9 Replies
View Related
Dec 29, 2013
I created an Excel 2010 macro enabled workbook (.xlsm) which calculates the letter grades of test scores between 1 and 100.
To use the workbook:
1. Put the scores in one column of the open worksheet.
2. Select the first score with the mouse (i.e. make this the "active cell").
3.Click on the "Calculate Grades" button on the sheet.
Public Function LGrade(ByVal score As Variant) As String
'Returns the letter grade based on a test score.
On Error GoTo ErrHandler
Select Case score
Case Is > 100: LGrade = "A+"
Case 95 To 100: LGrade = "A"
Case 90 To 94: LGrade = "A-"
Case 87 To 89: LGrade = "B+"
[code].....
View 4 Replies
View Related
Aug 27, 2013
I have a supplier list which i access all the time. To view individual supplier details i use find function using supplier code and then scroll through the sheet to view all the details and it is quite hectic. Is there any way i can modify the sheet so that every time i search for a supplier , only that supplier details can be shown in a different sheet or notification which i can also print if i want.
View 2 Replies
View Related
Jun 26, 2012
I'm trying to set up a system of sorts to track "services"
At the top of my 'new service" page, I need a button, which I then need to have a macro run on.
Sheet 1 is basically where I'd be entering the info, and sheet 2 where it would be stored. The button at the top is called Generate New "service' Number. This then needs to generate a new number on sheet 2 in A2 (then once 2 is populated, generate new in 3, then 4, then 5 etc...
I have a macro on Save Service Button at the bottom, which transposes the data into what would be used as a database to store all the services. That Macro then also needs to only transpose and paste data into the row corresponding with the "service number".
View 2 Replies
View Related
Nov 28, 2012
Listed below are the grades for a student. Some columns have blanks. I have to find the highest grade (A being the highest) in the range.
I'm going up with the opposite (F) with this formula:
=CHAR(MAX(INDEX(CODE(A22:M22&CHAR(1)),0)))
How do I get A?
I'm using Excel 2007
A
B
C
B
D
E
A
A
B
F
View 6 Replies
View Related
Jul 30, 2014
From an Excel 2003 workbook I generate some product labels. Each label has a 5 digit job number and a quantity that are passed to variables. If the quantity is 1, then I have no problems in printing my label. My problem is where the quantity is greater than 1. If a job has more than 1 item (can be up to 40 or 50) I need to add a series of letter (or letters) to the end of the job number.
For example:
Job number 12345
qty 1
number on label 12345
Job number 12346
qty 4
numbers on labels 12346A, 12346B, 12346C, 1234D
so that each printed label has a unique job number
View 3 Replies
View Related
Mar 7, 2014
I need to change a few hundred cells (one column) where the first letter may be a capital letter to a lowercase letter.
So:
GetAwardfromBid to getAwardFromBid
or
SmallLertter to smallLetter
View 3 Replies
View Related
Jul 8, 2013
How can I create a Makro that looks for values (e.g. values > 90) and that then generates a list with: all the values greater than 90, the row names and column names of the values?
I am pretty sure I will need a Makro for this, but how to create it. I am using excel 2010.
I have attached a file to give you an example. The red table is the table with the values. The blue table is what I want to be generated automatically. In the example I did it manually.
Workbook1.xlsx
View 2 Replies
View Related
Mar 6, 2012
I have a workbook that has 30 tabs in it. Each tab is a report card for students. What I'd like to do is create another tab with a button on it that when I hit the button it will search through each tabs range of D12:D40, D48:D76, D84:D112, D120:D136, J12:J40, J48:J76, J84:J112, and J120:J136. And if any of these cells has an MS in them then this new sheet I have created will list each students name which is in cell E5 and list what they recieved the MS for. This will be in the same row number but in column B. So if cell D12 has an MS in it then this report will list the students name and what's in cell B12.
Windows XP
Excel 2003
View 3 Replies
View Related
Oct 25, 2012
I am using the following piece of VBA code in Excel 2007 to automatically generate an email when a button is pushed:
Sub SendEMail()
Dim Email As String, Subj As String
Dim Msg As String, URL As String
Dim r As Integer, x As Double
r = ActiveCell.Row
'Get the email address
Email = Cells(r, 3)
[Code] .....
The button to launch this code sits in cell AK7. What I would like to do is have the macro copy the email address present in cell E7 into the email address section of my created email. In addition I would like the reference provided in cell AJ7 to appear in the Message Subject part of the generated email in the format " RCS Reference contents of cell AJ7".
View 3 Replies
View Related
Aug 23, 2013
I want to generate random times in excel between upper and lower limits , which i can do , but i also want dates in same cells with out randomization , means dates should act independently and time should randomize
it should be something like that
8/1/2013 05:55 AM
8/2/2013 07:55 AM
8/3/2013 04:44 AM
View 4 Replies
View Related
Jan 2, 2014
I would like to generate a blank email with a list of recipients (no more than 40) in the 'To' field. I would like to do this in a single click on a cell with the text 'newsletter group' in it (cell B17). The recipients email addresses are in the format of one complete email address per cell in a column starting at C17 (C17, C18, C19, etc...). I thought I had found a way to do this (using the hyperlink function I think, but can't quite remember)but it turned out you could only string together about 8 email address before the function stopped working.
Also just to be clear, I don't want to send the workbook to the recipients.
View 4 Replies
View Related
Jan 17, 2012
I am looking for macro where it can generate multiple workbooks with a single worksheet data source. I have this worksheet with data which is look like this:
[IMG][/IMG]
This data will be places in 1 workbook for each of line with given file name as page number above those workbooks generated will have same information for each line but at different cell position such as: take this example at line 3
and
Microsoft Excel 2007
Window 7Pro 64bit
This line could be up to 50 lines of data. I try google search but found most about consolidate multiple workbooks to single worksheet. I do have VBA reference that I refer to from [URL] ......
How to put the information from the worksheet into specific position in the workbooks.
View 1 Replies
View Related
Jul 18, 2012
How do I create a 6 digit unique random number for use as an ID in column A. Once created the rows with preexisting 6 digit unique random ID numbers must not change every time new rows are added.
View 9 Replies
View Related
Mar 19, 2013
I need a formula to use on MS Excel 2007 to remove the English letters from a cell A1 and return only the numbers(if any) & Chinese characters to B1.
Please refer to the able below.
Example:
A
B
1
so l首先欢迎大家收听我们的科学与烹饪系列
首先欢迎大家收听我们的科学与烹饪系列
2
讲座的最后一次报告 有点难过这是最后一次了
讲座的最后一次报告 有点难过这是最后一次了
[Code]...
View 7 Replies
View Related
Jan 23, 2014
All I want is to generate a word document with built in word header and footer (header and footer style name is "alphabet") based on the values which i mention in excel(path,word file name and header content.
View 1 Replies
View Related
Jan 4, 2012
Automating Excel from Access, I'm attempting to generate a single sheet workbook and save to a Sharepoint site. This process works fine on my machine (XL2007, XP), but on a coworkers computer (XL2003, XP), the code throws a 1004 error on the save as line. However, the really odd thing is that stepping through the code doesn't throw an error on the coworkers machine.
Here's the sub being ran; the line it errors out on is the first branch in the .saveas block.
Code:
Private Const csSharePointSaveAs = "\sharepoint-us.mycompany.comsitesfinance adminlah blahlah-blahCustomer Publication Tracking.xls"
Private Sub PublishXLtoMOSS()
Dim objXL As Excel.Application 'Object
Dim wb As Excel.workbook 'Object
Dim ws As Excel.Worksheet 'Object
Dim rs As DAO.Recordset
Dim i As Long
'Set objXL = CreateObject("Excel.Application")
[Code] ...........
View 1 Replies
View Related
