I'm trying to make a column to use as a filter for mail merging. The filter is based on a result entered into one column which is compared with a range of values in an adjacent column. I managed to get the nested IF formula to work but only when entered into a blank spread sheet or if I correct the error as prompted. I've attached an example of the spreadsheet.
View 2 RepliesI am trying to mailmerge a spreadsheet relating to invoices. there are multiple rows for each company, however each row is a unique Invoice Number.
Instead of email mail merging normally, I want just one mail merge made for each company, where it lists the invoices there, rather than a whole new document per row. Otherwise I'd send one company 50 emails!
I have attached an example spreadhseet - and I have attached a screenshot of the word document Im working on.
Dont ask me where I got that code at the top of the word document - ive copied and pasted from somewhere - it might as well be written in italian. Im trying to match the mergefields with what I think it's trying to denote. Yet, I cant make an If then else mergefield?
Is it possible to do this sort of mail merge, then use the email column to designate where to send the finished merged product?
Attachment 326799
Attachment 326800
I have 2 date values in excel spreadsheet ( i must use it by the sheet) and i want to flter table by the date column and AutoFilter, when the start date and the end date will be taken from the sheet itself.
but when i defined date variable like starta and edit the filter (Criteria1:=">=starta") it didt work (the value was starta and not the date in the starta) how to edit it?
sub abcd
Dim starta As Date, enda As Date
starta = Worksheets("periods and options").Range("a1").Value
enda = Worksheets("periods and options").Range("b1").Value
Sheets("DATAF").Range("a1:p1325").Select
Selection.AutoFilter Field:=1, Criteria1:=">=starta", Operator:=xlAnd _
, Criteria2:="
I am looking for a way to make the data mail merge friendly for our clerical staff! The intention is to be able to create a letter to the parents listing the dates absent and unexplained.
There are currently 7 columns ; ID, Surname, First Name, Current Level, Current Form, Absence Date, Absence Code.
I have downloaded and implemented ASAP Utilities and the Transpose funcion is really useful - however it works in predetermined steps - 1, 2, 3, 4 etc rows of data are transposed, depending upon the number you select. Unfortunately there is no such pattern - each student thas a different number of unexplained absences. Some have 1 while others may have 20.
I currently have a list in one column which is in the following format: "First Name, Last Name <user@domain.com>". Is it possible to filter out just the e-mail address?
View 2 Replies View RelatedUsing EXcel 2013, Windows 8
I have an Excel worksheet with one column being e-mail addresses. Other columns are Christian names, etc
Ideally can I create a full Mail merge with Outlook using whatever data I want. But probably just e-mail address and Christian name?
Otherwise be able to send one e-mail to all the e-mail addresses, without a major re-type.
I have some text in a cell, which is longer than the width that I am going to make that cell. When I don't wrap the text, it cuts it off at the end of the cell.
Since each column represents a day in a calendar, it would be incorrect to merge the two cells, but I don't want the text hidden, since I need to print the final product.
It is non-numeric text, and i've pasted --> values to remove formula issues.
We need to send multiple mail with attachment with outlook 2007 with option "Resend this message", now we want to use excel for sending the mail.
procedure.----------------------------------------------------------------------------------------------------
S.No. To cc----------------------------------------------------------------------------------------------------
1. xyz@ymail.com----------------------------------------------------------------------------------------------------
2. abc@gmail.com hursh@rediffmail.com, hursh@rediffmail.com, hursh@rediffmail.com, raj@hotmail.com----------------------------------------------------------------------------------------------------
3. ram@ymail.com ramesh@gmail.com---------------------------------------------------------------------------------------------------- 4. rajesh@ymail.com----------------------------------------------------------------------------------------------------
5. raghu@ymail.com raju@hotmail.com ---------------------------------------------------------------------------------------------------- 6. info@ymail.com----------------------------------------------------------------------------------------------------
7. ranjit@excel.com xyx@gmail.com----------------------------------------------------------------------------------------------------and
we have two files for attaching on desktop, one is a excel file and second is a zip file. we want to send the mail with excel mail merge.
Is there any way witch i can use to make the auto-filter range bigger than 1000 cells?
View 2 Replies View RelatedI have a workbook that has multiple worksheets and I would like to use a command button to e-mail just one selected sheet. I want to create the single sheet as an attachment on a new e-mail message but leave the addressing to the user as it will vary, and not save the single sheet. My challenge is that the users have a variety of different e-mail clients (Outlook, Lotus Notes and others).
View 2 Replies View Relatedi'm trying to automatically create hyperlinks in some cells from mail addresses located in another column. this is what came out:
View 2 Replies View RelatedI'm looking for a way to put data into 1 column from 2 different columns, alternating every other row.
The data looks like this:
A B C
1 2
3 4
5 6
And I want C to look like this:
C
1
2
3
4
5
6
I don't necessarily need to keep the data in columns A and B, as long as C follows this format.
Excellent, just what I was looking for. I couldn't get the UDF working right, I'll try messing around with it, but the Index solution works great!
What would be the formula to merge serveral rows of one column to one cell and separate by a ":"
View 7 Replies View RelatedI am have data in as shown below where there a number and few blank cell. I would to write a macro that loops through the column and merge blank cell with cell nonblank cell above.
20085
blank
blank
20086
blank
blank
blank
blank
blank
20087
blank
20088
blank
blank
20089
i have received a file with thosands of rows of customers in it and their are two surname columns, i need to merge these two columns data together into one column.
View 9 Replies View RelatedI have a very large spreadsheet, 25 columns and over 16000 rows. I want to merge all of the values into a single column. One caveat, not every cell has data in it, as shown below:
C1 C2 C3 C4....C25
2
I am trying to write a macro to send mail on every Friday and also on last day of every month. If the last day of the month falls on Saturday or Sunday then the macro should mail on Friday. I have written a separate macro to send a mail. I have also written to check day(ie Monday, Tuesday etc) of today. If today is Friday or month end i can send mail. I dont know how to tell the macro to send mail on friday if the month last date is saturday or sunday.
Sub done()
Dim Dat As Date, x As Integer, y As Date, sorry As String
Dim str As String
sorry = "Today is not friday or month end. So i cannot send mails"
str = WeekdayName(Weekday(Now()))
[Code] ........
In Sheet 1, I have a list starting in row L1.
Col L
John Doe
New York
Past Locations
Previous Jobs
Male
Previous Schools
In Sheet 2, I have another list where the user will manually enter sub elements for some of the elements of Sheet1. It looks like this...
Column A |Column B |Column C
Past Locations|Previous Jobs|Previous Schools
Below that last row of headers, the user will make inputs. the list for each column should be able to run down to say 100. The inputs may look like this....
AZ |Plumber |XYZ Elementary
MD |Waiter |ABC High School
IL
CA
Now, the problem is I need to combine these two into a single column in Sheet 3 in a special way. The output would look like this.
John Doe
New York
Past Locations
AZ
MD
[Code] .....
Notice that I am taking the list in Sheet 1 as is, until i run into a value that is the header in Sheet 2, in which case I take all the contents of that header column until I am done, and then go back to sheet one, and repeat the process. I need the output in one column in Sheet 3; i don't need any special formatting.
sample merging file.xlsx
I have a data array of 7 col and 256 rows. I want to focus only on the first 2 columns though. Here is what is going on. In the first column I have numbers from 1-256, these numbers are merged to the appropriate size to accommodate the data in column 2. However, the data in column 2 is not merged, it consists of 1,2, or 3 lines of text. Excel deletes the text in the rows below 1 if I try to merge, excel does not allow multiple row merge selections. What I am looking for is a formula that looks at column 1, finds how many rows are being merged in column 1, then looks at column 2 and identifies the number of rows needed for merging and displays that text in only one row. Basically, it's a formula that merges multiple rows of text in col 2 depending on the number of merged rows in col 1.
No.Customer/Operator
1Fairbanks Morse /
Beloit, WI
2H+H Umwelttechnik /
[Code]....
I've got a table of different values in column A.
I'd like the cell D2 ("order") to show up at column B next to the closest value of 35.00 of column A.
Consequently, how to make "order" meet the closest several value of 35.00?
I've attached a xlxs file with more detailed description.
Ex_closest_11_05.xlsx
Formula for this? If a cell in column T is empty, use column U (but make it negative)??
View 2 Replies View RelatedIs there a way to filter column A but ensure it includes multiple lines of data in a different column.
I have attached an example of what I am looking for:
I need to filter by community but keep all the information listed in columns, B, C, & D.
So when I filter to Thunder Bay I would still see the 5 members listed in column D.
I realize the easy solution is to fill all the empty cells in column A to pick up the data in the other columns, but I do not want to Fill all the empty cells to include the name "Thunder Bay" (not the look I want for this spreadsheet).
how can I make a column mandatory?
basically if someone puts data in column C, they have to put data in column D
(people are not putting important information on my spreadsheet, so i would like to make that column mandatory)
I need to write a macro that will create a new sheet called "Export Format" and it's A Column needs to be exactly the same as the A Column in another sheet called "Master". I'v been trying to look it up since I have never used VB before, but my boss needs this done soon so i thought I'd ask. This is just a small part of what i need to do but I think it will give me the start I need.
View 2 Replies View RelatedIs there a way to make the bar on a vertical column bar graph increase in height gradually over a couple of seconds rather than jumping from one height to the next height instantly.
eg:
if a vertical bar graph is reading data from cell b5, and b5 currently reads as 46, if b5 then changes to (let's say) 58, I'd like the column bar graph not to instantly change from a height reflecting the 46 to a height reflecting 58, but to slowly rise, showing the transition from 46 to 58.
can Excel make a Ratio of the results of one column against another ?
eg, Col A 2.00
Col B 1.00
in Col C, the ratio result is 2 : 1
I have the text value "Ball, Red" somewhere in column A. I don't know which row it's in because it will never be in the same row twice. I need a macro to find this value, then, copy that whole row and "insert copied cells" right below that row and change the value in the newly created cell from "Ball, Red" to "Red, Ball".
I tried macro recorder to do this and had no luck...
Cells.Find(what:="Ball, Red", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.Copy
Range("A21").Select
Selection.Insert Shift:=xlDown
Range(Selection, Selection.End(xlToLeft)).Select
Range(Selection, Selection.End(xlToLeft)).Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "Red, Ball"
Range("A22").Select
That's is all there is to it on this one.
I'd like to create a go back field/button/something that would allow a user (who is on a row, in a column very far right) to click to go straight to column A for that selected row.
View 2 Replies View Relatedin my spreadsheet (attached), i want it so that when someone clicks a button, it will fill in the next available cell in column A. For example, when I click on the "Create" button on the green NIPRNet side, then it'll fill in the next available cell in column A (cell A4) with "(N) Created Account". Then, if I click on "Unlock" on the red SIPRNet Side, then it will fill in cell A5 with "(S) Unlocked Account". and so on, and so on, down column A.
At the moment, i have it so that all the cells in column A are dropdown menus. But I want to eliminate the drop-down menus and use buttons instead.
How do I make a column array variable within a function? I've done nested vlookups to get a column number, but the function I'm using doesn't use a "number", it uses a column aray. '=AVERAGEIFS(L:L,K:K,">="&B$2,K:K,"<="&B$3). The "L:L" needs to be moved according to Market, (or column choosen).
View 2 Replies View Related