Computer Support Forum

Excel Macro -> email created with field data as subject line

Question: Excel Macro -> email created with field data as subject line

Although decently experience with excel, I am quite new with VBA and I cannot "record" this macro, so any help writing this in VBA is much appreciated.

1) I need to create a macro that will take a number that is entered into a cell, and upon hitting a button in the excel sheet create an email where the subject line is the number that was in that original cell.

1b)I would like to do this without changing the name of the excel file though, or at least have another macro that resets the file to its original name.

2) Also, if possible, the same macro/vba as above, only with two cells, a number in one and a name in the other, which then shows up as "Number-Name" as the subject line in the email.

Thanks to anyone that can help - Mike

Relevance 100%
Preferred Solution: Excel Macro -> email created with field data as subject line

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Answer: Excel Macro -> email created with field data as subject line

8 more replies
Relevance 89.03%

Hi all

Looking for some help! Working on an excel document which contains a button I need to send to multiple people, that's fine what I need is for the subject field of the email to take the contents of a particular cell in the workbook and display that. My current code is;
Code:
Sub SendThis_ActiveWorkbook()

Dim Recip()
With ActiveWorkbook

ReDim Preserve Recip(0)
Recip(0) = "[EMAIL="[email protected]"][email protected][/EMAIL]"
ReDim Preserve Recip(1)
Recip(1) = "[EMAIL="[email protected]"]example[/EMAIL][EMAIL="[email protected]"][email protected][/EMAIL]"
.SendMail Recipients:=Recip, _
Subject:="Vacancy Authorisation " & Format(Date, "dd/mmm/yy")
End With

End Sub
Basically I want the subject to be "Vacancy Authorisation [cell contents] 01/01/2000" so I want the contents of a cell to appear in between the date and the "vacancy authorisation" part of the subject line. Assistance appreciated!
 

Answer:Solved: Excel email macro auto-populate subject line

Subject:="Vacancy Authorization " & Range("A1").Value & " " & Format(Date, "dd/mmm/yy")

Regards,
Rollin
 

2 more replies
Relevance 77.43%

Hi,
I send multiple emails all with the same information in the subject field. No, I'm not spamming. I'm sending order confirmations. I would like to set up one of the function keys on my keyboard to automatically populate the Subject fields.

Example:
Open a new email
Curser is in the Subject field
Automaticlly populate "THank-you for your Order"

I found a section for Macros in the Tool bar but am clueless. ANy help would be much apprecaited. THanks!

PS: running MiccroSoft Outlook 2000 and Windows XP
 

More replies
Relevance 88.15%

I write many emails to potential clients, and find myself writing the same subject line all day long!
I would like to have a button I can hit to create a new email containing my subject line.

I found a 'Macro' script online and it worked for a day, then after trying to get it to work, I deleted it and I can't find the same script to make it work again.

Is a Macro the only option I have, or is there another way to resolve this?
If Macro is the only option..
Do you have a Macro script to put in my outlook>Toolbar>marco folder, and drag to the tool bar?

Thoughts??

Thanks!!
 

Answer:Outlook 07, Create a macro to have auto-subject line in emails

Can't you just create your email message and then save as a template? You can then either click on the template to open it or you can use a simple macro to open it.

Rollin
 

2 more replies
Relevance 86.1%

Hi

I doubt this question has been posted before, however, I apologise if it has.

I have absolutely no VBA programming experience, however, have heard of a number of useful macros that can be created using them.

I am using Outlook 2002. I work in a team of 10 and we are required action requests from customers as and when they come in. This normally works on a first come first served basis, where we assign our names to the e-mail to show that we are dealing with it. The only problem is, I have the slowest of computers and cant seem to keep up with my colleagues!

I want to create a macro (to which I have received permission from manager already), that would carry out the below; ever time I click on the unread e-mail and then press the MACRO BUTTON (which I will drag onto my toolbar):

1) flag the e-mail to follow up (no deadline)
2) mark as read
3) and ADD the words "Shaz is dealing with -" on the subject line, BEFORE the rest of the subject line details.
4) automatically saves it, therefore, everyone will be able to see it straight away, and know that I am dealing with it

I am not very fast with computers and this will save me alot of time. As mentioned earlier, my manager has sympathised with my situation, therefore, has allowed me to do this.

I would be so grateful for your help.

Thank you


Shaz
 

More replies
Relevance 84.05%

Hi All. I know this has been looked at by others, But I can't find the solution.

I'm trying to get an automatic prompt on my users outlook that will give the users a choice of text to add to their Subject line.

All email we send will have various Protective markings, that will look like [PROTECTED] etc. there are about 8 different headings, with a default of [NON]. It would be great to have a prompt that shows all, with the default one first.

If any one can help that would be fantastic.

Regards
 

More replies
Relevance 84.05%

Why do these [] show up on my subject line when I attach a file onto the message? Can I make them quit coming up? I get a lot of spam with these as the first two characters and I have messages like this blocked so I don't get so dang many.
 

Answer:[] in my email subject line

6 more replies
Relevance 83.23%

I know how to add an email address to my website, and how to add a name with something likemailto: Feedback>[email protected]But how would you insert a subject line like "A Questions about your books" or "Feedback on your website"?

Answer:Subject Line in Email Link

This site may mess it up but lets try:mailto:[email protected]?subject=A Question about your booksbasically you add ?subject= on the end of the email address and then just type the subject you want.

8 more replies
Relevance 83.23%

When sending an email using MS Outlook, is there any way to force a notification to come up when the subject line is inadvertently left blank?  This works with calendar appointments, where Outlook warns you before allowing you to set a meeting with a blank subject.

Answer:Outlook email subject line

Outlook doesn't have an option to alert you if the subject is missing. You can write a macro in VBA that will check for a blank subject. Look for code samples at Outlookcode.com.The following code checks for both a subject line and missing attachments:http://www.outlookcode.com/codedetail.aspx?id=553

4 more replies
Relevance 83.23%

Folks,I hope this is the right forum!...A friend has recently set up a website for their business. It has a contact page which includes their business email address, which has now started receiving a lot of spam...Now I know there are lots of possible solutions to help avoiding this, and appropriate action will be taken, but I've had an idea and I wonder if it can be implemeted easily into the site code...I've suggested that a message appears by the email address indicating that a particular phrase needs to apper in the subject line of any email sent, or the email will be deleted without being read. A message rule can be set up on this email address, in the email client to implement this.I know the code for a hyperlink to send an email is straitforward... my question is;Is it easy/possible to have a hyperlink that not only brings up the email message, (ie "mailto"), but also inserts a default text in the Subject field?Thanks in anticipation,Regards,Simsy

Answer:automatic email subject line?

of slightly the opposite of what you suggest; Text inserted by default into the subject field that ISN'T deleted, so the message rule would look for it... but it boils down to the same thing...Whichever way it applies, the query is, can such text be inserted into the subject field automatically by clicking on the hyperlink on the webpage?Thanks in anticipation,Regards,Simsy

2 more replies
Relevance 83.23%

Certain email messages from companies like Travelocity and Booking.com include wingdings in the email subject lines. These show up fine on one of my PCs but on the other one they show up as boxes or question marks. Both PCs are running Windows 7 and Outlook 2010. I'm sure it's a font issue of some kind, but I can't figure out which font is missing from the one pc. I've attached screenshots of the subject lines from both pcs. This isn't a crucial issue by any means, it's just annoying me that I can't figure it out.
 

Answer:Email Subject Line Wingdings

I assume that Outlook has settings for default font, whether to allow messages to use other fonts, and other formatting details. Have you compared/contrasted those settings on the two system?

If that doesn't help look at the message source. Not suggesting that without a lot of effort you can determine the font used for the Subject, but at least you can see which fonts are used somewhere in the heading or body.
 

1 more replies
Relevance 83.23%

using incredimail 2 with windows 10 home, recently some, not all, of my emails have the subject line starting SPAM then the subject line, at 1st I was just deleting them but they are now appearing on senders I subscribe to, I check the email properties to verify the sender, has anybody else had this problem or has anybody any advice please

Answer:***SPAM*** on email subject line

This is usually the fault of your security software on your machine. If you have email checking or anti phishing enabled in your security software then you probably need to adjust the parameters.

3 more replies
Relevance 82%

I'm using Outlook A when I open an email and then close it the subject line disapears. Also, I have to turn off paragraph marks in my replys. Thanks

Answer:when I open an email the subject line disapears

For the paragraph marks. it depends on which version of Outlook you are using, but in 2007, in 'reply', click on the 'orb' (top left) and select 'editor options', then click on 'display' and remove the ticks from all unwanted formatting marks.Most other settings are within the same section so you may find the 'subject' option there. Alternatively, click on 'Tools' menu and select 'Options'."I've always been mad, I know I've been mad, like the most of us..." Pink Floyd

2 more replies
Relevance 82%

Hello,

Why do some emails come with letters that spell out no words in the subject line? Or there are nonsensical letters in between or after short phrases?

How can I figure out what they mean? I am on a shared computer and I don't open them but am not sure if they are meant for me or not.

Tkx,
Barb

Answer:Strange email codes in subject line

check the sender email address if its a valid one.. can be only spam emails..

1 more replies
Relevance 81.18%

WEIRD! Any email sent to my comcast.net account just vanishes if it contains the word "freeze". I sent myself an email from my smartphone to remind myself to freeze some leftover food when I got home. The message was sent (confirmed) from my smartphone, but never received on my smartphone (including spam and trash folders). When I got home expected to find it on my desktop (Dell WindowsXP), but it wasn't there, not in Inbox, Spam folder, or Trash folder---just GONE. I then sent myself a new message with the Subject line "freeze". It was sent (confirmed in Sent box, not present in Outbox since it had been sent), but it never arrived. Then sent myself successive messages starting with "ze" (successful receipt), "eeze" (successful receipt), and "reeze" (succesful receipt). Then when I sent "freeze" it was sent but never received. Also "freezing" and "free" are never received. I checked my Preferences for any filters, but I have none set up for any specific word or phrases or senders, so I have not blocked anything. I thought "free" sounds like spam, but I have no such filter and my Spam box is empty. So then I went to the Sent email with "reeze" in subject line, which had been received, and forwarded it to myself but changed the word "reeze" in the previously successful send to "freeze"---and as amazing as it may seem, the forwarded message went through bu... Read more

Answer:Specific word in Subject Line causes email to vaporize

6 more replies
Relevance 81.18%

Hello,

When I click on a craigslist ad my yahoo email subject line no longer automatically fills in. Anyone know how to get this handy feature back? Thanks for any help.
 

Answer:yahoo email subject line won't auto fill

This depends on what Web Browser you're using. Most likely it's Internet Explorer, and you had it set to remember something specific or auto fill for that field. Often times, these can be screwed up by future actions. To prevent this, I would suggest downloading and using a program called "RoboForm". It will remember and learn information that you apply to a certain field in a web page. Each field has a specific name given by the web developer which you probably don't even know of. It remembers the form field name given like: yahoo_subj_field and then auto inserts text you entered into this field previously. IE does much of the same thing but can be screwed up easily throughout time.
 

3 more replies
Relevance 81.18%

When I get an email with a link in the subject line, I am unable to open it? I have a Vista OS and use Yahoo as my browser, which is based on IE.

Answer:Unable to open links of subject line of email?

Well a friend sent me an email with a Youtube link in the "Subject" line. (nothing in the body of the email) Another friend of mine could not open it either, but he was able to copy and paste it in the address bar at the top of the window and open it.I wasn't able to do either and requested that the sender resend it and this time put the link in the "body," and then there wasn't any problem.Thanks for your response.

7 more replies
Relevance 80.36%

The subject line in my inbox of Hotmail has disappeared from my home computer. How do I get it back? I have already been hacked once because I opened an email that I thought would be safe and it wasn't. I am about ready to close my hotmail account because I am so very frustrated with not being able to reinstate this valuable information.

Answer:Restore missing email subject line in Hotmail inbox

Go here for expert help: http://windowslivehelp.com/

2 more replies
Relevance 80.36%

Hello everyone,

I'm not sure if anyone can help me with my problem, but I thought I would at least toss it out there. I'm attempting to break out different data types from a single field that was used for comments. Cell A1 contains a box number. Cell A2 contains the data that I need to break out.

Within the data cell the data types needing to be broken out are.
Dates end with a :
Agency ends with a ;
Documents end with a ,
Comments are contained in ( )

The trick is that for every Document the Box Number, Date, Agency and Comments are duplicated.

Example of current data:

(A1)
1. 075-04-0591-0202-0286

(A2)
1. OCT 1994-MAR 1995: K00; STATEMENT OF DIFFERENCES, STATEMENT OF TRANS, DISTRIBUTION REPORTS, SCHEDULE OF CD'S, GENERAL LEDGER ACCOUNTS (DOC TYPE NOT IN BOX)
What I'm trying to do:

(A3) Box Number
1. 075-04-0591-0202-0286
2. 075-04-0591-0202-0286
3. 075-04-0591-0202-0286
4. 075-04-0591-0202-0286
5. 075-04-0591-0202-0286

(A4) Dates
1. OCT 1994-MAR 1995
2. OCT 1994-MAR 1995
3. OCT 1994-MAR 1995
4. OCT 1994-MAR 1995
5. OCT 1994-MAR 1995

(A5) Agency
1. K00
2. K00
3. K00
4. K00
5. K00

(A6) Documents
1. STATEMENT OF DIFFERENCES
2. STATEMENT OF TRANS
3. DISTRIBUTION REPORTS
4. SCHEDULE OF CD'S
5. GENERAL LEDGER ACCOUNTS

(A7) Comments
1. DOC TYPE NOT IN BOX
2. DOC TYPE NOT IN BOX
3. DOC TYPE NOT IN BOX
4. DOC TYPE NOT IN BOX
5. DOC TYPE NOT IN BOX

If anyone can help it would be greatly appreciated. Thanks in advance!
 

Answer:Macro to Seperate data within a single field

10 more replies
Relevance 78.72%

Hi Guys,

I have an issue in excel - I have a graph whose X-Intercept needs to update when I refresh the data in the sheet it works from.

I have tried to run a macro where I copy/paste the required value into the 'Format Axis' --> 'Scale' --> 'Category X-Axis Crosses At' field, but it wont let me do so.

Dopes anyone know how I can get this field to link to a cell in my data? Or some VB code I can slap in which will update the X-Axis Crosses At field from a cell?

Much Appreciated.
 

Answer:Macro to Update 'X-Axis Crosses At' field in Excel

Oh and am using Excel 2003
 

2 more replies
Relevance 78.31%

If I am in a cell in excel and would like to add a line break (eg. <br> in html), I am baffled at how. For example. if I am in notepad and I write the following:
This is line 1

This is line 2

and then I copy whole area and paste it into the excel cell, that works fine. But if I am in the cell and would like to add that line, how do I do it? CTRL+ENTER doesnt work and its driving me crazy.

Thanks
 

Answer:Adding line in excel field

If I understand correctly try holding down the ATL key and press the enter key.
 

1 more replies
Relevance 77.49%

Hi,
I am having data structure as below. I need some macro or some means to populate formula in Column D based on column C (as and when it changes) . All other column data are populated. This is beyond me. Any help or direction is greatly appreciated. Thanks in advance

Col | A | B | C | D | E
------------------------------------------------------------------------
Row | 1 | Test1 | | | 10
| 2 | Test2 | =A1 | =MAX(E2) }| 15
| 3 | Test3 | =A2 | =MAX(E3) | 20
| 4 | Test3 | =A1&","&A3| =MAX (E1,E3)| 30
 

Answer:Excel macro or formula - change field based on other cell

7 more replies
Relevance 74.21%

Hello,

I have two problems:

1.
I have a lot of scanning data, all date and time stamped. All the scans show different status of shipped packages (all shipments have unique ID#, but there are multiple scans on route for all of them to track the packages). I want to find all the packages, for which there was "misdirected" scan, then for all of them, show the scan before. So, the end result would be all the scans that show for each package where it was misdirected (the terminal# of the scan before the misdirect scan).

2.
I want to automate this: run 5 queries every two hours between 8am and 10pm, copy and paste all results into Excel to specified areas (e.g. first query results to A1, second to A5000, third to A10000, etc. or onto different tabs), save as .csv to a specific folder, then send it as attachment to a given e-mail address. Even partial solution can be good.
I only know macros (somewhat), not as much VBA, so I tried that with the TransferSpreadsheet command, but can't get it work.

Any help is greatly appreciated.
 

Answer:Solved: ACCESS: Show second latest data and export data to excel from macro

14 more replies
Relevance 74.21%

When i export my inventory from my DB into an excel file, my trailer brands are listed as they are in my DB (of course). But when i bulk upload them with XML feed to trailer inventory sites (HTW.com & HTT.com for our example here). My inventory is listed on their site, but it's not searchable because the brand search is a drop down menu on these sites.

Say i goto HTW.com and do a search for 'Blue Ribbon' trailers none of my blue ribbon trailers show up because all of mine are listed as 'BLUE RIBBON TRAILERS, LTD' and the site is searching for 'Blue Ribbon' and although they are the same trailer brand HTW.com does not see them.

What i'm looking for is maybe a Macro or even formula that once i tell it what site i'm working on, will go through my list and replace all my spellings with the proper ones for that site...

Attached is an XLS file with 3 columns, the first is my list as is from my DB, the other 2 columns are the proper spelling for each corresponding site...

Excel's find and replace feature is a VERY crude fix to this, but since it's so time consuming it's NOT a viable solution.

Any takers??

Slurpee? Zack? Anyone??
 

Answer:Solved: Excel -Macro or Formula? Replace my data with similar required data - sample

for the record, a complete solution would be GREAT, but not necessary...
I just need someone to point me in the right direction and maybe a small working sample of like 5 brands and i'll expand the list from there...

cheers
 

3 more replies
Relevance 73.39%

Hi,

I was wondering if anyone could help me. I need to extract data from multiple excel files into a new excel file and sum the values. The data comes from excel files that are made from a template so the data is always in the same place or same cells. For example, i have data saved daily in excel files with the following naming convention 080204, 080304, 080404,..... and so on. What i would like to do is have a macro that will create a week ending sheet by importing and summing the data from that week.

Thanks for reading!
 

Answer:excel macro for copying and pasting data from multiple excel files

thanks for all those who read!!!! let me know if anyone needs the code!
 

1 more replies
Relevance 73.39%

Hello again,

I have a word doc that has a form in it. The form may have any number of fields (boxes) to type text answers into, or be a drop down list to select an answer from. I need an excel macro that extracts all data from the form, but with every five fields starting a new row in excel. So all data from the form will appear within 5 columns in an excel spreadsheet.

field 1 field 2 field 3 field 4 field 5
field 6 field 7 field 8 field 9 field 10
etc

Is that possible? I have had no luck to do it myself.

Sample form attached, thank you
____________________________
 

Answer:Solved: Excel macro to extract Word form data into Excel

7 more replies
Relevance 73.39%

I've always copied & pasted recipes into my e mail & mailed to myself,but now when I receive them they always say,"Spam***** before the name of the recipe I type into the subject line. I have Vista & Windows Mail. Any way to prevent this-it never did this before. Thanks, Rosebud65

Answer:Spam**** before Subject in Subject line

The "spam" classification is either being added by your email provider's spam filtering service, or by your security software's email scanner.For example, my Norton Internet Security email scanner is integrated into Microsoft Outlook. If a message is classified as spam incorrectly, I can click a button in Outlook's toolbar called "This is not spam", then a dialog-box opens where I can tick the option "always trust messages from this email address". The message is then moved to my Inbox, with the "Spam" word removed.Now any new messages in future from that email address will not be marked as spam.However, any messages I send to myself are never classified as spam anyway, so I don't know what's happening in your case.

3 more replies
Relevance 73.39%

I'm working on a Bill of Material creation automation project that requires some expertise in VBA, and I have none.
The objective is to run a macro from an excel spreadsheet called "PGE BOM", to do the following:
1) Go to the folder "C:\Documents and Settings\Desktop\Auto Project"
2) Find all the .mdb databases in this folder
3) Find "HistoricalMaterialItemsAll" table in EACH of those databases in step 2, and import the data from the columns listed below into PGE BOM.xls's columns C through G:
DrawingNumber
ItemNumber
Quantity
PgeCode
Description
The following is a VBA code that my friend had written in Excel 2007. Unfortunately I have an older version (2000) and the code does not seem to be compatible with Excel 2000.
Sub ImportAccessData()
Stop
dPath = "C:\Documents and Settings\Desktop\Auto Project\"
sFile = "*.MDB"
strSrch = dPath & sFile
Set TargetWB = Application.ActiveWorkbook
Set TargetWS = TargetWB.ActiveSheet
sRow = 2
bFile = False
If Dir(strSrch) <> "" Then
strFlNm = Dir(strSrch)
bFile = True
End If
Do Until bFile = False
strPath = dPath & strFlNm
Call GetData(strPath)
strFlNm = Dir
If strFlNm = "" Then bFile = False
Loop
End Sub
Sub GetData(fl)
Stop
strSQL = "Select HistoricalMaterialItemsAll.* From HistoricalMaterialItemsAll"
Workbooks.OpenDatabase fl, strSQL, xlCmdTable
Set WB = Application.ActiveWorkbook
Set WS = Applicatio... Read more

Answer:Excel Macro - VBA code to import access data to excel

Hello, and welcome to the board!

When posting code, please use CODE tags, which extremely helps with readability.

Perhaps you could try using the code constant???...
Code:

Option Explicit

Sub ImportAccessData()
Dim dPath As String, sFile As String, strSrch As String
Dim TargetWB As Workbook, TargetWS As Worksheet
Dim sRow As Long, bFile As Boolean, strFlNm As String, strPath As String
dPath = "C:\Documents and Settings\Desktop\Auto Project\"
sFile = "*.MDB"
strSrch = dPath & sFile
sRow = 2
bFile = False
Set TargetWB = Application.ActiveWorkbook
Set TargetWS = TargetWB.ActiveSheet
If Dir(strSrch) <> "" Then
strFlNm = Dir(strSrch)
bFile = True
End If
Do Until bFile = False
strPath = dPath & strFlNm
Call GetData(strPath, TargetWB, TargetWS)
strFlNm = Dir()
If strFlNm = "" Then bFile = False
Loop
End Sub

Sub GetData(fl As String, WB As Workbook, ws As Worksheet)
Dim strSQL As String, iRow As Long, sRow As Long
strSQL = "SELECT HistoricalMaterialItemsAll.* FROM HistoricalMaterialItemsAll"
Workbooks.OpenDatabase fl, strSQL, 3 'xlCmdTable
iRow = 2
Do Until ws.Cells(iRow, 1) = ""
ws.Cells(sRow, 7) = ws.Cells(iRow, 5) 'Get the Description
iRow = iRow + 1
sRow = sRow + 1
Loop
Application.DisplayAlerts = False
WB.... Read more

1 more replies
Relevance 72.98%

I am trying to create a macro (total novice at this) that will search for a word in a column and wherever it finds that word will insert a row below that. My worksheets range in size from 200- 3000 lines of data with 12 columns accross. The word can usually fall into the third column. Any help would be greatly appreciated. Thank you!
 

Answer:Solved: Macro to Insert a Line in Excel

9 more replies
Relevance 72.98%

I have tried using text to tables, pressing alt and using 0100 for this file - but the data is separated by two squares and this does not seem to work.

I think I have attached some sample data.

What am I doing wrong?
 

Answer:Separating data in an Excel spreadsheet field

9 more replies
Relevance 72.16%

First time poster here,

I need help writing a macro which I will link to a button. Here is what I'm looking for:

I have 4 columns of data starting in rown B29 and ending in G29 (one of the columns is actually 3 merged columns which is populated by a dropdown list). 2 of the columns have formulas.

I would like the user to click the button, which will add a blank row with all the formatting from above (including the same drop down list and formulas). However, I would like to be able to add multiple lines and have the new line always appear at the end of the list.

As if that weren't complicated enough. I want to add another button to act as a 'reset' button which will delete the added rows, leaving me with the original blank row.

I tried recording my own macro but that doesn't work because the merged cells un-merge as the new row is added. And I can't get the new row to always appear at the bottom if I add more than one.

Is that enough info?

Brian
 

Answer:Excel Macro to Add Line while Copying Formats/Formulas

6 more replies
Relevance 72.16%

I have a list of banned words which I have named "content_check" and are in a tab called "Guide". I want to make a macro which will check cells G13, G15, G19, G21 and E30:E6000 (if not blank) in the tab "A+_Creation" and highlight in red any words which match those in the banned words list.I'm currently using conditional formatting which turns any cells which contain a banned word red, but given that the list contains almost 400 words it would be much better if only the word turned red instead of the whole cell. Would anyone know how to go about this or if there is a forum that has already covered this? I have basic knowledge of macros, but it's not advanced enough for something like this.Any help would be hugely appreciated!

Answer:Excel Macro to color certain words in a line of text

A couple of questions just for clarification...Could you give us an example of what is in the cells that need to be checked? Are they sentences, lists, etc?Could there be more than one banned word in a given cell or is it a case of "Once a banned word is found, we can move on to the next cell."If there are any other details you think we need, please provide them. Thanks.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

10 more replies
Relevance 72.16%

Hi there,
I'm trying to export data from Word 2007 form fields into an Excel spreadsheet. I was hoping to have the spreadsheet contain data on a cumulative basis for the year or quarter at a minimum. Not sure how the code runs and if this is even possible. Does it scan a folder for all pertinent info to populate the spreadsheet?

Currently we are writing about ten of these docs a day and the data entry is becoming burdensome.
I have attached an example of the spreadsheet for reference.

I can provide specific examples of file paths or folder names if that becomes necessary.

Any assistance is greatly appreciated!

Thanks!
Cameron
 

Answer:Exporting Word form field data to Excel

Here's the word doc with form fields associated with the spreadsheet.

thanks!
Cameron
 

2 more replies
Relevance 71.75%

Hi guys i am back yet again and prob not the last time as this site is the best.

I need a little help with my macro that i have attached and pasted below. In the attached excel file you will see multi records of the same thing. I need to only have 1 of each item listed and the duplicates deleted. Please Help

Sub DelDups_OneList()
Dim iListCount As Integer
Dim iCtr As Integer
' Turn off screen updating to speed up macro.
Application.ScreenUpdating = False
' Get count of records to search through.
iListCount = Sheets("Sheet1").Range("B1:B2000").Rows.Count
Sheets("Sheet1").Range("B1").Select
' Loop until end of records.
Do Until ActiveCell = ""
' Loop through records.
For iCtr = 1 To iListCount
' Don't compare against yourself.
' To specify a different column, change 1 to the column number.
If ActiveCell.Row <> Sheets("Sheet1").Cells(iCtr, 1).Row Then
' Do comparison of next record.
If ActiveCell.Value = Sheets("Sheet1").Cells(iCtr, 1).Value Then
' If match is true then delete row.
Sheets("Sheet1").Cells(iCtr, 1).Delete xlShiftUp
' Increment counter to account for deleted row.
iCtr = iCtr + 1
End If
End If
Next iCtr
' Go to next record.
ActiveCell.Offset(1, 0).Select
Loop
Application.ScreenUpdating = True
MsgBox "Done!"
End Sub

If you need further information please let me know.
Thanks ahead of time for the great help you all... Read more

Answer:Solved: Excel 03, macro for deleting duplicate line items

6 more replies
Relevance 71.34%

My PC configration is MS Window 7 Professional (64-bit Traditional Chinese version), MS Office 2010 (32-bit Traditional Chinese version) and IBM Client Access V6R1M0 (64-bit English version).

The problem is that the actual numeric value is 1,2 or 3 only in the physical file. After using the Data Transfer Excel Add-in function to download that physical file via a dtf file, the numeric value is changed as 10, 20 or 30 in the Excel.

However, this problem is occurred randomly, i.e., sometimes happen incorrect value, sometimes is normal. Any idea? Many thanks!
 

More replies
Relevance 71.34%

Hi,

Ok, hereīs my problem. I have a report that I need to make several times a month. To do that I need to get data from a certain BI application that generates huge amounts of data. After that I need to make a pivot from that data and then select different fields from the fields list. Occasionally, I need to use different fields and it is a pain in the a** to find the correct fields, since the BI fields (there are a LOT) are not alphabetized and I canīt change the order of columns there.

So, is there a way to order the fields in the field list in any way?

Thanks, in advance!
 

Answer:Is it possible to rearrange data in excel 2007 pivot field list

Hi, welcome to the forum.

If you select the entire sheet before you create your pivot tabel you can sort from left to right
That way the header row, which contains the fieldnames will de alphabetically sorted.

Try it with the Data Sort and options.

I just tried it under Office 2003 and 2007 adn 2010 have the same options.
 

3 more replies
Relevance 70.93%

My sister sent me a e-mail saying that all her e-mails when sent out suddenly have ***SPAM*** inserted in the subject line right in front of the subject she has typed. Even if she forwards an e-mail it inserted in the subject before the FW: see below an example:

Subject: *** Spam *** FW: HPSD Antenna

Has anyone seen this before? She uses Outlook as her mail client sw. Please advise, thanks
 

Answer:Subject: *** Spam ***apeares in subject of all email

Not seen that one, but.........

SpywareBlaster 3.4 http://majorgeeks.com/download2859.html
SpyBot V1.4 http://www.majorgeeks.com/download2471.html
AdAware SE 1.06 http://www.majorgeeks.com/download506.html
MS AntiSpy - http://www.microsoft.com/downloads/...a2-6a57-4c57-a8bd-dbf62eda9671&displaylang=en (XP and W2K only)

DL them (they are free), install them, check each for their
definition updates and then run AdAware, MS AntiSpy (W2k/XP) and Spybot, fixing anything
they say.

In SpywareBlaster - Always enable all protection after updates
In SpyBot - After an update run immunize

Do these and reboot before the next step.

Then get HiJack This V1.99.1 http://thespykiller.co.uk/files/hijackthis_sfx.exe - double click the DL file and click unzip letting it extract to its default folder C:\Program FIles\HiJackThis, run it from there, DO NOT fix anything, post the log here.
 

2 more replies
Relevance 70.52%

Hi, I was kindly helped my AJ on this site to end up with

=SUMPRODUCT(((A7:A18)>=A6)*((A7:A18)<=B6)*(B7:B18))

for the folowing:
2 colums, 'A' with the year (currently as plain number) 'B' with a simple number. There are roughtly 5/8 entries for each year, from 1989 to 2008. I need to sum 'b' for a range of years, (say 1990 to 1995), I can do it for one year value but not more.

but the further problem I have is:
I have a list of 160 rows with the year being the key data field and selecting various ranges say 1995 to 2006.

I need to capture the data in a way that I need to keep historic info for years gone (2006,2007) but then alter the sheet (remove a row if no longer relevant) for current and future years.

I was thinking of having a final column with a "year removed field" and the main formula above being dependant on that for inclusion, make sense?
Many thanks
 

Answer:Excel 2003 - Selecting data within a date range with a further logic field?

8 more replies
Relevance 70.52%

I am in the process of creating a workbook to track the progress over a number of measures for individual team members. Each worksheet is designated to an inidividual, it compiles their results over around 20 measures into a monthly, quarterly and annual pefrormance percentage score based on points achieved vs points available. Finally a 'team performance' sheet references each of the individual sheets, copies the performance percentage for each month and quarter over and calculates the rank of the person within the team.The formulas on the sheets themselves work well, however to set the workbook up manually for other teams would be very time consuming as the 'team performance' sheet uses =(JOHNSMITH!F143) to pull the data across to it. It would require each formula to be changed based on the name of the worksheet.So, what I am now attempting to do is use a 'setup' worksheet that takes a list of names and then copies a 'template' worksheet and auto populates the worksheet name. The macro I'm using for this (found on this forum) works fine, it creates duplicates of the template based on a list of names:Private Sub CommandButton1_Click()Dim strCol As StringDim strRow As StringDim rngStart As RangeDim rngEnd As RangeDim rngCell As RangeDim strWsName As StringDim strSrcName As StringOn Error GoTo ErrHnd'setup column letter and first row number containing names'columnstrCol = "A"'row (number is in double quotes)strRow = "1"'turn off screen updating to stop flicker & increase speed... Read more

Answer:View data in one sheet from sheets not yet created (excel)

Easy. use a for/next that refers to sheet index numbers rather than names The new sheet you add always has the highest index ID so when looping thru the sheets, stop one short of the sheet count.for i = 1 to workbook.sheets.count-1... sheet(i).cells(x,y)... blah, blah, blahnext i

2 more replies
Relevance 70.11%

Hi there ... I want to write a macro that would take the user to the next new unique data in a column. I have a list of account numbers that may be listed 3 times back to back in the column or up to 50 times back to back. I have a particular cell pointed at the top of the column, (ie, "=A1") and I want a macro to take the user to the next new account number in that column, which could be any number of rows down.

Suggestions? The cell I want the reference to change is in sheet1 and the account numbers are in a different sheet, same workbook.

Thanks!
 

Answer:Macro for Excel - next new data

14 more replies
Relevance 69.7%

computer: Windows XP Professional Version 2002 Sp2outlook: microsof Outlook 2002 (10.6838.6845) SP3Is there any way to overturn a txt file for example, the subject field of all emails in a tray outlook?"La experiencia es algo maravilloso. Nos permite reconocer un error cada vez que lo volvemos a cometer.", Franklin P. Jones

Answer:dump the subject field to a file

Cannot understand what you mean???

3 more replies
Relevance 69.7%

Can anyone help with creating a button to insert a standard phrase into the Subject field of an Outlook 2002 email message? For instance I want to be able to insert "Internet-authorised: " when I email onto the Internet instead of the company LAN.

Answer:Standard Subject Field in Outlook

I believe a macro, with a button linked to it, is the solution.  At the moment, I can't tell you how to do that.  I've never created a macro in Outlook but I see it can not be done as easily in Word and Excel; you can not simply use the Macro Recorder, you have to open the Visual Basic editor and create code there.  I happen to have recently obtained two libary references on Outlook, a book and a DVD.  If I can find time to delve into this further and get an actual macro recorded, I'll post the coding for it.

2 more replies
Relevance 69.7%

Any advice please, the subject field has dissapeared from my new mail screen in outlook XP.

Answer:Lost subject field in Outlook XP

Look in View/ Current View/ Format Columns

8 more replies
Relevance 69.29%

HiMy orginial excel 7 data looks like this.Name UserID OrderedDate RequestedDate OrderNumber FoodItem Quantity Email Phone Data deleted by Moderator due to possible plain text email addresses and phone numbers.I then run this macro against it.Option ExplicitSub Consolidate()Dim LR As Long, i As Long, MyVal As StringLR = Range("A" & Rows.Count).End(xlUp).RowApplication.ScreenUpdating = FalseFor i = LR To 2 Step -1If Cells(i, "A") = Cells(i - 1, "A") ThenIf Cells(i, "F") = "" ThenRows(i).EntireRow.Delete (xlShiftUp)ElseMyVal = Cells(i, "F").ValueRows(i).EntireRow.Delete (xlShiftUp)If Cells(i - 1, "F") = "" ThenCells(i - 1, "F") = MyValElseCells(i - 1, "F") = Cells(i - 1, "F").Value & ", " & MyValEnd IfEnd IfEnd IfNext iColumns("F:F").AutoFitApplication.ScreenUpdating = True[J:J].Delete[I:I].Delete[H:H].Delete[E:E].Delete[B:B].DeleteEnd SubWhich gives me the following results.Name OrderedDate RequestedDate FoodItem Quantity Data deleted by Moderator due to possible plain text email addresses and phone numbers.I need to edit the macro so it does the following-Each item needs to be listed on a separate line in that row.-The quantity number needs to show up next to each separate item.-I would like to have the data go to a new sheet instead of wiping out the original data once macro is run against it. (I know you did this in the macro you sent me but I could not get it to work with this macro).Thank you very much in advance.Mark edited by moderator: email & phone number data delete... Read more

Answer:Need Excel Macro Help with Data Manipulation

I have deleted the data that you posted because it appeared to contain email addresses and phone numbers. Since I can't tell if these were fake or not, I had to use caution and delete them.Please try to post generic data that shows your layout without being a possible security risk. In addition, please refer to the How To in my signature line before you post anymore data or code. The How To will explain the proper way to post data and code to make it easier to read in this forum.DerbyDad03Office Forum ModeratorClick Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 69.29%

I have a spreadsheet with person identifier in column A, date in column C and location in column D (column B is irrelevant to my query)I would like a macro with would infill columns C and D when person identifier in A is equal,A C D234 12/5/11 GP surgery234345So I would like the macro to infill C and D with 12/5/11 and GP Surgery for A=234 but not for A=345I would like the macro to loop through my worksheet

Answer:I'd like a macro for excel to in fill data

What do you mean by "hen person identifier in A is equal"?what does 234 stand for? is this a constand number or will this change,im sorry i dont understand what you have written can you please explain a little better?

4 more replies
Relevance 69.29%

I would like to write an Excel macro that includes pausing for data entry from the keyboard. For instance I have a spreadsheet for a simple bookkeeping project. I would like a macro that, when invoked, would do this:
Type "Current income" in the cell the cursor is on.
Move two columns to the right.
Stop for me to (1) enter a dollar amount and (2) hit the "enter" key.
Move two columns to the right.
Stop for me to (1) enter a dollar amount and (2) hit the "enter" key.
End of macro.

My thanks for any help!!
 

Answer:Excel macro for entering data

11 more replies
Relevance 69.29%

Hello,I'm trying to create a macro to do a variety of functions. The data set I'm working with is generate from a Fuel Injection ECU. Once a test run is done, the data is exported into Excel. I end up with four columns of data, Time Stamp, MAP, RPM, and O2 Reading.The Time Stamp column is deleted, then the MAP value is rounded to the nearest multiple of 10 using MRound, RPM is rounded to the nearest multiple of 100 using the same function, and the O2 Reading is rounded to the nearest 2 decimal places.I then swap columns A (MAP) and B (RPM) so RPM is in column A, followed by MAP and then O2 readings.I then pull off each set of RPM data and insert it into a new worksheet labeled with the RPM data.Once the data set for a certain RPM range is in the new worksheet I then sort the data according to the MAP data and separate out the initial columns into the different MAP ranges. Finally I average the O2 reading for each MAP range at that RPM.The data sets are very large with anywhere from 1000-5000 entries so as you can imagine it takes awhile to sort through this by hand. Any help, sample codes that I could piece together, etc would be appreciated.

Answer:Help with Excel Macro, Data Sorter

re: sample codes that I could piece togetherThe Time Stamp column is deletedColumns(1).Delete
or
Columns("A").Deletethe MAP value is rounded to the nearest multiple of 10 using MRoundFor rwMAP = 1 To 1000
Range("A" & rwMAP) = _
Application.WorksheetFunction.Round(Range("A" & rwMAP) / 10, 0) * 10
NextNote: MROUND can be used in VBA if you have the Analysis ToolPak installed and you set a reference to atpvbaen.xls in the VBA editor.O2 Reading is rounded to the nearest 2 decimal placesFor rwMAP = 1 To 1000
Range("A" & rwMAP) = _
Application.WorksheetFunction.Round(Range("A" & rwMAP), 2)
Nextswap columns A (MAP) and B (RPM)
Columns("B:B").Cut
Columns("A:A").Insert Shift:=xlToRight
Everything after that is going to need a little more explanation. I'm not sure what you mean by each set of RPM data or MAP range at that RPM.

2 more replies
Relevance 69.29%

Hello - I want a macro in excel 2003 or (workspace pro 6.5 or Happy Harvester2) that collects info from the web sub page, one case after another case, till done. It should put selected info in excel, each case on a different line. However, the excel "repeat" under "edit" that I am using, fails to accomplish moving to the next line; instead it repeats the first line. I have made the macro with mouse clicks, and dont understand VBA:

Desired excel result"
ADDRESS CITY OWNER LENDER CASE DATE
123 Maple | Xenia, Ohio | Able Jones | Bell Mortgage | cv1223 | 11/04/2010
380 bell st | Dayton, Ohio | Blule | Bank America | dv 3348 | 10/03/2010

Web page listing cases URL: http://www.co.greene.oh.us/pa/pa.urd/PAMW6500
Able jones cv 1223
brown cv 129
blule cv 3348

Sub page with details on one case
URL: http://www.co.greene.oh.us/pa/pa.urd/pamw2000*o_case_sum?473007
Bell Mortgage vs Able JOnes cv1223
address: 123 Maple
Xenia, Ohio 45385

filed 11/04/2010 status open
Thanks, thanks so much.
 

Answer:Excel macro geting web data

What program did you actually create the macro in? Can you post your existing code?

Rollin
 

1 more replies
Relevance 69.29%

Hi,

My VBA/Macro knowledge is very basic, but I am able to record macros and edit them. I have a scatter plot (with 5 series) and I want to automatically change the line style (i.e. solid or dashed etc.) depending on the text in a cell. This is what I tried, but I cannot get the code to reference the cell which contains the text:

--------------------------------------------------------------

Sub Macro14()
'
' Macro14 Macro
'
'
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.SeriesCollection(1).Select
With Selection.Format.Line
.Visible = msoTrue
.DashStyle = msoLineSolid
End With
End Sub
--------------------------------------------------------------

For the line ".DashStyle = msoLineSolid" I tried ".DashStyle = Range("A7").Select" but this does not work.

Is there a simpler way to set-up a macro to format graphs automatically based on a cell content/format/colour, does anyone know a good guide to do this?

Thanks
 

Answer:Excel Macro to automatically change chart line style based on cell text

Hi,

I'm not familiar with charts. But, see if this helps.

http://social.msdn.microsoft.com/Forums/sk/isvvba/thread/50180062-37e0-435e-bf52-0f6de482d8ef
 

3 more replies
Relevance 68.88%

I have an Excel model (office 2000) which has a range of cells that contain if/then statements. I'm trying to get Excel to automatically send an email if any of the cells within that specified range were to provide a value that was false. Is this possible? Thanks for any insight.
 

Answer:Email Macro in Excel??

16 more replies
Relevance 68.88%
Question: Excel Email Macro

Hi

I am trying to write a macro in Excel 2003 to automatically send an email using Outlook to a list of individuals asking them to confirm their personal details using the attached template. Could someone show me where I am going wrong with the script please?

Many thanks
 

Answer:Excel Email Macro

16 more replies
Relevance 68.88%

Any way of controlling the time a email is sent via a excel spread sheet using vba?
 

Answer:Excel - macro email-

6 more replies
Relevance 68.88%
Question: Excel Email Macro

Hi All,

I have a spreadsheet and i am needing to create a macro that will opena new message in Outlook and populate the 'To' Field with one cell and then the 'CC' field with 2 email addresses, one from one field and the other from a different field. then the subject from another field and then the body from another. it then leaves the message window open so i can check it right and hit send.

I found the script the other day but can not find it anywhere including this site.

Any help on this will be great.

JPL

Any
 

Answer:Excel Email Macro

Hi JPL,

You could use this function, just pass the values to it
Code:

Function MailData(mSubject As String, mMessage As String, Sendto As String, Optional CCto As String)
Dim eSubject As String, EBody As String
Dim app As Object, Itm As Variant
Set app = CreateObject("Outlook.Application")
Set Itm = app.CreateItem(0)

With Itm
.Subject = mSubject
.to = Sendto
If Not IsMissing(CCto) Then .CC = CCto
.Body = mMessage
' .Attachments.Add (NewFileName1) ' Must be complete path
.Display ' This property is used when you want
' .send
End With
Set app = Nothing
Set Itm = Nothing
End Function

It's from one of the posts, I do not remember which one
 

1 more replies
Relevance 68.47%

Hey,

Posting here before, I received several prompt replies. Due to my success, I will try once again, but this time with a different issue/question.

I have a spreadsheet with 1 column and 3000 rows. In each row, there is a 1 cell block with a series of numbers/characters. I need some type of formatting/macro that will extract only certain characters from each row and place them somewhere else. In example, I have the following rows:

7r74$#@$i4 i3o45$#---$#@$#/4432438
4327$##@$#4343u3i33$$( #343432822
4324*& 345435**(&^*&^342434234324

I need to extra the 12, 13, & 14th character of each row, whether it be a letter, number or space, it doesn't matter. Now the 12, 13 and 14th character need to be placed in there own newcolumn to the right of where they were prior. So the results, would look like this:

7r74$#@$i4 i3o45$#---$#@$#/4432438 i3
4327$##@$#4343u3i33$$( #343432822 343
4324*& 345435**(&^*&^342434234324 435

The post here will not let me space it correctly, but to the right of the first entry would be " i3", the second, "343" and the third "435".

So, it seems pretty simple, but I am not knowledgable enough with formulas, macros or vb to be able to figure this out. I also need to be able to adjust the formatting/macro/vb script every couple months as the "character extraction" place could change.

Thank you, hopefully someone is familiar with what I am trying to do and can understand this basic i... Read more

Answer:Excel, Formatting/Macro Creation for Data

Are you okay with just a formula? Try this if your data is in A1:

=Mid(A1,12,3)

12 is the starting position, and 3 is the number of characters to return.

Let us know if you do need it in a macro.

HTH,
 

3 more replies
Relevance 68.47%

I need assistance with creating a macro. I need to create a lot of different reports but I want the macro to create them for me. Is there way to create a macro by: having a list of data, sorting it all by column A, then copying whatever is the same name in column A (and whatever is associate with column A- to the right) and inserting it into a new worksheet and then doing it for all the different data that is in column A. Then once it is put into the worksheet, to save it with whatever the name is from Column A in the first worksheet.

I figured that there needs to be a loop statement in the end so it will get all the grouped data together into seperate worksheets.

Thanks for your help. I have attached a spreahsheet to get a better idea of what I was looking for.
 

Answer:EXCEL MACRO- sort, copy different data

6 more replies
Relevance 68.47%

I need some help with a macro. I need to save data from certain cells in 1 worksheet and to another worksheet. Details belowI want to grab the data in worksheet "survey" from cells A3, A4 and A6 and save them to worksheet "data" in cells A2, B2 and C2. After the save is done I then want to clear the data from cells A3, A6. I created an object button in my workbook that is clickable. I just need to assign a macro to it. I have been working on this for over a week and I am new to macros so it is a struggle. I have even went as far as purchasing a program call teachmemirosoftoffice and still can't figure out the whole thing. I get portions of it to work but not all of it. I would greatly appreciate anyone who can help me write this macro. I would forever be indebt to you my friend. Thanks.

Answer:Need a macro for excel 2007 to save data

Since you do not appear to have a contiguous range of cells in your source document, you have to do each cell individually. A contiguous range could have been copied and pasted Transposed into your destination, but since you skipped A5, you can't use that method.Try this:Sub CopyThenClear() Sheets("data").Range("A2") = Sheets("survey").Range("A3") Sheets("data").Range("B2") = Sheets("survey").Range("A4") Sheets("data").Range("C2") = Sheets("survey").Range("A6") Sheets("survey").Range("A3, A6").ClearContentsEnd Subre: "I would forever be in debt to you "Forever is a long time to be indebted for a few lines of VBA code. A simple thanks and a promise to pass it forward will suffice.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

6 more replies
Relevance 68.47%

I have a macro that searches 4000 rows of data which returns many results. The macro stops when a result is found and I have to copy and paste the criteria and the result to the next blank row in another sheet. The criteria is in sheet A range G2:K2The Result is in sheet A range H6:K6 and H10:K10How do I record these 3 ranges sequentially on a row on sheet B without stopping the run to do it manually?Please can you help.

Answer:excel macro to Find & Copy Data

It might help us help you if you would post the code you are currently running.Since we can't see your code from where we're sitting, it's a bit difficult to suggest modifications.

6 more replies
Relevance 68.47%

I have a need to move data from one worksheet that has an associated date to the correct spot in another worksheet with column that runs from 1/1 to 12/21.
Worksheet 2
1/1
1/2
1/3
1/4
...
12/31

Worksheet 1 has:
1/29 45
1/30 23
2/4 13
The macro would read the date in column A of worksheet 1 and put the data into the correct row of column B in worksheet 2. So that after running the macro worksheet 2 would look like this:

1/1
...
1/28
1/29 45
1/30 23
2/1
2/2
2/3
2/4 13
...
12/31

I hope my intention is clear and understandable.

Thanks in advance for any help,
tom
 

Answer:Excel Macro to move data into correct rom

8 more replies
Relevance 68.47%

I would be very grateful if someone could help. I have a worksheet ("Master") which contains information on patients undergoing operations. The sheet has around 2000 lines and 56 columns (A:BD). Each row represents one patient and column C contains the name of the surgeon who carried out the operation I need to create separate worksheets for each of the 23 surgeons involved, each conatining a subset of the data on the "Master" worksheet. To give an example, I might have a worksheet called "Mr Smith" which would correspond to a surgeon's name in column C of "Master". On this sheet I need details of any patients who he operated on, but I do not need information from every column - probably only about half of them. They data fields are a mixture of text, dates and numbers.Is it possible to write a macro that will be able to do this? I would be very grateful for any help, as I have never tried to write a macro before. I am using Excel 2003.Thanks

Answer:Using a macro to select and move data (Excel)

I suggest you try this code in a backup copy of your workbook since macros can not be undone.This code will create a list of the surgeon's names in a new sheet ("MD List")and then create a sheet for each surgeon.It will then copy each row that contains that name in the Master sheet to the specific sheet for that surgeon.Since I can't see your spreadsheet from where I'm sitting, I had to make some assumptions.On your Master sheet, I am assuming that you have column labels in Row 1 and that your data starts in Row 2. I am assuming that you want the same column labels on each individual sheet.You said that you didn't need to copy the entire row, but you didn't say what you really needed, so the code copies the entire row. This can be modified.Let me know what you thinkOption Explicit
Sub MD_Sheets()
Dim numShts, numItems, srcMD, mdSht, nxtRow As Integer
Dim mdName As String
'Add a new worksheet for filtered list of MD Names
ActiveWorkbook.Sheets.Add after:=Worksheets(Worksheets.Count)
ActiveSheet.Name = "MD List"
'Create a list of unique MD Names
Sheets("Master").Columns("C:C").AdvancedFilter Action:=xlFilterCopy, _
CopyToRange:=ActiveSheet.Range("A1"), Unique:=True
'Count number of MD names so we know how many sheets to create
numShts = WorksheetFunction.CountA(Sheets("MD List").Columns("A"))
'Create new sheets, named for each MD, add Column lables
For mdSht = 2 To numShts
ActiveWorkbook.Sheets.Add after:=Worksheets(Worksheets.Count)
ActiveSheet.Name ... Read more

3 more replies
Relevance 68.47%

Hi,
I am trying to run a macro which will insert a row of formula to the last row of my data. Say for example.

A1: Formula
A2: 1
A3: 2
A4: 3

I wish to set the macro to always insert into the last row of column A, instead of at Cell A4. Something like,

A1: Formula
A2: 1
A3: 2
A4: 3
A5: Formula

something to do with lastrow formula? Any help would be greatly appreciated.

my current macro is written like this,
'
Rows("13:13").Select <- the formula row
Selection.Copy <- copying the formula
Rows("17:17").Select <- i wish this to go to the last row instead**
Selection.Insert Shift:=xlDown
End Sub

Any help would be much appreciated.

Thanks
 

Answer:Excel Macro : inserting copied data to the last row

Howdy, and welcome to the board.

Something like this:
Code:

Sub test()
Dim lngLastRow As Long
lngLastRow = Cells(Rows.Count, 1).End(xlUp).Row
MsgBox lngLastRow
End Sub

then you could use for the next formula row:

Cells(lngLastRow + 1,1)
 

3 more replies
Relevance 68.47%

I have started recently to mess around with macros but I can't quite figure out how to do this one. I have this list of songs with three columns (artist, title and track #) but what i want to do with it is to insert a row between each artist while dropping down the track #. But when the artist is the same i want to add these track numbers. Any help would be appreciatedThanks in advance!

Answer:Excel Macro Help Insert Rows, Sum Data

I don't understand what you are trying to do.Please click on the following line and after reading the instructions found via that link, post a small sample of your data, before and after.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

6 more replies
Relevance 68.47%

I have been scouring site after site and googling like crazy to find the type of info I have seen here. Great help guys.I am attempting to sort data from worksheet 1 and copy it over to 26 existing different worksheets. I want to keep the info on sheet 1 available and have it copy and pasted based on information in column E. Column E would reflect names of workplaces for those 26 other worksheets (already named).From what I have seen Derby and Humar have been a huge help and really appreciate any help you or anyone else can give me.(Sorry if I left room for question on the goal. 1st time posting forums for tech help.)

Answer:Excel '07 Macro for sorting and copying data

This thread here is pretty much what I am looking for (from what I read). I attempted to modify it for my needs with no luck whatsoever...http://www.computing.net/cgi-bin/my...I changed references to worksheets and source page information and probably things I should not have. (reason why I am still watching it do the same thing it has been for the last week... lol)

3 more replies
Relevance 68.47%

I have a column that will have values changing but not in consecutive order. For example if I had range A1:A10, only A1, A4, and A9 might have values, but the rest of the cells would be blank. I need to be able to generate A1, A4, and A9 into the next column consecutively as B1, B2, and B3. The A column values could change (including the number of values) and I need the B column to react accordingly. So the next time I run the data, I might have A2, A3, A4, A6, and A10 with data in them - so I need column B to be able to react and put the values (in order) as B1, B2, B3, B4, and B5. Oh and I need all this done in a MsgBox. Can you help? Thanks so much.
 

Answer:Excel Macro Advice - Data Consolidation

9 more replies
Relevance 68.47%

Hi,
I have a major problem crunching large amounts of numbers coming off an instrument I work with but the file format it puts the results into is terrible and I cannot change it. So I must export the results in a format which needs some serious formating before it becomes of any use to me.

I have used excel macros to delete rows and rows with specific text values. But now I would like to create a macro that will reorganise this data in a more user friendly format. I did use the sort asending command to partially solve the formating problem but it would still require alot of work/time to organise it into the final format I need.

This is the current format of the instrument date:

Analyte Meas. Intensity
Rh 10
Y 98
Cs 66
Co 98
Analyte Meas. Intensity
Rh 10
Y 114
Cs 72
Co 86
Analyte Meas. Intensity
Rh 20
Y 108
Cs 44
Co 90
Analyte Meas. Intensity
Rh 20
Y 68
Cs 44
Co 66
Analyte Meas. Intensity
Rh 490.008
Y 58
Cs 34
Co 78
Used the "sort asending" command to separate data into useful form but need to get the data into either of the two tables shown below

Analyte Meas. Intensity
Analyte Meas. Intensity
Analyte Meas. Intensity
Analyte Meas. Intensity
Analyte Meas. Intensity
Co 98
Co 86
Co 90
Co 66
Co 78
Cs 66
Cs 72
Cs 44
Cs 44
Cs 34
Rh 10
Rh 10
Rh 20
Rh 20
Rh 490.008
Y 98
Y 114
Y 108
Y 68
Y 58
I would like to turn the data into this final format using a macro.

Co Cs Rh Y
98 66 10 98
86 72 10 114
90 44 20 108
66 44 20 68
78 34 490.008 58

Can somebody help me please ... Read more

Answer:create an excel macro to reorganise data?

ZIP and post a sample workbook.
Rollin
 

1 more replies
Relevance 68.47%

I am new to VBA and am trying to create Macro for Excel 2003. I understand the logic behind it but when I recorded the macro it didn't capture what I wanted. I want data pulled & deleted from Worksheet A (TASKS) to Worksheet B (COMPLETED) depending on value entered in colum F (worksheets are exactly same). My rows start with A3 and end I3 all the way A500-I500. If 100% is entered in column F... I want the row associated to be deleted from TASKS and moved to COMPLETED in the same cells so that it's under the same section.

Answer:Excel Macro - Move & Delete Data

Hi,Here is a macro that moves rows from the TASKS worksheet to the COMPLETED worksheet based on the value 100% being entered in a cell in column F of the relevant row.The Change event is used to detect the change in a cell value on the worksheet and then the changed cell is tested to see if it is both in column F and contains '100%'.If that is the case, it copies the whole row, to the same row on the Worksheet named COMPLETED and then clears the contents of the row on the TASKS worksheet.Note that for this to work automatically, the 100% in column F must be entered by hand - the change event will not trigger if the 100% is generated by reference to another cell.Test this out on a copy of your workbook - see warning note at end of this post.To add code, right-click on the name Tab for the TASKS worksheet.Select View code.In the window that options paste the following:Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ErrHnd
Application.EnableEvents = False
'test if changed cell is in column F and that it contains 1 (100%)
If Target.Column = 6 And Target.Text = "100%" Then
'copy to same row on 'Completed' Worksheet
Target.EntireRow.Copy _
Destination:=Worksheets("COMPLETED").Range("A" & Target.Row)
'Clear source row data
Target.EntireRow.Clear
End If
Application.EnableEvents = True
Exit Sub

'error handler
ErrHnd:
Err.Clear
Application.EnableEvents = True
End SubUse ALT+f11 (Alt key and function key 11 pressed together) to... Read more

2 more replies
Relevance 68.06%

I want to be able to place the date in reverse order in the subject line of new emails when I press a button on the toolbar. The format of the date should read '20061003' for the 3rd Oct 2006 - I know i should be able to use a macro or write VB scipt, bit i am not that clever - please help - many thanks

Answer:MS Outlook 2003 - Reverse Date in Subject Field

06.10.03 - subject.It's easier to read and there will not be a filing problem for the next 94 years or so.I'll leave the technical stuff to others

8 more replies
Relevance 68.06%

My sense is this is a pretty simple request, but I'm completely illiterate when it comes to VB.

I have an excel spreadsheet with a number of data points. I'm looking to export the entire sheet to a CSV file and send it via Outlook. Any suggestions?
 

More replies
Relevance 68.06%

Windows 7 --------------------------------------------------------------------------------First thing...I know nothing about macros!! I do know a very little about formulasI have created "IF" formula in excel 2010, based on a date it will create a send due in column "E", =IF(D5=$A$2,HYPERLINK(mailto:"&$K$1&"?subject="&A5&-B5&"&body="&$C$3,"sendworks great but, I have to go thru 86 rows in column "E" and hit "Send Due" numorous times,then hit send again on all the emails, can we automate this some how, like a macro that engadges when I open my outlook every morning?Thank u

Answer:Need Macro to automate email from excel

I have written code in Outlook, which is essentially a template, you fill in the details, all sorts of stuff happens accordingly to what you have selected, and you press send and it will send the emails to whoever it is you want. Iv done this in Outlook, so my question is, why do you need this to be done in Excel? is Outlook acceptable?

3 more replies
Relevance 68.06%

I have a user who wants to create a macro which will automatically send an excel spreadsheet into outlook and email it.
Any suggestions welcome. Thanks.
 

More replies
Relevance 68.06%

Hello all;

I am new to this forum and also to Excel macros. I have a large Excel file detailing financial accounts with my small business.
Anyway, I would like to email any customer who has an overdue balance as per column V in my attached sample file (any customer with a greater than zero value in V). I would like to send an email; something like this:

Joe Wilson;
As of 2/28/11 (latest date in the row that is on/after the current date), your account is currently overdue and you owe $1500.00 (G3).
Thank you.
Treasurer
I found several other threads explaining how to send an automatic email from Excel, but I haven't found one for sending an individualized email to a list of recipients. If this question has been answered, please feel free to redirect me. Otherwise, I'd appreciate any suggestions. Please let me know if I can detail my needs any better.
Thanks!
 

Answer:Excel Macro: Auto Email

welcome to the board.

I put some code in the sheet

The macro name is CheckAndMail

Let me know if this is what you need

PS: I just corrected something I came accross and have re attached the corrected sample
 

2 more replies
Relevance 68.06%

Hi,

I have a worksheet containing various data including an expiry date, this is created by adding 364 to the start date and then then using an auto fill to fill in all other rows (over 50,000).

I would like to make a macro to do this alongside a number of actions but when making the macro I am specifying only a certain range to fill (A1:A50000). The problem I have is this list is consistently growing and so this range would then not include any new records added. Is there a way that I can make it so it auto fills from A1 to the last present row?

Thanks for your help

Dan
 

Answer:Solved: Auto Fill Data in Excel Macro

8 more replies
Relevance 68.06%

Hi,

I need a help with a macro. I have two separate sheets that I need to combine together. Sheet 1 contains combinations of 2 PROCESSES, e.g. 1-2 and 1-3 (columns B and C) and sheet two contains additional data (PRGRAMS) for each of the process (each program on separate row - the process number linked to sheet 1 is in column A). So for process 1 there are 5 programs rows, for process 2 there are 3 rows and for 3 there are 8 rows. I would like to create a third sheet, that combines PROGRAMS (from Sheet 2) based of given combinations of PROCESSES from sheet 1 and attaches LHS (for the left side of the rule and RHS for the right side of the rule). I attached a shortened example. I need this for 600 combinations.

There could be a way in inserting number of rows into sheet 1 e.g. for the combination 1-2 (there would be the number of rows added that equales the count of "1" + count of "2" programs from Sheet 2 and the programs would be pasted).

I hope its not too complicated.

Thanks a lot for your help!

Marketa
 

Answer:Solved: Macro for combining data from two excel sheets

6 more replies
Relevance 68.06%

Hi guys i'm hoping you can help me i'm a complete noob when it comes to macro's
 

Answer:How do i create a macro in Word that opens the data in Excel?

12 more replies
Relevance 68.06%

Excel noob needs help. I have a spread sheet that changes daily. I would like a macro that will search worksheet named "Schedule Report" column G and create new sheet for each city listed and copy the row to new sheet. file today may have 10 cities and next day may be 20"Don't hit at all if you can help it; don't hit a man if you can possibly avoid it; but if you do hit him, put him to sleep."Theodore Roosevelt New York City, February 17, 1899

Answer:Excel macro help - Create Sheets/Copy Data

re: "file today may have 10 cities and next day may be 20"If the macro runs today, it would create 10 new sheets and copy the data based on today's data.What should happen the next day? Should it just create sheets/copy data for the 10 additional cities or does it also have to copy/change/update data for the original 10 cities?If it has to work with the data from the original cities, how does that need to be a handled? What will have changed? Will it just be additional lines, etc.?

10 more replies
Relevance 68.06%

I'm in a bit of a pickle.

I have an excel document with a summary page ("Tracker"). This worksheet has a table in it with a whole heap of customer information, and at the end there are columns for revenue summaries.

Every month I run a report that I add in a new worksheet which is called "[Relevant Month] Revenue Report", and then I do a vlookup to transfer the revenue and product information in columns "C" and "D" of the report into the relevant month columns in the "Tracker". This has been working well for me, but i'll be handing this role over soon so I was wondering if there was a macro that I could use that would do this vlookup automatically for the relevant month?

The information in the reports is not in any particular order so i can't do a simple copy/paste into my "Tracker" summary.

Any help would be greatly appreciated!!
 

Answer:Solved: Excel Macro to transfer data from several worksheets into one

8 more replies
Relevance 68.06%

What would be the best way to find a specific Column Header, and copy the data found in the column until the column header is found again?
 

Answer:Solved: Excel Macro Copy Data From Columns

8 more replies
Relevance 68.06%

Hello,I am new to macros. I am not sure if this can be done, but I hope it can. I would like to create a macros that will create a new sheet for each day of the week automatically. Then pull certain information from the previous day to carry over. I would like it to automatically generate 5/1/2010, then 5/2/2010, etc. for example. I would like it to then take those days of the week and compile them into a new sheet labled 5/1 - 5/8 (looking @ my calendar for May). I would like for the info from the days of the week to be compiled into a summary for the week.I would then like it to compile the data from the weeks of the month into a new sheet labled month (May for example). And again, compile me a summary for the month based on the weeks and days information.Finally, I would like it to take all the months of the year, and compile that data into a new tab for the year (2010) for example. And the automatically summarize certain data for the entire year. Then, start over for 2011 doing the same thing. Days, weeks, months, year. I would like the months of the year to automatically go under the year tab, so that if I click the year tab it exapands to months, if I click on a certain month it expands to weeks and if I click on a certain week in the month it opens the days of that week.Hope that make sense. Is this possible to do?

Answer:Excel macro to Create Sheets, Copy Data

Hi,If you are asking for macros to do all of what you are asking for, then I suggest that you hire a programmer!Most of what you want is possible in Excel, although some things don't work the way you suggest:I would like the months of the year to automatically go under the year tab, so that if I click the year tab it expands to monthsI don't know what you are thinking of when you refer to tabs, such as 'the year tab'. Are you referring to the worksheet name tab, or are you thinking of custom forms with a series of tabs. Worksheet name tabs don't lend themselves to 'expanding'.create a new sheet for each day of the week automaticallyThis will result in 365 worksheets just for one year's data, excluding the month and other summary tabs.It is far better to start with all your data in one block - on one worksheet, then you can extract data for specific periods from it.Having daily data on separate sheets makes finding it and analyzing it a lot more difficult, even using visual basic macros. If you have a column containing dates, Excel stores dates as numbers which can be used to find a range of dates. If you have dates on worksheet name tabs, the 'date' is stored as a string, not as an Excel date number, so selecting worksheet names based on text representations of dates becomes quite complex.If you add 1 to a cell containing 01-Jan-2010, you get 02-Jan-2010, but there is no direct way to add 1 to a worksheet named 01-Jan-2010 to get 02-Jan-2010.If your monthly data is on separ... Read more

4 more replies
Relevance 68.06%

I am trying to recreate a macro I had on my old computer (written by someone I used to work with). The macro was made to run on a large excel spreadsheet (a lot of data) and copied all rows with the same value in a certain column and put them in a new tab (and named the tab whatever the value in that column was). Then it applied a subtotal function on each tab (same for each tab) and did some other formatting (same header row for all tabs, hides certain columns on each tab). The original tab retained all of the information, but was subtotaled and formatted the same as the other tabs (although, that isn't crucial). Please help!

Answer:How to create a macro to sort data to new tabs in excel

If you can post a short example of your data, noting which column has the values to be sorted on, perhaps we can help.Please click on the following line and read the instructions found via that link before posting your data.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 68.06%

I have a list of branches. We have a closed branch that I need to have inserted onto this report. There are times that the closed branch shows up becuase they had warranty work to do, but most times it does not show up. This is branch 046.

How do I write a macro to check for the branch and if not there add it in?

To add more to this - each branch should show up in 2 different rows in the same report. So I really need to do this for both Branch 046 and for Net Sales - Branch 046

Example
Branch 045
Branch 046
Branch 047
Branch 049

Net Sales - Branch 041
Net Sales - Branch 045
Net Sales - Branch 046
Net Sales - Branch 047
 

Answer:Solved: Excel Macro to insert row if data does not exist

12 more replies
Relevance 68.06%

Hello. I'm facing the following problem:Every day I have about 56 Excel files where the filenames fit the following 2 patterns:- half of them are named STAGE1_PAID_DD_MM_YYYY: these files would each have 2 columns (Column A is in Text Format with no headers + Column B will also be in Text Format with no headers, but the entries will be a bunch of standardized error codes repeating themselves from one row to another).- the other half are named CRON_DD_MM_YYYY: these files would each have 2 columns (Column A is in Text Format with no headers + Column B will also be in Number Format)I will always have 56 files because I will always be interested in pulling out data from the Excel files starting with DD_MM_YYYY = TODAY()-29 up to DD_MM_YYYY = TODAY()-1.What I need is a Macro that I can run on daily basis from an empty workbook which must:- 1st gather all the data from all the CRONs into one unique 2 columns auxiliary list1 and arrange the data by Column A; if there will be values on column A which appear more than once in the CRONs, they must also appear more than once in the auxiliary list1.- on a 2nd phase, this auxiliary list1 must be processed as follows: * the already existing unique values by column A must remain as they are * the values appearing more than once by column A must be turn into a unique vale by comparing the values on colum B and keeping only the row with the MAX number on column B- on a 3rd and phase, all the rows where t... Read more

Answer:Excel Macro to find data that fits Patterns?

unga msg a padichu enaku paithiyame pidichuduchu ya.... very breaf

2 more replies
Relevance 68.06%

I have a spreadsheet with 14 columns. Twelve of the columns contain categories of data that correspond to the entries in the other two columns. I need to change the list so that each item in each category occupies its own row, as follows:Eg.From this:col1 col2 category1 category2 category3 etc...aaa bbb $55 ccc ddd $44 $66To this:col1 col2 category amountaaa bbb 2 $55ccc ddd 1 $44ccc ddd 3 $66Can anyone assist?Many thanks,jeannie

Answer:Excel macro - column data to multiple rows

You could write a macro to do this, but if it's a one time excercise, it might be easier to do it manually. Turn on filters, one by one for each of the category columns; choose non-empty then hide non-relevant columns, copy and paste the results to a new sheet. Let me know if it requires further explanation (or a macro).

13 more replies
Relevance 68.06%

I have a excel file like below.

Column1 |Column2|Column3|Column4|Column5|Column6|Column7
Row 1 EEEE 1 2 3
Row 2 4 5 6

I want to move data in row 2 (4,5,6) to Row 1 columns 5,6,7.

Could you help me with an excel macro to automate this as i am working with a large number of records like this in one excel sheet. i.e, i want to select the sheet and move data in every 2nd row to the columns in row above at the end of columns in that row.

your assistance is greatly appreciated.

thank you
 

Answer:Excel Macro to Move data in Rows to column

8 more replies
Relevance 68.06%

Ok, first of all I'm new to your site and WOW! I am incredibly impressed with the wealth of knowledge I've come across while searching through various forums! I've already found all kinds of great macros and ideas that will make my workload a lot easier. That being said, I have a problem with efficiently sorting some data and I hope one of you macro gurus can assist :)I've found several macros that do something similar to what I'm looking for, so hoping to get something a little more specific. Basically, I have some weather equipment that monitors up to 5 things in the air and then transmits data to my computer via radio, and spits out text files that I then copy into excel. It creates one text file for each thing I'm monitoring. The format is:Date (mm:dd:yy:hh:mm:ss), WhatIsMonitored, Unit#, ConcentrationSo for example if I'm using this equipment to monitor the concentration of oxygen in the air over the course of a couple minutes using just one unit (and by unit I mean the machine that is doing the monitoring), it will give me something like:09/01/2010 17:02:55,O2,U_10_O2,20.90000009/01/2010 17:03:09,O2,U_10_O2,20.90000009/01/2010 17:03:25,O2,U_10_O2,20.90000009/01/2010 17:03:40,O2,U_10_O2,20.90000009/01/2010 17:03:55,O2,U_10_O2,20.90000009/01/2010 17:04:10,O2,U_10_O2,20.90000009/01/2010 17:04:25,O2,U_10_O2,20.900000So for in this case it's not too much trouble to just copy the text into Excel, then use the "text to columns" feature to put it in columns.The problem I'... Read more

Answer:excel 2007 macro to sort data to new sheet

After you use the text to columns feature, I assume your data looks like this:
A B C D E
1 09/01/10 17:02:55 O2 U_10_O2.txt 20.9
2 09/01/10 17:03:09 O2 U_11_O2.txt 20.9
3 09/01/10 17:03:25 O2 U_11_O2.txt 20.9
4 09/01/10 17:03:40 O2 U_11_O2.txt 20.9
5 09/01/10 17:03:55 O2 U_12_O2.txt 20.9
6 09/01/10 17:04:10 O2 U_12_O2.txt 20.9
7 09/01/10 17:04:25 O2 U_13_O2.txt 20.9
This will probably need some tweaking, but it might get you started:Sub SplitSheets()
Dim ws As Worksheet
Dim lastDate, srcRw, dstRow As Integer
Dim newdate, wsName As String
'Determine last row with data
lastDate = Range("A" & Rows.Count).End(xlUp).Row
'Loop through data
For srcRw = 1 To lastDate
'Remove slashes from dates
newdate = Month(Cells(srcRw, 1)) _
& "-" & Day(Cells(srcRw, 1)) _
& "-" & Year(Cells(srcRw, 1))
'Build worksheet name
wsName = newdate & " Unit " & Mid(Cells(srcRw, 4), 3, 2)
'Create sheet if it doesn't exist
On Error Resume Next
Set ws = Sheets(wsName)
On Error GoTo 0
If ws Is Nothing Then
Sheets.Add after:=Sheets(Sheets.Count)
ActiveSheet.Name = wsName
End If
'Copy row to next open row in corresponding sheet
dstRow = Sheets(wsName).Cells(Rows.Count, 1).End(xlUp).Row + 1
Sheets(1).Cells(srcRw, 1).EntireRow.Copy _
Destination:=Sheets(wsName).Cells(dstRow, 1)
Set ws = Nothing
Next
End SubClick Here Before Posting Data or ... Read more

10 more replies
Relevance 68.06%

Hi, I would like to thanks in advance for someone who help me.The raw data on my excel file is a list of pilots taking different training courses. I would like to filter in terms of the name of each course (column F - Description), and copy the filtered data to new sheet. Then rename the new sheet created based on the name of the course.So, if there are 15 courses, there will be 15 new sheets created.The course number may be increased or decreased in the future.Is there anyway for a macro to do that? Here is the sample dataCol1 Col 2 Col3 Col4 Col5 Col6 Col7 Col8RECRU EMPLOYEE_NAME EMPLOYEE_ID GROUP_TYPE REG_QUAL DESCRIPTION LAST COMPLETED NEXT XXX XX 100 XXX XXX Abc XXX XXXXXX XX 100 XXX XXX Abc XXX XXXXXX XX 100 XXX XXX Def XXX XXXXXX XX 100 XXX XXX Gih XXX XXX

Answer:Excel Macro, Filtering, Copy data, Rename

Hi,Here is a macro which will create new worksheets for each course and will copy the relevant records to the appropriate Course worksheet.The macro starts with a pop-up asking if you want to run this to just add new data, or to re-run the whole thing from the start - appropriate if you have updated source data that has already been copied to individual course worksheets.The macro identifies course worksheets by using the word "Course" and adding the text from column F to it.The Word "Course" allows the macro to identify worksheets that contain Course data.When the macro has run, it puts the word "Copied" at the end of the data that has been copied.Add new data to rows following "Copied"When the data is updated, the word "Copied" will automatically be moved to the end of the data.I suggest that this macro is attached to a button embedded on the worksheet containing your source data.You haven't said what version of Excel you use, so I have included instructions for Excel 2003.Excel 2007 or later is slightly different, in terms of adding the button, and the name of the button inside Visual Basic.If you have Excel 2007 or Excel 2010 and need more help, please ask.(Note: VB macros don't work in Excel 2008 for Mac)On the source data Worksheet, create a command button from the Control Toolbox toolbar.(If this isn't visible, right click on an existing toolbar and check the Control Toolbox).Select the button Icon and draw a buttonRight-click the button and select Command Button - Edi... Read more

2 more replies
Relevance 68.06%

I am trying to create a macro that searches for a range of dates by prompting the user for a start and end date and then searches a specific column by asking the user to enter the column header title. I then want to copy the data from that row for 4 specific columns called LOB, Profile, FirstName, and LastName and paste it in a new workbook. The remaing data in that row should not be copied. I have limited VB knowledge and looking for somebody to help. Thanks!

Answer:Excel Macro to copy user specified data to new worksheet

re: "I have limited VB knowledge and looking for somebody to help."Does "limited knowledge" mean that you can take some generic code and modify it to fit your specific needs (change search ranges, sheets names, etc.) or are you looking for a complete and working macro?If it's the former, I can throw something together. If it's that latter, I would need some more specific information, like what columns the dates are in, exactly where should the data should be pasted, etc.As it stands now, I'm a little confused by a few of things.1 - Your subject line says "copy user specified data to new worksheet", the text of your post says "paste it in a new workbook" As I'm sure you know, those are very different things and the code required will be very different.2 - You said "by prompting the user for a start and end date and then searches a specific column by asking the user to enter the column header title."Does that mean that you have dates in more than one column and the code will need to know which column to use each time a search is done?3 - Will multiple rows need to be copied for each search or will it be a single row based on a single date that will be found based on the start and end dates. In other words, will there typically be more than one date found between the start and end dates?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

4 more replies
Relevance 68.06%

I'd like to create a macro which creates a new MS Word document in the same directory as the excel book which copies specific data from an excel worksheet into the new document. The items contained within the cells should appear as a bulleted list on the word document, not a table.

Is this possible?
 

Answer:Macro to Export Excel Data to New Word Documet

I'm not a Word macro person at all..But I'm thinking (quick and dirty) you could do this with mail merge. Don't use the address part just 'insert merged' fields...Your 'cells' would have to be in the same row in excel.

There are also excel to word conversion programs(google). I have never used one. If your data was in Access a 'Report' would suit your needs. Also a script that reads the excel file and writes to file and saves as .doc might do this also.

Going to word 'for the sake of being in Word' seems counter productive but management wants what management wants.
 

1 more replies
Relevance 68.06%

I'm manually entering payroll data and I feel certain this process could be automated.In one spreadsheet I have the list of employee names and IDs. In another sheet I have the payroll schedule. Each employee ID needs to be copied next to the 21 pay dates in the calendar year. That process repeats for every employee. I understand how to record a macro (what to click) but don't know how to identify mistakes when my recording doesn't do what I intended.How do I create a macro that copies information from one cell in spreadsheet one 21 times down a column in spreadhseet two before moving onto the next cell in spreadsheet one?

Answer:How to write an excel macro that copies data between sheets

re: I understand how to record a macro (what to click) but don't know how to identify mistakes when my recording doesn't do what I intended."As you probably realize, the macro recorder creates very specific code which will basically do nothing more than repeat the steps you took while creating it. To make matters worse, the code is often bloated and inefficient. It just about always need to be cleaned and modified.One place to start is by reviewing the steps detailed in this tutorial:http://www.computing.net/howtos/sho...These debugging techniques will not only help you "identify mistakes" but it can also help you learn how to write VBA code. By using the debugging techniques discussed, you can reverse engineer code that you find in forums such as these as means to understand how the code does what it does.re: "How do I create a macro that copies information from one cell in spreadsheet one 21 times down a column in spreadhseet two before moving onto the next cell in spreadsheet one?"Without the specifics related to your spreadsheet layout, the best we can offer is a generic solution. Perhaps the following code will help you get started, especially if you use the debugging techniques from the tutorial to help you follow along as the code does it's thing.Let's say you start with this in Sheet1:
A
1 Tom
2 Bob
3 SueThis code will place Tom in A1:A21 of Sheet2, then place Bob in A22:A42, etc.
Sub Copy21Times()
'Determine last Row with data in Sheet 1 Column A
lastR... Read more

2 more replies
Relevance 68.06%

Hi I am new to Excel macros, I need helpwith the following automation:I am trying to copy data from the main spreadsheet name "PMO Report" where we have 5 columns D-H and rows 10-114 paste it into different sheets based on the project name in column H. All projects except for the project name TM needs to be copied to the spreadsheets. There are a total of 6 different projects in column H. Project names are (FCS,FCD,FCT,FPD,MSS,TM). So basicly i want to extract whats in "PMO Report" columns D-H into seperate sheet based on the project name except for TM. Thanks in advance for your help...Regards. Moe

Answer:Excel Macro to move data to separate sheets

Hi Moe!When posting in a help forum, please try to use a subject line that specific to the contents of your post.If everyone used generic subject lines like "Excel Macro" or "Excel Help" (something we see a lot!) then we couldn't tell one question from another and things would get very confusing around here.I fixed the subject in this thread, but we'd appreciate it if you could keep that in mind for future posts.Thanks!DerbyDad03Office Forum Moderator

4 more replies
Relevance 68.06%

Hi,

I'm looking to set up a macro to do the following:

Open up a workbook called Works Order Register
Find my Works Order on the register by matching the WOnumber (I8) and Contractor name (C1735) from Works Order workbook.
Once found copy various data e.g cell I1735, I1737 etc across to columns D, E etc on the register against the corresponding row found in the previous step.

I've got parts working ok, but not the whole thing together.

Thanks for help.
 

Answer:Excel Macro to lookup reference and copy data

12 more replies
Relevance 68.06%

If you check the file attached.

please can you help me in moving data with duplicate names to have the 2nd and 3rd email address moved to a new column and delete the row

need an excel macro to automate this as i am working with a large number of records like this in one excel sheet. i.e, i want to select the sheet and move data in every 2nd row to the columns in row above at the end of columns in that row.
 

Answer:Excel Macro to Move data in Rows to column

I'm unable to understand the entire requirement, but for moving the records with duplicate names, I've written few lines. This will cut the duplicate record rows (Consider "Pupil Forename" for removing)from the "Report Data" and will post into "Sheet3". Before running this macro please insert "Sheet3". Let me know your requirement, hope I will be able to resolve it out. Thanks!

Code:
Sub test()
Sheets("Report Data").Select
Dim trow As Long
trow = ActiveSheet.UsedRange.Rows(ActiveSheet.UsedRange.Rows.Count).Row
For i = trow To 1 Step -1
If i = 1 Then
Exit Sub
End If
If Cells(i, 1).Value = Cells(i - 1, 1) Then
Rows(i).Select
Selection.Cut Destination:=Sheets("Sheet3").Range("A65536").End(xlUp)(2)
End If
Next i
End Sub
 

2 more replies
Relevance 68.06%

Sirs,I have a workbook in excel with 3 sheets. Sheet 1 ("COLUMNAR")ID DATE PAGE NO OR NO NAME OF PAYEE AMOUNT SECTION PARTICULARS 1 1/5/11 PAGE 1 0000701 JOEY BANTOG 26.00 DRY GOODS Sheet 2 ("SAMPLE") Page 1 Serial No. Amount(From - To) PayEE Acct. Code Description A B C D EI need to automatically transfer Serial No, Payee and amount to Sheet Named "Sample" which is the report form leaving Acct Code blank however using the Page No as the ref cell Sirs please help me my job is at stake with this report. Thanks

Answer:Macro Code to copy range of data in excel

Please repost your data after reading the How To referenced in the following line:Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies