Over 1 million tech questions and answers.

Solved: Excel if cell contains vlxp then put matching cell data in current cell

Q: Solved: Excel if cell contains vlxp then put matching cell data in current cell

In cell j, I have formula =IF(SUMPRODUCT(ISNUMBER(SEARCH("VLXP",K2:AB2))+0)>=1,"Yes","No") that returns yes or no if VLXP is contained in any cell K2 through AB2 and it works correctly. What I would really like to do is then put into cell j the entire matching cell content or if not found return n/a. Is there a way to accomplish this maybe with VBA?

RELEVANCY SCORE 200
Preferred Solution: Solved: Excel if cell contains vlxp then put matching cell data in current cell

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.)

A: Solved: Excel if cell contains vlxp then put matching cell data in current cell

Read other 6 answers
RELEVANCY SCORE 172

hi, i have 2-excel cells in the same sheet, both contain manually entered numbers; cell-2 changes frequently; if the existing entry in cell-1 is < than the new entry in cell-2, cell-1 should immediately reflect this new value. how do you create this formula?
 

A:Solved: excel-replace content of cell-1 if cell-2 is > cell-1

Read other 8 answers
RELEVANCY SCORE 164.4

I have a sheet set up with the list with the description (text) in column B, and summary scores (numerical, percentage) in column D. I want to do a summary row at the top of the sheet that pulls the data from the B cells, based on the lowest 3 values in column D.
 
I plan on using the formula =SMALL(D7:D32,1) (with d7:d32 being the list of percentages), to figure out the lowest 3 values. But the formula just pulls the summary score, not the description. I want to pull the description into but I am at a loss.
 
I am using excel 2013 on windows 10. Any help would be appreciated.

Read other answers
RELEVANCY SCORE 164.4

I have a sheet set up with the list with the description (text) in column B, and summary scores (numerical, percentage) in column D. I want to do a summary row at the top of the sheet that pulls the data from the B cells, based on the lowest 3 values in column D.
 
I plan on using the formula =SMALL(D7:D32,1) (with d7:d32 being the list of percentages), to figure out the lowest 3 values. But the formula just pulls the summary score, not the description. I want to pull the description into but I am at a loss.
 
I am using excel 2013 on windows 10. Any help would be appreciated.

Read other answers
RELEVANCY SCORE 156

I'm working on a spreadsheet at the moment which displays a range of cells all containing values referenced from another spreadsheet (within the same workbook). This system works fine.

Every day, the original worksheet is updated. So, it has fields already arranged up until the end of the year. A row for every date. Now, needless to say, rows for dates in the future contain no values, and so when the spreadsheet I am working on now references those cells, it displays "$0.00" (which is correct, given I am dealing with financial figures).

Now, all of that works as expected, however, on the spreadsheet I am working on, all of those figures are displayed in a line graph. This line graph, at todays date, shows an enormous drop given that the fields for the rest of the year all show a zero balance.

What I need to do, is to get the remainder of those fields (every field that says "$0.00") to not display anything at all. So, if the value is $0.00, it would not display a value at all, and therefore not show anything on the graph.

Can someone tell me how I can achieve this? I'm sure it can be done with an "if" statement, but I'm not sure how to structure it.

Any help would be greatly appreciated.
 

A:Solved: Remove Cell Value If Cell Value Is Zero (Microsoft Office Excel 2007)

=If(a1="","",Sheet1!a1) and drag it down.

Where a1 is the first cell in spreadsheet you are working on, and sheet1!a1 is the sheet within workbook containing figure.

Not sure if the graph will recognize the "blank' cell as blank or "0"
You could try that

Pedro
 

Read other 3 answers
RELEVANCY SCORE 153.6

Using Excel 2003 in Windows XP

I would like to use the contents of one cell as the destination location for copying data.
For example
I have 2 worksheets 1) Results and 2) info
in info
A1 = 'ABC'
C1 = 'Results!O54' < this is calculated based on other data in sheet.

Using a macro, I'd like to copy contents of A1 to cell location 'Results!O54' more specifically to where ever C1 points... C1 will change based on other data in info sheet.

The macro record for action looks like this (but I would like the 'O54' to be based on contents of C1 which changes)
Range("A1").Select
Selection.Copy
Sheets("Results").Select
Range("O54").Select
ActiveSheet.Paste
Sheets("info").Select

There is more to it then that but I think this is where I am stumped.
 

A:Solved: Excel: Uses contents of Cell to select a cell

Sheets("info").Range("A1").Copy Destination:=Sheets("Results").Range(Sheets("info").Range("C1").Value)
 

Read other 3 answers
RELEVANCY SCORE 146.8

I have a sheet with 2 simple columns: Date and Price. I have imported the dates (##/##/####) and the prices ($###,###) by copy/pasting from the search results given to me by a niche database program I use. When the cells paste in, they all have the format "General".

When I try to format the "date" column into dates, it _does_ change the format as far as the cell is concerned, but the content of the cell doesn't adapt to the new format. For example, I have the date as 3/05/2001 and when I change it to a date format of MMM D, YYYY the content should change to March 5, 2001 but it doesn't. It is as if all the cells are forced to stay as text regardless of what the formatting is that I'm applying.

Same problem with the price column: if I change the format to include 2 decimal points, that format does apply to the cells, but the content of each cell remains without a decimal or anything following, as if the content is just text.

I have like 1000 rows in each column, and plan to do this analysis of the database's results frequently, so I'm hoping the answer isn't just to retype the data. There's got to be a way to copy/paste or export or something. Maybe I could copy/paste into notepad first to scrub out any formatting or locking from the niche database program?
 

A:Excel 2007 Cell Values Won't Take On Characteristics of Newly Applied Cell Format

Good news: Made some progress. In thinking that maybe each value had the textual single-quote forcing it to act like text, or maybe if I find/repaced all the dollar signs and commas that had been imported, I accidentally discovered that each and every value in my imported columns has a following space!

Bad news: Seems like Excel has a bug that thinks that if I say "Find=[singleSpace]" "Replace=[null]", then I should be given an error saying "Excel cannot find any data to replace". I think I'm doing the find/replace correctly because it worked on the dollar signs and commas.

Anybody know a workaround for the bug?
 

Read other 1 answers
RELEVANCY SCORE 146.8

I'm attempting to write my first macro for an Excel 2003 workbook. I'm not completely code illiterate (I've got moderate skills with AutoLISP), but I'm new to VBA and am not yet an Excel power user, so please be gentle.

The macro I want to write will:
check that the selected cell's content is underlined before proceeding
copy the content of the currently selected cell into an external plain text .log file
.log file lines should be: year/month/day - time - username - cell contents
.log file names will probably need to be generated
clear the cell's content and formatting (particularly underline and text/background color)
Here's what I have so far:
Code:
Sub Unpost()
If Selection.Font.Underline = True
Then Selection.ClearFormats And Selection.Clearcontents
Else
If MsgBox("The selected cell is not underlined...are you sure?", vbOkCancel) = vbOk
Then Selection.ClearFormats And Selection.Clearcontents
Else Exit Sub
End If
End If
End Sub
If I've written it correctly, it should currently do everything except log the cell contents. This, from what I've seen, is going to be the trickier part. I intend to use this macro 50+ times per weekday, so at some point the .log files will get too long to be useful, so I assume it will need to automatically create new logs (perhaps "year-month.log"). I've seen some useful info about appending to an external log here and here, ... Read more

A:Excel 2003 macro: log contents of selected cell, clear cell

You need to use the "File Scripting Object" to create and/or append text to a file. I've included a link below to get you started. If you are unable to figure it out on your own let me know and I'll write the code for you.

http://www.virtualsplat.com/tips/visual-basic-fso.asp

Rollin
 

Read other 1 answers
RELEVANCY SCORE 146

Using EXCEL, I have a need to copy the cell contents from upper cells in col. A down a few rows in col A. There are various changes in data in col A as you will see below. The periods in the following info are used as placeholders only. B1, A2, A3, A4, etc. are blank. I need a formula because I have 60,000 records in the spreadsheet. Thanks in advance.

Here is how the data looks now.

....A.....B
Apple.........
..........Fire
..........Ice
..........Snow
Peach
..........Sleet
..........Rain
..........Fog

Here is how I want the data to look

...A ...........B
Apple
Apple.......Fire
Apple.......Ice
Apple.......Snow
Peach
Peach.......Sleet
Peach.......Rain
Peach.......Fog
 

A:[Excel] Copy And Paste Upper Cell To Lower Cell

With the workbook open press ALT + F11 to bring up the Visual Basic Editor. Once the VB editor opens, click INSERT --> MODULE and paste the code below into the blank module. Close the VB editor and select the first cell in column A containing your data you want to copy down. Click TOOLS --> MACRO --> MACROS and select the macro from the list and run it. This macro will copy all your data except for the last value in column A because without actually seeing your workbook, I have no way knowing which line to stop at. Therefore, the code will end when it reaches the last value in column A.

Code:

Public Sub CopyData()

Do Until ActiveCell.Row = Cells(Rows.Count, "A").End(xlUp).Row

ActiveCell.Copy
ActiveCell.Offset(1, 0).Select

Do Until ActiveCell.Value <> ""
ActiveSheet.Paste
ActiveCell.Offset(1, 0).Select
Loop

Loop

End Sub


Rollin
 

Read other 2 answers
RELEVANCY SCORE 146

Hello,

I cant seem work out a solution for what I'm trying to do. I have an Excel workbook that has multiple sheets. On sheet 1 i want the data from cell "G3" to be copied onto sheet 2. But i want the location on sheet 2 to be based on whatever was entered into cell "D3" on sheet 1.

For example: Sheet 1, cell D3 I have the name John, in cell G3 i have 68. I want "68" to be pasted in sheet 2 in cell B26.

But if the name in Sheet 1 cell D3 is Suzie, then I want G3 to be pasted in Sheet 2 in cell D26. So I would need to identify the paste location for each person.

I want the data to paste to the next cell so that the next entry can be pasted below the last entry for that person (for John the first entry would go into cell B26, then the next entry would go into cell B27 and so on).

But i want it to be a specific range, i dont want data to be pasted past 20 cells (cell B45). If possible a message box could be created to let the user know that the max is reached.

I would appreciate anyone's help with this as i have been struggling for awhile to try to get this. Thank you
 

A:Excel - Copy paste cell into range based on another cell

Read other 12 answers
RELEVANCY SCORE 142

I have two cells, Cell "A" and cell "B", that have a formula in each. Cell "A" has a value that is correct and Cell "B" has a value that is correct. I now have a third cell (cell "C") with a formula that takes the values of cell "A" and cell "B" and multiplies them. The value of the product is wrong in cell "C" as compared to a value performed by a calculator. Cell "C" reports 51,550.64 whereas the calculator reports 51,540. What is the problem.

Thanks
 

A:Excel cell to cell multiply problem

I'm willing to bet that the number you are entering into the calculator are rounded off while the number that Excel is using is not truly rounded off. Even though Excel may display a certain number in a cell due to its format, it is probably using the true value of the number which probably includes several decimal places. What numbers are showing in cells A and B? How are cells A and B formatted? What happens if you increase the number of decimal points in these cells...do the cell number become larger? If so, then Excel is likely using the true values of the cells instead of the display values in its calculations. Provide details of how you are obtaining your cell values so we can confirm that this is happening.

Try the following

TOOLS --> OPTIONS and choose the Calculation Tab. Put a check in the box marked "Precision as Displayed."
NOTE: This will affect all other calculations on the workbook causing changes to other values on the sheet!

Rollin
 

Read other 3 answers
RELEVANCY SCORE 142

Is there a way to copy a col of formula's/math cells to a new col without excel modifying the coordinates?

Scenario: 150 cells of diff equations "located from a1 thru a150" you wish to move to d1 thru d150.

Problem: Excel modifies the coordinates of each pasted formula rendering garbage.

Individual f2, highlite,copy and then paste takes too much time if there are thousands of formulas to move.
thanks, nt
 

A:Copy cell to cell without excel modifying

Use absolute instead of relative references, ie:

$A$1:$A$150

Rgds,
Andy

EDIT: better explanation. You have 5 in A1, and the formula =A1 in B1. If you copy B1 to C1, C1 will read =B1. But if you make B1 =$A$1 and then copy it to C1, it'll hold.
 

Read other 1 answers
RELEVANCY SCORE 142

I have an Excel 2010 workbook comprising a simple organization membership list, consisting of names, addresses, etc., for nearly 2,000 members, grouped into 5 chapters' sheets, in a single Excel 2010 file. Every time I sit down to enter updates for any member, or add new members, etc., I always start by saving my most recent version of the workbook with the date I last updated it in the filename, and then when I finish my updates for the day, I save the current day's updated workbook with the current day's date in the filename, etc. So after a while, I've got quite a stack of versions of the same workbook, albeit with slightly different data in some of the cells, from version to version.

Near the end of the year, it'd be neat to be able to compare the beginning and end of year versions, cell by cell, to see what changed.

Ideally, I'd like to sort of "subtract" one workbook from the other, cell by cell, and display something in the results that shows cells that differ btwn workbooks and cells that don't.

Obviously, I could just print the two versions, and plow through them both, side by side. But they're nearly 2,000 rows deep, all things considered, and with all the data we compile for each member, each row goes up to column AT! That's a lotta data to compare visually cell by cell.

Is anything like what I'd like to do possible?

Thx.

A:Can I compare 2 Excel spreadsheets cell by cell?

I think this might help if I read this correctly. I used this before to compare three lists I made a long time ago, then when I needed to update them I didn't want to sift through hundreds of entries.

Compare Two Lists in Excel - Easy Excel Tutorial

From MS https://support.microsoft.com/kb/213367

Also 4 Ways to Compare Data in Excel - wikiHow

Read other 1 answers
RELEVANCY SCORE 137.6

I'm running a spreadsheet for yearly budget using EXCEL 2010. Everything has run smoothly until today. If I enter values on one sheet, it shows up on all sheets. I've gone through the settings for EXCEL but cannot find a setting to change this. Anyone have a suggestion on how to correct this?

Tech Support Guy System Info Utility version 1.0.0.1
OS Version: Microsoft Windows 7 Professional , Service Pack 1, 64 bit
Processor: Intel(R) Core(TM) i7 CPU 860 @ 2.80GHz, Intel64 Family 6 Model 30 Stepping 5
Processor Count: 8
RAM: 8183 Mb
Graphics Card: ATI Radeon HD 4600 Series, 512 Mb
Hard Drives: C: Total - 76216 MB, Free - 8485 MB; D: Total - 1907599 MB, Free - 1891982 MB; E: Total - 476809 MB, Free - 409377 MB; G: Total - 2861575 MB, Free - 2680780 MB; J: Total - 238472 MB, Free - 107677 MB;
Motherboard: ASUSTeK Computer INC., P7P55D-E PRO, Rev 1.xx, 103822980000259
Antivirus: ESET NOD32 Antivirus 4.2, Updated and Enabled
 

Read other answers
RELEVANCY SCORE 136.4

I selected a cell, and then recorded a macro when I copied the cell, moved down to the cell below it and pasted it. But when I select another cell, and then run the macro, it goes to the initial cells I did when I recorded the macro.

So is there a macro where I have selected a cell, whatever cell I decide, and then run the macro, and it copies the cell selected and paste it to the cell below the cell that was copied?
 

A:Solved: Macro to Copy and Paste From One Cell to Cell Below

Read other 16 answers
RELEVANCY SCORE 136.4

Hello,

I am attempting to clear 2 cells, based off the value of another. I am pretty sure the code is correct, because it works within another Macro. Thanks.
Code:
Sub REMOVE()


Dim p As Long
p = Cells(Rows.Count, "a").End(xlUp).Row


For i = 1 To p
Range("k2").Select
If InStr(1, Range("k" & p), "None") > 0 Then Range("L" & p) = "" And Range("M" & p) = ""
'If no Issue, Location/Obsevations should be blank
Next i


End Sub


 

A:Solved: Clearing Cell Contents Based off other Cell

hi
try this variation;
Sub REMOVE()

Dim p As Long
p = Cells(Rows.Count, "a").End(xlUp).Row

For i = 1 To p
If InStr(1, Range("k" & i), "None") > 0 Then
Range("L" & i) = ""
Range("M" & i) = ""
End If
'If no Issue, Location/Obsevations should be blank
Next i

End Sub
 

Read other 2 answers
RELEVANCY SCORE 134.8

I work with Excel 2007. If under column A, I have 900 names of Restaurants, and under each name of restaurant, is a one-line address of the restaurant, what should be done so that the address can be moved to the cell to the right of the restaurant.

For example

This is the original data:

Column A
AAA Restaurant
AAA address
BBB Restaurant
BBB address
CCC Restaurant
CCC address
This is the desired result

Column A Column B
AAA Restaurant AAA address
BBB Restaurant BBB address
CCC Restaurant CCC address

Thanks is advance
 

A:Solved: Excel 2007 Move Data to Another Cell

Read other 7 answers
RELEVANCY SCORE 134.8

Hi,

I want to add manually data\formulas to my excel sheet and I get a popup error message:

please see the attached file.

ps: I unprotected the sheet.

Where do I set the flag to allow to add data to my cell. It doesn't allow me to add in some cells. Why is that?.. Some work and some dont..

Thank you
 

A:Solved: error adding data to excel cell.

The cell is "protected" with Data Validation. Activate the cell and go to Data/Validation and either delete the Settings or click the Error Alert tab and set the Style to Warnng or Information.
 

Read other 2 answers
RELEVANCY SCORE 134.8

I have an Excel 2007 spreadsheet with 9,000+ entries. Column F contains text data (50-60 characters), which will include a 10 character serial number in the format "xxnnnnnnnn". The first two characters will always be alpha and the next eight will always be numeric.

I need to find each of these 10 character strings and copy them to column G of the same row. I do not want to do this manually if at all possible. Is there an excel formula that can do this type of function?

Your assistance is very much appreciated.

Mark
 

A:Solved: Excel - Find data, Copy to new cell

Read other 16 answers
RELEVANCY SCORE 134.8

Hi all,
I am having problems with code.
What I want to do is add a check mark to the right of an integer in a cell when I double click on the cell. I want to repeat the check mark addition indefinitely after the integer (integer, check mark, check mark, check mark, check mark, etc). The check mark I want is the uppercase letter "P" in Windings2 font.
I want to do this in any cell in Column C (3) that already contains any integer between 1 and 1000.
I am basing this on code that I already used in another post that I had: Excel Input box question, posted on July 2. http://forums.techguy.org/business-applications/1102607-excel-inputbox-question.html#post8727301
What I'm having problems doing is defining the integers using Dim code. I want to define "check" as any integer between 1 and 1000. I think once I get the syntax right, the code (hopefully) will work.
Any help would be greatly appreciated.
Thanks!
 

A:Solved: Excel DoubleClick to add additional data to a cell

Hi

try this and see if it suits....
Code:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

If Target.Row < 1000 And Target.Column = 3 Then
Cancel = True
If Target.Value > 1 And Target.Value < 1000 Or Right(Target.Value, 1) = "P" Then
ActiveCell.FormulaR1C1 = ActiveCell & "P"
Selection.Font.Name = "Calibri"
For i = 1 To Len(ActiveCell)
If Mid(ActiveCell, i, 1) = "P" Then
With ActiveCell.Characters(Start:=i, Length:=1).Font
.Name = "Wingdings 2"
.FontStyle = "Bold"
End With
End If
Next i
End If
End If
End Sub

 

Read other 3 answers
RELEVANCY SCORE 133.6

I have an excel sheet with two tables for customers to know which products the customer is using based on a Contract table.

The enclose sheet has two tables:
1. Customer
2. Contracts

All what I need is to fill the columns of "Product A", "Product B" and "Product C" of every customer looking at the table "Contracts" where the data is available based on the "Customer ID"

How can I do it?
 

A:Solved: MS Excel / Filling a cell with YES based on data from another sheet

I would just use a simple countifs formula to check if the customer ID and Product type match (ie the count of matches is greater than zero)
See attached.
 

Read other 3 answers
RELEVANCY SCORE 133.6

i have a spreadsheet that updates with data from a number of different sources. i need to filter only the relevant data that i need. i'm almost there but need to find out how to pull 2 more pieces.

in the attached spreadsheet the cells i need are in column R and T. I need to know the corresponding "name" and "size" of the data that is in column S.

unfortnuately the actual values don't show up in the spreadsheet b/c they are live data feeds but the formulas written up until now are still there.

in a nutshell what i'm doing is getting 5 price feeds and i need to filter out which is the highest updated within the last 2 minutes. i actually have the only the price figured out in column S, but i also now which name and how big the size is related to that price.

your help is very appreciated.

regards,
 

A:Solved: excel - data returned based on the value of a specific cell

Read other 10 answers
RELEVANCY SCORE 132

I have an issue if certain cells are blank (not sure if they would be null, blank, empty) to have a macro to input "0" in the cell instead. When I look at the format in excel it's under general.

I currently have the following and it puts nothing in the cell. (or seems to be nothing in the cell) I can manually enter a "0"(zero) in the cell and it shows.....

Sub Addifblank49()
Sheets("BPS").Select
Range("c16").Select
Var = Selection.Value
If IsNull(Range("C16").Select) Then Var = "0"
End Sub
I've tried using val instead of var and it won't let me. I'm not real familiar with VBA so any help would be awesome!!
 

A:Solved: Excel Macro - enter in data in cell if Null/Empty

Read other 10 answers
RELEVANCY SCORE 132

Hoping to get some help on this question please. I have reviewed the forum and found a similar post, but the sample data is more predictable than mine and the Macro posted doesn't work on my data. See post "Excel Macro to Move data in Rows to column" 28-Aug-2008, 05:47 AM".

On my data, I would like to be able to take the yellow row, and move the data up to the previous row starting in column "R". The rows I would like on the same line, all begin with a date. I don't know how to make a looping Macro that will identify the "date lines", and take the "second date line", and move it to the "first date line's" row.

Any help would be appreciated.
I have attached some sample data. (I hope that's okay?!)

Thank you!!!!
Christine

PS - The range on data varies.
 

A:Solved: Excel Macro to sort data by date, then move to new cell

Christine,

this macro below works well with the sample data.
Code:
Sub sorting()
Dim Rng As Range, c As Range, i As Long
Set Rng = Range("A:A").SpecialCells(xlCellTypeConstants, xlNumbers)
For Each c In Rng
i = (i + 1) Mod 2
If i = 0 Then
With c.Resize(, 15)
.Copy .Offset(-1, 17)
.ClearContents
End With
End If
Next
End Sub

How it works:
1. Takes all those cells in column A of the active sheet that contain numbers. (Dates are actually numbers, only formatted to look like dates.)
2. In a loop, it takes every second cell of the set of cells selected in Step #1.
3. Takes a 15 cells wide region starting with the cell selected in Step #2, and copies it to the region starting with the cell positioned one row up and 17 columns to the right.
4. Deletes the content of the original 15 cells wide region.

Caution:
1. If there are any numbers in column A besides dates, then the algorithm is wrong and the macro will fail.
2. If the dataset in the second date line is wider than 15 cells wide then the rest will remain in place. But the macro can be easily updated, just change the Resize line.
3. Don't run it twice on the same worksheet.
4. Always make a backup copy of your data before running the macro, because it is not Undo-able.

Jimmy
 

Read other 3 answers
RELEVANCY SCORE 131.6

How can I do it?

I basically need THIS to work, but I can't compare two items in the same if apparenlty...

=IF(K12>2400 and K13=0,2400,K12)

I am comparing the totals of daily hours to see if regular hours ended up over 40 (2400 minutes) and whether or not the daily overtime is still zero before I use the regular hours to figure overtime in a timecard system.

Unfortunately that won't work, nor does using & beween because then it concatenates it and always ends up false.

Help!

- Drake.
 

A:Excel 2007 - need to compare TWO cells to determine a value for the current cell...

Read other 6 answers
RELEVANCY SCORE 128.4

I want to have a range of cells store something. When one of those cells data is changed, I need another cell to show the date of when the cells data was changed automatically. For example: If Someone changes cell B2, A2 will show the date B2 was changed. Or B78 changes, A78 should show what date B78 changed. I need this to happen for the entire column. Is there a way to have this happen automatically? Please help, if you can.
 

A:Changing Cell Info, Date tracks when cell changed

Read other 6 answers
RELEVANCY SCORE 127.6

Hello Tech Guys!

I have an Excel 2003 spreadsheet running on a Windows XP Pro machine that has automatically updated external data. This data is the result of customers submitting a form requesting manufacturing of an item (each item is different and it is a text field). Included in the data (among other things) is the item to be manufactured (D) and the customers e-mail address (H). I'd like to be able to notify each customer separately using their e-mail address in H of the progress of the manufacturing using an automated e-mail. In other words, our manufacturing people have to be able to open the Excel spreadsheet and just click on a drop down box(?) to choose a automated message (e.g. Manufacturing begun, manufacturing step 2 begun, manufacturing complete etc) for the message to be sent to that one customer. The process has to be rather easy (a big red EASY button) as several people will have to use the same process.

I know, this should be done in a real on-line database, but we don't have the money nor the volume. This would be easier than clicking on the e-mail address in the spreadsheet (which launches Outlook and opens an e-mail message) and writing an e-mail to each customer, which is our current way of doing it.

I've looked in various groups and on the MS tech sites without much success. I've found similar things, but quite what I need.

Any assistance would be greatly appreciated! I'm not a programmer and just have been tasked to do this... Read more

A:E-mail cell data from Excel

Welcome to the board.

What "similar things" have you tried already? John W has some code here: on the same page there's a link to Ron de Bruin's site.

The attached contains a stripped-down version of John's code. D2 and J1 have data validation. Select a cell in row 2 & click the "MAIL" button, you should get a draft email with column H value as address ([email protected]), J1 value as subject (i.e. whatever you choose) and column A value as body text (prefixed, i.e. "Dear Fred").

What it doesn't do is actually send, because I've disabled the last 2 lines of code. To see the code, rightclick the "MAIL" button & choose "Assign Macro"; then highlight "SendEMail" & click "Edit".

HTH.
 

Read other 2 answers
RELEVANCY SCORE 127.2

Hi All,

I need an help one excel formula ,i have specific range with prices, but when ever there is a change in value in the range then one particular need to be updated with now() formula. Find below the snap shot of desired data....

Product Changes happened Jan'13 Feb'13 Mar'13 Apr'13 May'13 Jun'13 Jul'13 Sep'13
Apple
Orange
Pineapple
Fruits
In the above data i have values for all product in all months. if there is any change happened then in the changes happened column need to be updated with now() formula.

Thanks in advance...

Vinwin
 

A:Automatic date update in a cell when another cell's value changes (as calculated

Read other 9 answers
RELEVANCY SCORE 127.2

Very limited experience with Excel...have a multi page workbook but can't figure out how to auto format existing text to fit in cells so there is no space either on top or bottom of the cell.

Only way I can get this so far is to manually move the bottom line of the text box up to the bottom of the actual text in box. But this causes the print out to overlap sometimes of the text lines in print view.

Is there a way to 'auto-format' individual cells to fit the text in the cell without leaving alot of space above or below the lines, or top/bottom lines, of the cell.

A:Having problem setting cell height to fit text in cell

When you are in the cell that you want to align with the top, Right Click & select Format Cells & when that opens Click on the Alignment Tab & then you will see Horizontal & Vertical, click on the Vertical drop down arrow & select Top. That will align the text to the top of the cell & eliminate that space.

When you move to the next cell to insert the Dollar amount it will be lined up with the bottom of the text in the previous cell, which is what you want.

Read other 1 answers
RELEVANCY SCORE 127.2

would like to write a macro involving cell references, which changes when the number in another cell changes

e.g if cell = 1, uses b2
if cell = 2, uses b3

please help
 

A:macro help - linking cell reference to number in another cell

Read other 8 answers
RELEVANCY SCORE 126

Attached is an example of what I am trying to do.

I have a sheet called timetable which lists each person and what they should be doing mon-fri (this is an example the proper one goes on for a number of months)

I have a sheet called holidays which lists whenever a person is on holiday and gives the start and end date of that holiday.

Could anybody tell me how I could get it so everything from the holidays sheet is mapped to the correct cell on the timetable sheet? Perhaps some sort of Vlookup?

Thanks in advance.
 

A:Excel: Putting data into correct cell?

Read other 16 answers
RELEVANCY SCORE 126

I'm trying to automate a procedure in excel. Basically, I need to look at Column B and if a certain number appears, I need to add information in Column A and Column C.

So,

| A | B | C |
-------------------------
1 | 9 |
2 | 7 |

Would become,

| A | B | C |
-------------------------
1 X | 9 | Y
2 | 7 |

I tried to create a macro using the Find button, but it would then hard code in my left arrow movement. I need to look through each cell in Column B, and if 9 appears, add X to column A and Y to Column C for that Row.
It's a monthly file and the data changes each month. I've got a macro that will add the header information, change the formats of the cells and such, but I can't figure out how to go to a particular cell, and then move over to the left add information, then move over the right two places and add information, and then continue on again. Can anyone assist?
 

A:Excel VBA, how to enter data into an adjacent cell.

There are a couple of methods one is using the Offset property, but the most useful is to use the
Cells(row,Column) function, because both rows and columns can be manipulated.
This piece of code removes duplicate rows.
Dim lastrow As Long, count As Integer

lastrow = Cells(Rows.count, "A").End(xlUp).Row

For count = lastrow To 2 Step -1

If Cells(count, 1) = Cells(count - 1, 1) Then

Cells(count, 1).EntireRow.Delete xlShiftUp

lastrow = lastrow - 1

End If

Next

But you would probably want to go down the column, so something like this

For count = 2 to lastrow ' assumes a Headings Row
if cells(count, 2) = 9 then
cells( count, 1) = "X"
cells(count, 1) = "Y"
end if
next count
 

Read other 1 answers
RELEVANCY SCORE 126

Hi...
I have a picular requirment. I need to carry cell information to different range. In simple ..What my requirment is...when i click on a hyperlink placed in cell, that not only jump to the given address, it also should carry the cell information to the destination cell.
for example : i have employee number from a1:a5. say ..
a1 - > 100
a2 -> 101
a3 -> 102
a4-> 103
a5->104
if user click on hyperlink 100, it should jump to the destination cell (same sheet or differnt sheet or different workbook) as well as it should carry the information 100 and pate it in destination range.
say if A1 of sheet1 contains hyperlink like this =HYPERLINK("#Sheet2!A10","100"). if i click on this link it should jump along with the information 100.
I dont want to use any VBA CODE. Can we achive it using any excel features or built in formulas??
i used formula in destination cell like =CELL("contents",Sheet1!A1) ..but it doesn't solve my problem because this is static ..Whatever hyperlink i click, it still shows 100 only.
Hope anyone can plese let me know whether is it possible or not ? any alternative solution or ideas ??
Thnks & Rgds
 

A:How to carry cell's data through hyperlink in Excel??

Read other 12 answers
RELEVANCY SCORE 124.8

Hi, all!

I wish to purchase an HP dv5000t series laptop with a 12 Cell Li-Ion battery, but I saw a diagram on the HP site which showed a bulky mass at the back of the laptop, compared to a 6 cell which did not have this. It seems that such a laptop will not be able to sit flat on a desk.

Does anybody know from experience if this will be the case? If so, how bad of an angle is it? Will it interfere with normal use, etc?

Thanks! Your help is appreciated.
 

A:6 Cell Li-Ion Battery vs. 12 Cell (Physical Properties)

If HP sells the battery with the laptop then it'll work. While it may not sit flat that isn't a problem.
 

Read other 3 answers
RELEVANCY SCORE 124.8

Hi Lenovo experts - I am having a strange issue with my new X270 laptop. I have been using it for over 3 weeks now. The X270 came with an integrated Li-Ion 3-cell battery (23 Wh) and also an external Li-Ion 3-cell battery  (23 Wh). With very light usage (just outlook and office apps) and brightness set to 25%, I can barely get 2h-2.5h of battery life. Is this normal? Per the PSREF, 3+3 cell should give me ~13h of battery life.  Anything else I can check? I did a 'battery report' and I see on average 45 Wh of charging capacity when active. However 'Battery life estimates' show between 2h-3h at full charge. 'Current estimate of battery life based on all observed drains since OS install' is showing 3:50.  Do I have a defective battery? Any advice appreciated!

Read other answers
RELEVANCY SCORE 124.8

Re:  Battery # 746641-001(3 cell)  I need to replace the battery for my laptop.  Most of the batteries I'm finding are 4 cell and I need a 3 cell.  What is the diffrence between the 3 and 4 ?  Any help would be appreciated.  Terri

Read other answers
RELEVANCY SCORE 124.8

Hi, Can somebody be able to share whether 6 cell or 9 cell battery is available for Lenovo Yoga 500 14.0 inch laptop in the market?  Thanks.

Read other answers
RELEVANCY SCORE 124.8

Hello,

I am trying to figure out how to get MS Excel to send a few cells of data to an email address. We are a fire department whose dispatch is using an excel spreadsheet as the dispatch log. The goal is for the data to be entered into a few cells. Column H1 would ask to "send page". If 'Y' is put into the cell then an email automatically be with the data in this format:

c1 d1 e1 f1 g1
type;location;street address;details;report #
The email pushes an alert to responders smart phones through an ap.

Thanks!
 

A:Need to send some cell data from Excel to Outlook Email

Read other 7 answers
RELEVANCY SCORE 124.8

Hi:
I have a couple of questions regarding the below code and the attached spreadsheet. What do I have to do to make this macro execute at the time indicated in col m of the spreadsheet? The dates are going to be different for each row.
Also how do I get cell data [a4] [h4] [g4] [m4] [n4] to populate from the worksheet into the email?

Sub Mail_small_Text_Outlook()
'Working in Office 2000-2007
Dim OutApp As Object
Dim OutMail As Object
Dim strbody As String
Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon
Set OutMail = OutApp.CreateItem(0)
strbody = "Andean Funding Closing Document has not been recieved" & vbNewLine & vbNewLine & _
"Andean Tracking Number: [a4]" & vbNewLine & _
"Requested Amount: [h4]" & vbNewLine & _
"Case Number: [g4]" & vbNewLine & _
"Closure Document Due NLT Date: [m4]" & vbNewLine & _
"Staff Coordinator: [n4]" & vbNewLine & _
"Please contact OGL immediately to correct this situation" & vbNewLine & vbNewLine & vbNewLine & vbNewLine & vbNewLine & _
"Judy De Santis" & vbNewLine & _
"Office of Global Enforcement" & vbNewLine & _
"Latin America Caribbean Section" & vbNewLine & _
"Office: 202-307-4609" & vbNewLine & _
"Cell: 202-345-9257" & vbNewLine & _
"Fax: 202-30... Read more

A:Excel 2007 -How do I get cell data to populate email?

Read other 6 answers
RELEVANCY SCORE 124.8

Hi Everybody

When I import data (numbers) from a web site to excel, I get the + sign in the upper left corner of each cell.
How do I remove these + signs ??

Thank You

Read other answers
RELEVANCY SCORE 124.8

I have a spreadsheet that contains formulas. I want a macro that will copy the data only in that cell with the formula and paste only the data in another cell.

I have been scratching my head for a little bit on this one.

Thanks
 

A:Excel - copying data and pasting data in a formula cell

If I understand correctly, you can actually avoid using copy altogether.

Let's say you have the value 50 in A1 and the formula =A1*2 in A2. The following macro would copy A2 to D2:

Sub Macro1()
Selection.Copy
Range("D2").Select
ActiveSheet.Paste
End Sub

but because the formula uses relative references, the resultant formula (in D2) would be =D1*2.

So what you could do instead -- using a single command only -- is:

Range("D2").Value = Range("A2").Value

HTH,
bomb
 

Read other 3 answers
RELEVANCY SCORE 123.6

I would like to know a method to solve an otherwise repetative task in Excel for me.

In my Excel spreadsheet, I have many columns relating to customer orders etc. Each customer (finite number (~40)) has its name (customer1, and customer2 etc) input to a cell, I then must fill out the customer account number (ac001, ac002 etc). The customer name and number already exist on another sheet.

How can I automate the process of when I input the customer name, excel then fills in the customer number in the next cell?

Many thanks
Dave
 

A:Excel: Conditional Cell Input Based on Entered Data

Depending on how your Customer data is arranged, look at either Dlookup or Vlookup.
But Access is better for Customer databases.
 

Read other 3 answers
RELEVANCY SCORE 123.6

Hi folks, not sure if this is possible or not but I'll try to explain what I'd like to do.

On the first sheet, I have a simple sheet to be filled in daily. The date is changed, and then daily pick figures and hours picked are updated by the relevant department.

I then have to manually put all of the data into the second sheet, which acts as a log of previous pick figures.

Is there a way the second sheet can automatically be filled in when the date is changed and new figures are put into sheet 1?

I hope I've explained this well enough, I'm trying to teach myself excel as I'm going along! Thanks.

Edit - I've had to delete peoples names' for obvious reasons, initials in sheet 2 will correspond to people in sheet 1.
 

Read other answers
RELEVANCY SCORE 122

ive never done formulas in excel before except for basic =sum stuff

im trying to make a wage sheet which calculates hours worked and pay

i have a row of cells under the titles 'monday' to 'sunday' with digits underneath saying how many hours were worked on those days. however, in the cells which say the hours worked each day i would also like to include overtime hours as a seperate digit but still remain in the same cell under the correct day

e.g. under 'monday' i might write '6(+3.5)'

'6' being the normal hours worked, and the value in the brackets being the overtime.

however, id like these numbers to be calculated seperately as i have a column which gives a total normal hours worked and another column which says how many overtime hours were worked

so basically, in one column id like a formula which would work like:

=sum(first number in cell a1 + first number in cell a2 etc..)
and in another column id like a formula which would work like:

=sum(second number in cell a1 + second number in cell a2 etc..)

how can i do this?
ps. im sorry if this has being asked before but i dont know how to word my search query cuz i dont know what this is called
 

A:Excel 2003: Formulas which use 2 seperate bits of data from a single cell

Read other 7 answers
RELEVANCY SCORE 122

Hello

I can't seem to make this happen with standard excel functions and I'm not good with VB.

Its for basic inventory counting. I have a column of 500 part numbers in excel. I would like to scan a part number on the shelf using a USB barcode scanner (already have) and excel immediately goes to the cell containing that part number. I would then manually move to the adjacent cell and type in the quantity and then start over with next item. Is this a doer?

Thanks for your help.
 

A:Excel 2003 - Input Data from Barcode Scanner and Jump to Cell

Read other 8 answers
RELEVANCY SCORE 120.8

Retrieving Cell Data and Reverse Lookup in separate spreadsheet

Hello Everyone,
My name is Melvin and I work as an accountant in a Logistics Company. I am a newbie here and I implore

your help in a major predicament with Microsoft Excel.

Let me begin,

Lets say I have 2 spreadsheets.

1. The first document, SALEXCEL_1111 contains a large list of salary values of individuals of different

pay grades. The Left Column is PAY GRADES namely with a letter and a number. For example, A1, A2

upto A10, subsequently B1,B2 upto B10. I hope to bring to your attention that these values are not cell

references but the actual data within the cells.
And the lower row is that of SENIORITY in years.
_______
A1
A2
..
A10
_______
B1
B2
..
B10 | 2250 | 2500 | 2750 |
_______

SENIORITY | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |

2. The second document, SALEXCEL_2222 is that of a specific company branch office with employee

details such as the name field, position and then PAY GRADE.

NAME | POSITION | PAYGRADE | SENIORITY | SALARY

XYZ | Accountant | B10 | 2 | XVALUE
Now the biggest challenge is that, there are different employees with different pay grades and many

such branch office spreadsheets. Here thankfully, the main database spreadsheet is a constant.
Is there any way to obtain XVALUE by Looking up the paygrade and the seniority cell values in

SALEXCEL_2222 and obtaining the required addresses and then by referencing SALEXCEL_1111 and

looking up the cell data value of... Read more

A:Retrieving Cell Data and Reverse Lookup in separate spreadsheet (MS EXCEL 2010)

Hope these attachments convey a better picture. ^_^

ATTACHMENTS:
SALEXCEL_1111
http://www.mediafire.com/?ux12tbvpa84yy41

SALEXCEL_2222
http://www.mediafire.com/?2td00b4xtaat5ao
 

Read other 1 answers