letter

Hi Using Office Pro 2010 / Win 10 1803 I need to print a letter, A5 size, so putting x 2 onto A4 landscape, then cutting after printing. Is it possible to do this also using Mail Merge, so that each A5 letter has 'Dear [name]' etc, please? When I have tried before, only one of the two A5...

<tbody> ={IF(ISERROR(INDEX(Wednesday!$A$1:$C$250,SMALL(IF(Wednesday!$A$1:$A$250=$E$3,ROW(Wednesday!$A$1:$A$250)),ROW(Wednesday!1:1))-1,2)),"",INDEX(Wednesday!$A$1:$C$250,SMALL(IF(Wednesday!$A$1:$A$250=$E$3,ROW(Wednesday!$A$1:$A$250)),ROW(Wednesday!1:1))-1,2))} </tbody> This is my code. $E$3...

Hello, I am trying to implement within a macro blow how to identify the position of the first alphabetic letter a string and take all values before that letter. This is a part the macro below: If xsplit Like "*,*" Then For I = 1 to 100 'line below where I want to do that Sheets("x").Cells(I,1) =...

Hi, I know there is a way to do this, can't find it in the forums. Basically, everywhere at work is mapped to the same network drive, but it isn't dictated which letter they have used. So, for example, my V:\ drive may be the same as someone else's S:\ drive. I need code to check all mapped...

Ok this one, in my mind is complex. I'm hoping someone can tell me I'm wrong. Scenario: Creating a weekly schedule breaking out each Day as its own sheet with at least 30 users listed. Breakdown: 1. Each sheet has 15 min increments for scheduling 2. Each cell within those 15 min increments has...

I have code that, among other things, is supposed to generate an Outlook e-mail from Access, and save that e-mail to a folder. The code works in a PC Windows 10 environment, but we are testing in Windows Server 2012 R2, and the code is throwing an error at the line in red below. We've tried...

Just as it says on the tin folks. Is there anyway to get excel 2010 to conditional format a cell if the cell contains (for instance) a six digit number followed by a letter? (123456A)? thanks

Greetings Folks, I've been spending the past week or two learning Excel and Access from a service my employer has access too called Lynda. It seems great for people who are very novice like myself. I've completed a lot of the courses for basic understanding of Excel and Access with the goal...

Hi, I thought about doing this in Excel but was curious if I could do this in Access. If I can then I'll work my way through each step to get it done. I am trying to get away from having to formate columns and rows and have everything presented to me in a nice neat look. We send letters out...

Morning all, How would this be possible please. I have a worksheet where in column B is the customers name. The first cell is B8 and continues down the page for however long. My request would be to jump to a specific first letter of there christian name. Not sure how it would work but lets say...

Is there any w/ay to write a VLOOKUP that will return the value in a specific column that is identified by a letter instead of the number of cells from a refrence point? I hope my quiestion makes sense. I had a diffifuclt time trying to come up with the correct words EXAMPLE: CURRENT...

Currently I am using a column to get the first letter of the adjacent column [company names] and then use the filter drop down box to narrow the viewable results to just that letter. So in a few keystrokes I can filter to all companies that start with the letter "D". But this entails selecting...

Just like the title states, I need to select all of the cells in Range("Table1[[#Headers],[PO'#]]") that begin with a letter, there is both numbers and letters in the table and it is sorted "A-Z" already. Thanks in Advance!

Why does this code require the "& 1" in the conversion from column letter to number? Dim ColNum As Long Dim ColLet As String ColLet = InputBox("What is the column letter of the column you want to analyze?") ColNum = Range(ColLet & 1).Column MsgBox ColNum If I remove the & 1 I get an...

I have a long list of names that are sorted in alphabetical order. The list currently starts at A4 and goes down to A1000. Is there a way to quickly jump down to the first cell with cell content that begins with the letter "M" (or "m")? Thanks.

Hello, I'm hoping someone can solve this very complicated problem I'm having with an Excel Sheet. I have a table that is occupied by cells that represent 3 colors combined with letters. In other words...I created dropdown lists for every cell that offers just 3 options. (R Y and G) I created...

Hi all, Is it possible to conduct the following checks in the order listed? 1. Is the first character a number or letter, if it's a letter, is it capitalised? If it's not capitalised, it needs review. 2. Is any character after any space capitalised and the following character not capitalised...

I'm trying to create an alpha numeric code for a massive list of direct mail recipients compiled in excel. The code would be [first letter of last name]&"_"&[number 1-10,000 based on alpha order within specific letter (see below)]. Examples below. I can figure out the first letter with left but...

I am trying to adjust the first letter size and color to a name list in excel. Specifically, names are black and size 150 font but I want the first letter to be dark blue and size 200. I am close on the VBA but can't quite get it to work. Thanks in advance.

Hello folks, Bit of a strange one - I am working on correcting data inconsistencies in model numbers sent by an incorigible supplier. The goal is finding the following string within a cell and appending the letter X at the end: (letter)(4 consecutive numbers)(letter in defined list - [E,V]) ->...