I’m looking to createa workflow tool that helps our team identify when a document is ready forreview. I have a preparer column and reviewer column for each item forevery month the task is in (so up to 12 times). If a user enters an “x”in a cell, I wanted MS Excel to look to the cell to the...
I'm looking for help in creating a macro to summarize a member database by Address. This is to get our mailing address list from our member database.
Any help on how I can accomplish this would be greatly appreciated!
Example Data (Sheet 1):
I am using Excel 2013
In cell L11 I have this formula
This returns the address in the cell as $G$45 but the row number will change each time I loop the macro
In my code I want to go to that address and continue running the code.
to do this, I am using this code
Has anyone written a script that would save the 4 sheets of a workbook as a 4 page PDF and then email that PDF to a specific address from my gmail address?
Ideally I would like that PDF file to have today's date in the name.
I have a workbook that has 400+ business names with 20 to 30 products each, I really need to add business names to another column,
Column a (business name)
Column b(product name)
Column c (hopefully business address)
Am I stuck with copy and paste?
I have column with Names, (unique) ID, and Address. The problem is some addresses have their street address in one row and the row below it is their city, state and zip. I would like to have their street address, city, state, and zip in concatenated in on line based on their ID. For...
I would like a formula to extraxt the first and last name from an email address and as well as for the first and last name to start with upper case for e.g email address email@example.com
this should appear as Patrick Davids using a formula
your assistance in this regard is most...
I have over 900 individual invoices created by excel, all are stored in a directory d:\invoices and are named Inv10001.xlsx to inv100909.xlsx
I have a new spreadsheet called Address Book with one sheet called Address list.
I want a macro or a vba code to open each of the invoice files and copy...
I have lets say 5 cells. The first one has an email address in hyperlink format (blue underlined). How can I select these cells (highlight them). when I click on the first one it will open the email address. It wont allow me to select cell A1. So I went to A5 first, selected it then drag the...
I want to ask user to enter address for example 100 main street, and then my code will split the number and street name.
I tried the following but got error message. I am thinking of array must be use or do you think there is easier way to do that
thank you very much
I wrote a code to ask user to enter first and last name and then the code will msgbox fullname. Now I want to improve the code. I want to msgbox the first letter for the first name then last name. So later I can msgbox the email address.
For example, if user enter John Smith
I want to...
Hi All , and thankyou in advance for looking at this problem. I am adding 2 cells together for an email address , first name , last name with a . inbetween , then the email address ;EG STEVE SMITH , it should read as firstname.lastname@example.org.
However only on a few occasions there appears a space in...
Can anyone help with this please?
I want to extract the MAC address (used for IP) then store this value after Excel is closed down. On reopening I'd like to check that the previously stored MAC address = the current MAC address. Ideally I'd like this to work in an Add-In xlam rather than an...
Hi dear forum members,
Is there a formula that would take a cell address and return the corresponding cell reference so I can then use this reference as an argument in other fonctions such as INDEX etc... ?
Looking for a Non-UDF solution.
902 E. Fremont
902 E. Fremont
871 Main Street
Hello All, I need help. I'm looking for statement that will help me fill the middle Column. For Example, If the address ha a row number then fill it with the...