Over 1 million tech questions and answers.

Insert Worksheet based on cell content

Q: Insert Worksheet based on cell content

Is there a way to insert a new worksheet based on whether or not a cell contains data and name that worksheet with the contents of the cell.
Ex: A1= Data
worksheet would be added and named Data

RELEVANCY SCORE 200
Preferred Solution: Insert Worksheet based on cell content

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: Insert Worksheet based on cell content

Read other 9 answers
RELEVANCY SCORE 92.8

I'd like to be able to insert fields into the cells of an Excel workbook, rather than just in the header / footer.

I'm going to be completely in shock if this is not possible, but I'm not able to find anything whatsoever.

Help????

Thanks,

John
 

A:Insert field (e.g., &[Tab]) into worksheet cell

Read other 8 answers
RELEVANCY SCORE 92

Hi all,

I have a workbook containing 30 worksheets. The first sheet is named Master, while the other 29 worksheets are named with cities where we held branch offices (Los Angeles, New York, Chicago, Washington D.C., etc.)

I am trying to write a macro that will copy the contents of a row in the Master sheet to a particular worksheet based on the contents of the cell in that row that contain the location.

To illustrate:
Master sheet:
Columns are: Staff Name, Location, Project status

We have over 5000 staff.
I am trying to write a macro that will copy each staff's record to the worksheet corresponding to his/her location, depending on their project status.

So I am planning to use macro buttons labelled A, B or C (these are the values in the Project status column). So when I click on the button labelled A, the macro will go through all 5000 employees, and for those employees whole project status is "A", will copy that employee's record into a worksheet depending on his/her location.

For example:
Staff name, Location, Project Status
Joe Doe, Los Angeles, A
Jane Davis, New York, A
Mike Smith, Los Angeles, C

When I click on the macro for "A", it should copy Joe Doe's record into the worksheet labelled Los Angeles and copy Jane Davis' record into the worksheet labelled New York.

Thank you so much for your help. I've been searching all over the place for the command to use to reference the worksheet.
 

A:Excel - how to reference a worksheet based on value of a cell

For the love of PacMan, make sure you save your file BEFORE you try this. Try it on a copy of the file, even.

HTH,
Andy

Sub A_Status()
'select the list of staff names on Master sheet, then run
For Each Cell In Selection
If Cell.Offset(0, 2).Value = "A" Then
DestinationSheet = Cell.Offset(0, 1)
Cell.Resize(1, 3).Copy
Sheets(DestinationSheet).Select
'assumes each location sheet has a header row
Range("A65536").End(xlUp).Offset(1, 0).Select
ActiveSheet.Paste
Sheets("Master").Select
End If
Next Cell
Application.CutCopyMode = xlCopy
End Sub
 

Read other 2 answers
RELEVANCY SCORE 89.2

Hello,

A pretty inexperienced VBA'er here.

I have 2 named ranges:

- LastStatus = "J8:J500"
- CurrentStatus = "K8:K500"

What I would like to do is create a loop to copy the cells in CurrentStatus over to the LastStatus column if and only if there is a value in CurrentStatus (column K). If there is no value in column K and there is a value in column J, I do not want change the value in column J.

Any help would be greatly appreciated.

Brian

 

A:Excel - Conditional Copy / Paste (Same Worksheet) based on cell values

You don't need a loop.

Sub test()
Range("LastStatus").SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=IF(RC[1]<>"""",RC[1],"""")"
Range("LastStatus").Value = Range("LastStatus").Value
End Sub
 

Read other 1 answers
RELEVANCY SCORE 84

I have a excel file with 365 worksheets, each worksheet has the temperature and humitidity of one day for each 30 minutes of that day. Each worksheet has the name dd-mm-yyyy.
But as I get the data from the web, sometimes the list skips some entries. I want to insert automatically a row in the list when the next row in not 30 minutes later. That row should have the time and a – sign in the temperature and humidity row. Preferably the macro would do this for all worksheets.
Time Temperature (F) Temperature (ºC) Humidity (%)
0:20:00 33,8 1,0 87
0:50:00 33,8 1,0 87 I want to insert a row after this one with "1:20:00 - - -"
1:50:00 33,8 1,0 87
2:20:00 33,8 1,0 87
2:50:00 32,0 0,0 93
3:20:00 30,2 -1,0 93
3:50:00 30,2 -1,0 93
4:20:00 30,2 -1,0 93
4:50:00 28,4 -2,0 100
5:20:00 30,2 -1,0 93
5:50:00 26,6 -3,0 93
6:20:00 28,4 -2,0 93
etc until
23:50:00 37,4 3,0 87
 

A:Excel - insert row in a list if the next cell content does not meet a condition

Read other 16 answers
RELEVANCY SCORE 76.4

Hi I am trying to copy and insert rows based on a number in cell E. If the number in cell E is 4, I would like to copy 3 additional rows beneath the original and then also number the 4 rows into column F consecutively for each group. I am attaching a spreadsheet of before and after. Sheet 1 is the before and sheet 2 is the after. Can anyone help me with this. I have tried another code but it not work properly. I did find one that would put blank rows in but I cannot get past that. Any input is greatly appreciated.

Thank you

Peg
 

A:insert rows based on number in cell and copy the data down into the new rows

Hi Peg

Try this solution and see if it is ok for you. I've put in some code to help prevent the running of the code multiple times on the same sheet. If you don't need this safeguard you can delete the block of code that does this.

Also, make sure and make a backup of your file before running this - just in case.
 

Read other 1 answers
RELEVANCY SCORE 72.8

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 68.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 68.4

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 68.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 67.6

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 64.8

I have a document that is read only suggested...not password protected. I have been adding worksheets as necessary. I only have 6 worksheets at this time. Today when I tried to add a worksheet the worksheet option is inactive.

Any ideas?

Thanks so very much!
 

Read other answers
RELEVANCY SCORE 64.8

Hi, I am trying to create a worksheet in excel that links several worksheets together. Is there anyway that you can set up a cell where if you double click on it, it automatically takes you to a referenced tab???? It would be a data entry form where each tab is linked to a master input sheet with the totals from each tab on it. Since there are going to be a large number of tabs I want to be able to click on the cell and automatically bring up the tab I want to put the information in. Is this possible in Excel 2007?
 

Read other answers
RELEVANCY SCORE 64

Ok, this should be super easy, but it is 5:30 and my brain is totally fried. I have a simple spreadsheet, three columns

COLUMN A1 is text:

Hello <NAME> thank you for coming to the show on <DATE>

COLUMN B1 is NAME
BOB

COLUMN C1 is DATE
3/30/2008

I need a 4th column to merge all this wonderful data together for me.
 

A:Insert Cell Info into Another Cell

Read other 9 answers
RELEVANCY SCORE 63.2

Could someone tell me how to write a macro to rename a Excel worksheet using the text in a cell in the same worksheet.
 

A:Rename a Excel worksheet with the text in a cell

Just be aware that the sheet name cannot contain some certain characters such as / : * and a few others. Also be aware that the sheet name cannot exceed 31 characters (including spaces)

Here are some various code example of how to achieve what you want
ActiveSheet.Name = Range("A1").Text

Sheets("Sheet1").Name = Range("A1").Text

Sheets(1).Name = Range("A1").Text

Sheets("Sheet1").Name = Activecell.Text <----- If the source cell is selected

Rollin
 

Read other 2 answers
RELEVANCY SCORE 63.2

Hi I'm newbie in excel vba. I need help with vba code. I have multiple worksheets with table and checkboxes at the end of table in each sheet. I want when check the checkbox, data in sheet 1 & sheet 2 column A & B & E copy/transfer into sheet3 worksheet. thanks your any help. here the example:

Sheet 1:
col A |col B |col C | col D |col E |col F
No | User | Location | Level |System1 | checkbox
1 |Aaaa | QWER |001 |YES |CHECK
2 |Bbb |ASDF |002 |YES |CHECK
3 |Ccc |ZXCV |003 |YES |UNCHECK

Sheet 2:
col A |col B |col C | col D |col E |col F
No | User | Location |001 |YES |CHECK
2 |Eee |ASDF |002 |YES |UNCHECK
3 |Fff |ZXCV |003 |YES |CHECK

Sheet 3:
col A |col B |col E
No | User |System
1 |Aaa |YES
2 |Bbb |YES
3 |Ddd |YES
4 |Fff |YES
 

Read other answers
RELEVANCY SCORE 63.2

Is there a way to set the value of a cell to the name of that particular worksheet with a function???

sorry about the consecutive posts, i'm working on a project for work.

thanks for any help!
 

A:setting cell values to worksheet names

Hello:

Try using the function =cell("filename") in any cell. It will return the complete path including the tab name of the spreadsheet.

I found this by going to help and looking up information functions.

Hope this helps.

ddcrab
 

Read other 3 answers
RELEVANCY SCORE 63.2

Microsoft Excel MS Excel 2003

I would like to pull information from worksheet cells (specifically file path and name) to use in an auto open macro in order to provide a workaround on the limitation of the INDIRECT function's inability to access data in closed worksheets.

How do I create a reference in the Visual Basic macro to pul the data from the worksheet?
 

A:MS Excel Worksheet Cell info to be used in Macro

Read other 10 answers
RELEVANCY SCORE 63.2

Hi,

I have a master list of data from which i want to make seperate lists. The first seperate list I want to make is a copy of all rows in the master table which have a certain column value set to yes, an example is below.

Name Age Verified
James 18 Yes
Billly 17 No

For all rows where the "Verified" value is yes, I want a copy to made in Workbook 2 and placed in the next available row. Then, whenever I change the data in Workbook 1 for that row I want the information to be updated in Workbook 2 so long as the verified value remains Yes.

How could I do this?
 

A:Copying data to a second worksheet depending on cell value.

Hi maracles,
Your using the word "Workbook" when trying to explain what you want to do with the data. Are you intending to copy the data to a seperate Workbook, which means that your copying it to a new Excel document, or are you copying it from Sheet1 to Sheet 2 within the same Workbook. If you could post a ziped copy of the file it would be most helpful.

Peace Out,
 

Read other 2 answers
RELEVANCY SCORE 62.8

Hi everyone,

I would really appreciate some help with this problem, I've been working on it for over a week now trying different things – and I,m no further advanced.

I have 2 worksheets, 1 - Stock; 1 – Layout. Stock = Stock that is recorded on the sheet, this starts out as New and then progresses to either despatched or cancelled.

What I would like to happen is that everytime a record of stock is entered/amended then the corresponding location cell (A001; Z020 etc.) in the “layout” worksheet is coloured to reflect the entry in the stock sheet i.e. new = green; despatched = orange or cancelled = red, but I've reached the stage where I can't even think straight.

Can anyone help me please?

Thanks,

Moll
 

A:Solved: Colour cell depending on entry in another worksheet

Read other 9 answers
RELEVANCY SCORE 62.8

Hi

I've been trying to find a solution to this and I've done some workarounds, but keep on failing on this.

I have a database where data is dumped into the "Input" sheet (Sheet12) Cols A:U. A macro (copyform) then copies formulas down in columns V:AR to the last used row. (I need the data in a separate sheet due to a Ranking formula I'm using - each week number needs to be ranked seperately and I couldn't find a Rank IF formula =RANK(AH2,disputeamt,0)+COUNTIF($AH$2:AH2,AH2)-1) which makes each value unique.

I have named the range A2:AR (row number dynamic) "Inputsheet" via a macro called "namerangeinput"

I would now like to copy (pastespecial) this named range to the "Data" sheet (Sheet9) but to the next blank row.

I would also like to clear the data in "Input" sheet (Sheet12) with the exception of the first row of formulas in V:AR as these are used to populate Input Sheet when new data is added.

If there is a more efficient way of doing this (currently all different macros), then your help would be gratefully received! (I have until the end of this Fiscal to do this)

Kind regards

Diane
 

A:Copy Dynamic Named Range to the next available cell on another Worksheet

Welcome to the board.

"I have a database where data is dumped into the "Input" sheet (Sheet12) Cols A:U."

OK. Can we assume since you later mention "the range A2:AR" that row 1 is headers?

"A macro (copyform) then copies formulas down in columns V:AR to the last used row. (I need the data in a separate sheet due to a Ranking formula I'm using - each week number needs to be ranked seperately and I couldn't find a Rank IF formula =RANK(AH2,disputeamt,0)+COUNTIF($AH$2:AH2,AH2)-1) which makes each value unique."

First sentence of that, the last used row based on what? (which column?) 2nd sentence ... I haven't a clue what your formulas do, so pass on that for now. But trying to connect the first sentence to something else later, namely:

"I would also like to clear the data in "Input" sheet (Sheet12) with the exception of the first row of formulas in V:AR as these are used to populate Input Sheet when new data is added."

Now, "the first row of formulas in V:AR"; does the first row actually mean row 1? Because that would work best, having the formulas in V1:AR1 permanently. Then you could:

Sheet12rows = Sheets("Sheet12").Range("A" & Rows.Count).End(xlUp).Row
Sheets("Sheet12").Range("V1:AR1").Copy _
Sheets("Sheet12").Range("V2:AR" & Sheet12rows)

Then we come to "I would now like to copy (pastespecial) this named range t... Read more

Read other 2 answers
RELEVANCY SCORE 62

I have selected certain cells, e.g. total cells, and cells that contain formulas which should not be changed, and 'locked' them. I then protected the worksheet but allowed users to insert and delete rows/columns. However, when I open the spreadsheet, the option to insert or delete in the context menu is greyed out. I can insert entire rows, but I have multiple sections adjacent to eachother which will become misaligned if entire rows are inserted.

Any idea how allow users to insert and delete rows and columns which span a specific number of cells?

Thanks
 

A:In Excel, I can't insert/delete rows in a protected worksheet (even when enabled)

Read other 6 answers
RELEVANCY SCORE 62

Hi
I'm lookiong for a simple macro that will do the following

Open when excel starts
and select a TAB based on the date (month & year)

I have a calendar month on each tab - although I may change this to one work sheet later

I would like a macro to auto open to
1) the month Tab based on current month

If its July 2012 then it opens the Tab called Jul 12
if is aug 2013 then it opens a tab called Aug 13 tab
etc
for all months - I can change the name of the TAB if that helps make it work in a loop - to minimise the code
so something like find the current month Year then append those to create a name for the TAB

OR

goes to a specific cell in a sheet if i have the calendar all in one sheet
so again I can add the text in a cell - so the it can just look up the date and find the cell - rather than code for all likely cells

so something like in cell A20 have Jul13
and then search for that - if its Jul 13

I'm playing with some ideas for a work schedule and report schedule sheet to be available via a website for people to view - BUT i have very limited functionality with the website as its based on SharePoint shell

Office version is 2007 , but i may test on 2003

thanks
found some code

i have found some code which will open the worksheet and highlight the cell with the date in

How do i search through all tabs so i dont need to specify the tab

Code:

Private Sub Auto_Open()
'first make sure the correct
ThisWorkbook.Worksheets("Sheet1&quo... Read more

A:Solved: Macro to open a specific worksheet based on month

Read other 6 answers
RELEVANCY SCORE 62

Hi, I am new to VBA so please excuse this question if it appears to be elementary. I am trying to write a code in VBA that allows me to operate scenarios in Scenario Manager, on an active worksheet from an inactive worksheet.

I have managed to write a code that runs the scenarios from a combo box actually on the active worksheet using 'Worksheet' 'Change':

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$O$16" Then
ActiveSheet.Scenarios(Target.Value).Show
End If

But am struggling to write a code that will allow me to operate the same scenarios from an alternative worksheet within the same work book. The ActiveWorksheet is called 'NGN Inputs' FYI and is "Sheet 14" and the Inactive worksheet (i.e. the one not containing the scenarios) is called 'Assumptions ("Sheet4")

Again this is probably fairly elementary but I am new to VBA and would appreciate any help.

Many thanks.
 

A:VBA - VBA to execute Scenarios Based On Combo Box Selection on an Inactive Worksheet

don't work with Activesheet, set up your procedure like this...
Code:
dim wb as workbook
dim WS1, WS2 as worksheet

Set WB = Thisworkbook

Set WS1 = WB.sheets("NGN Inputs")
Set WS2 = WB.sheets("Assumptions")
then you can refer to your cells like this..

WS1.cells(16,15)

Code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$O$16" Then
WS1.Scenarios(Target.Value).Show
End If

 

Read other 1 answers
RELEVANCY SCORE 62

In cell A2 I want to display the date that the worksheet was last modified.

Is there a function that does this?

Or is this a job for VBA? If so , how do I do this (from scratch)?

TIA, TTFN
 

A:Solved: Excel 2003 - add worksheet date last modified to a cell

Read other 6 answers
RELEVANCY SCORE 58.4

hello,

I have a lot of checkboxes which when checked showd insert a new row in the beggining of a page and display a text using formulas (example: new row B1 value = B46 and D1 = D46).

ANY SOLUTION TO THIS WILL BE APPRECIATED. HELP!!!
 

A:Insert new row and add formula to a cell

Have you recorded a Macro of "Inserting A Row" to get the correct VBA Syntax for that part of your requirement?
 

Read other 3 answers
RELEVANCY SCORE 58.4

I have a fairly simple task. From Row 17 to row 51 and Row 96 to 163 , I want to delete the row if cells P and Q are empty.

From row 57 to row 94 I want to delete the row if cells B, C, P, and Q are empty

I'm not sure what I'm doing wrong here.

Sub CleanUp()

Dim endrow As Long
Dim x As Integer

Set endrow = Sheets("Work Order").Range("A17").End(xlUp).Row

For x = endrow To 17 Step -1
If Sheets("Work Order").Range("P" & x) = "" And Sheets("Work Order").Range("Q" & x) = "" Then Sheets("Work Order").Rows(x).EntireRow.delete
End If
Next x

Rows("167:180").Select
Selection.delete shift:=x1Up
End Sub
Click to expand...

If you see something glaringly wrong or know a quicker way to do this, I would be very thankful.
 

A:VBA Deleting row based on cell value

Here's an example work sheet. If the code works right in the example, it would delete rows 4, 5, 9, and 10.

Code:
Dim endrow As Long
Dim x As Long

For x = endrow To 29 Step -1
If Sheets("Sheet1").Range("P" & x).Value = "" And Sheets("Sheet1").Range("Q" & x).Value = "" Then
Sheets("Sheet1").Rows(x).EntireRow.Delete
End If

Next x
Why won't it remove the rows?
 

Read other 2 answers
RELEVANCY SCORE 58.4

I have a spread sheet where I would like a message to pop up after I enter a value in cell G2 based on what the value of I2 is. like the following description:
In cell I2 I have "=(E2*F2*G2)/144" after I enter a value in cell G2 I want a message to come up if the value of I2/g2 is less than three and not equal to zero" Is this possible? If so could someone help me out with this?

thanx
 

A:validation based on another cell

This is the same as the challenge file but I added the code for this question
 

Read other 1 answers
RELEVANCY SCORE 58

Hi!

I have a spreadsheet that is generated from another program. I do not know how many rows there will be. What I would like to do is have a macro that will put borders around all cells in a given row if there is content in that row. Particularly, if there is content in say C4, then border A4 through F4. If content in C5, then border A5 through F5 and so on. I do know that there will be no more than 35 rows of data, but I want to start at row 4 with this marcro.

Make sense? Can you help!

THanks!!!
Lori
 

A:How to border row of cells based on content?

Read other 6 answers
RELEVANCY SCORE 57.6

Hi guys
A Sometime ago I was highlighting some cells in excel 2003 and I was able to pick a colour in the paint box and then click on a cell in excel and the colour was pasted into the cell.
Whilst I was doing this one day something changed in the paint box and I was then able the select a default colour and then past to any cell without having to select the colour every time I pasted to a cell
The default setting requires me to select a colour every time to paste a colour into cells that are not adjacent I have to select the colour every time
The setting I accidently found enabled me to click on ant cell and the selected colour was applied.
So does anyone know how to do this in excel 2010 please
 

A:Insert a colour into a excell cell

I'm guessing you were using the format painter. On the Home tab, there should be a picture of a paintbrush. Put the color you want in one cell and then double-click (not single-click) the paintbrush. Then you can apply that same formatting to as many cells as you want by clicking in them. When you've finished, single-click the paintbrush again to turn it off. Hope that helps.
 

Read other 2 answers
RELEVANCY SCORE 57.6

Hello,

I'm trying to enter a formula that returns a value when a loan balance is paid off. I've attached a spreadsheet that shows the costs and revenues of a project and the corresponding loan balance. It's very basic, but I'm trying to see if there is any formula that will return the Month that corresponds to the loan being paid off. I've been trying to use an "if" formula and when the loan balance is <0, but i don't know how to do it with just one cell. Let me know if anyone has ever done anything like this.

Thanks,
Chet
 

Read other answers
RELEVANCY SCORE 57.6

Hello everyone.

I am trying to tweak a macro that was posted on this forum some time back, but I'm a bit of a N00B. The macro is from this thread that is now locked: https://forums.techguy.org/threads/...ue-date-reminder-based-on-excel-file.1129238/. What I am looking to do is generate two different emails whenever the value of a cell changes. All the data that needs to be part of the email is included in various cells. I've included sample data. If possible, could you provide code for generating the email and another for sending the email without opening Outlook (i.e., as soon as the value changes)? I've included sample data for your consideration. Thanks in advance for any help you can provide.

When Cell Value = In Progress
The email I'm hoping to generate (I've mapped it with the cell contents I'm hoping to pull) will be as follows when Column F changes to In Progress. The email addresses are in Column G.

Subject Line: "Web Request(s) Now In Progress"

Dear D2,

Your C2 B2 request has been received and is now in progress. Thank you!

My Signature

When Cell Value = Completed
The email I'm hoping to generate (I've mapped it with the cell contents I'm hoping to pull) will be as follows when Column F changes to Completed. The email addresses are in Column G.

Subject Line: "Web Request(s) Completed"

Dear D2,

Your C2 B2 request is complete and the changes are now live. Thank you!

My Signature
 

Read other answers
RELEVANCY SCORE 57.6

Hello
I am running win 7 and and I've noticed that the folder columns change based on the content of the folders. For example, when I'm looking at a folder with documents in it, I have the following columns:
Name
Date Modified
Type
Size

When I go into a folder with mp3s:
Name
Track number
Title
Contributing artists
Album

For pictures:
Name
size
type
date
date modified

I'd like to have all folders have the same columns no matter what files are in it. I've tried using Tools->folder options->view-> apply to folders button, but it does not fix the issue. Any way to change it for all folders?
Thanks

A:Folder columns change based on content

Hello Bandit, and welcome to Seven Forums.

This can help show you how to set a default folder view to be used in all folders in Windows 7.

Folder View - Set a Default for All Folders

Hope this helps,
Shawn

Read other 1 answers
RELEVANCY SCORE 57.6

How can I hide rows based on the selection of a Data Validation in Excel.

Example:

If user chooses 1 from drop-down menu then hide rows 15-20 otherwise if 2 is chosen hide rows 25-35. I have a proc that will hide the rows but I don't know how to get the code to fire.

Thanks
 

A:Hiding rows based on range content

Read other 7 answers
RELEVANCY SCORE 57.2

Hi there
I am currently busy with a project. However I face difficulty in trying to allow formula's to read the value of a specific cell (instead it is reading the formula in that cell).
I have 6 accounts, 3 are NOSTRO (begins with 0) & 3 are VOSTRO (begins with 7). When I select a Vostro account I want the letter V to populate in another cell & when I select a Nostro account I want N to populate. Hence I used a formula in F3 LEFT(E3,1) to retrieve the first digit of the account number (0 or 7). And in cell G3 I used formula =VLOOKUP(F3,NV,2,FALSE) to read the contents of F3 and select either N or V. However my problem is that the Vlookup formula is not reading the 0/7 value in cell F3, its reading the text of the formula...
Please assist.
 

A:Solved: Cell content reflects formula not value

Welcome to the board.

Either I'm missing something or that's weird.

What do you get for this (which cuts out the "bridging" formula)?:

=VLOOKUP(LEFT(E3)*1,NV,2,FALSE)

It works for me, with the "*1" seeming to somehow force the number "nature" of the first left character.
 

Read other 3 answers
RELEVANCY SCORE 57.2

Hi,

I have a large excel worksheet, divided into 4 rows (different data fields). Hard luck, in one of the rows, some cells contain two products or more instead of one (ex: "ZB3054066¦¦ZB3601207¦¦ZB3601206"). They are separated either by a blank or by a ¦¦ (double bar).
I need that each time I detect a cell in that particular row that contains multiple products, I create new rows so that each row contains only one product in the column "component parts" and that the original data in the other columns remains unchanged.
I don't know anything about excel macro, but here is the approximate code I created to do this task :
If current row cell "component parts" contains a separator (either or blank),
{
create "number of separators" new rows
copy every field except the "component parts" one
while( cell "component parts" contains a separator)
{
cut the part of the "component parts" cell before the first separator (including the separator)
paste it into the next row "component part" cell
delete the separator in the new "component parts" cell
}
}

If anyone knows how I could do this in an excel macro...
Thanks.
 

A:Excel macro : cell with multiple content

Read other 16 answers
RELEVANCY SCORE 57.2

I have a cell F4 in the first worksheet named INFO.

In the second worksheet called CLASS, there is a row that I need copied according to the cell F4 value number of times.

I need a button on the first worksheet - INFO, and I need the rows copied and inserted in the second worksheet.

I need it s=inserted since the column totals are at the bottom and should be updated.
Thank you
 

Read other answers
RELEVANCY SCORE 57.2

Hey all:

I'm have really no experience with coding, so I'm out of my depth trying to do this myself. Hopefully someone can help, so here goes!

Essentially, my excel sheet keeps track of dates of when files need to be renewed. They need to be renewed every 60 days. So I have an "IF" formula that tells me if it's time for renewal.

What do I need to do to get an email notification whenever a file comes up for renewal? I've attached a sample sheet.

Best,
Nick

PS.
Using Excel/Outlook 2010
ClickYes Pro is installed (don't know if it will be necessary or not)
 

A:Solved: Emailing from Excel Based off Cell Value

Read other 16 answers
RELEVANCY SCORE 57.2

Does anyone know a way to manipulate the countif formula to count how many cells are "green" or "red" (with varying text in each cell), rather than the value of the cells?

Can this be done in VB?
 

A:Solved: countif based on cell format, not value?

Read other 10 answers
RELEVANCY SCORE 57.2

You must be bored with this question cos I've seen lots of them, however I can't seem to fathom out what to do..........

I've got a block of data within a spreadsheet 4 rows always in the same place.

How do I put into code:-

If column d43:e46 is blank delete rows 43 - 46 if not ignore it.

As I said I've tried a few things and it will delete the four rows regardless of them being empty of not.

Can someone help please.

Many thanks,

Moll
 

A:Deleting rows based on empty cell.

Is there anybody there? - Help!
 

Read other 2 answers
RELEVANCY SCORE 57.2

Hi,
I am trying to hide rows in excel 2010 based on cell values in a certain column. I know that I have to use the VBA but I don't know how to do that kind of stuff. I know it should be simple to do but I don't know where to start. Let me know what you need in order to help me accomplish this task.
 

A:How to hide rows in excell based on cell value

Read other 8 answers
RELEVANCY SCORE 57.2

I have an Excel workbook with 400k rows Each set of rows contains a table name with the fields in the table. The number of fields is not the same for each table. For example:

COLUMN A COLUMNB

AV_ACTN_RSLT_VWACTN_RSLT_CDAV_ACTN_RSLT_VWDESCRAV_ACTN_RSLT_VWDESCRSHORTAV_ACTN_RSP_VWEMPLIDAV_ACTN_RSP_VWEXT_ORG_IDAV_ACTN_RSP_VWINSTITUTIONAV_ACTN_RSP_VWNAMEAV_ACTN_RSP_VWRSPL_ID

AMT_X_SAL_TYPEWCS_PLAN_DESCR20AMT_X_SAL_TYPEWCS_TOT_AMOUNT

I need to convert the field names so that they are in a row like this:

AMT_X_SAL_TYPEWCS_PLAN_DESCR20WCS_TOT_AMOUNT

Is there any way for me to do this programatically? I'm using the transpose feature but it is time consuming and I have 400k rows. So basically, I want something like if the field in column A row 1 matches row 2, move that field to the right of row 1 and so on until the table name changes.

Or maybe i should dump the spreadsheet in access and try there...

Thanks,

Amy
 

A:Move data from column to row based on value of cell?

Read other 6 answers
RELEVANCY SCORE 57.2

i have 2 workbooks entitled [price] and [fruit] respectively

[price], sheet1!, cell A1 is a variable which can contains a cell address, eg $D$1

[fruit], sheet1!, contains information in cells as follows:
D1 = apples
D2 = bananas
D3 = cherries

in the [price] workbook, i want to have a formula in say, cell B1, which would use the cell reference in A1 to find the value in the [fruit] workbook.

so, if [price]sheet1!A1 = $D$1

then [price]sheet1!B1 = apples

note that the result "apples" was pulled from another workbook, [fruit]sheet1!$D$1.

if [price]sheet1!A1 = $D$2,
then B2 = bananas

and so on...
in the [price] workbook,

As A1 is a variable, i do not want to physically retype the value within A1, but rather draw reference to it inside of a formula. i hope this is clear as mud.

Is this possible?

Thanks,
markus
 

A:Q: draw value from a 2nd workbook, based on a variable cell ref in 1st wb

In Sheet1!B1 (of Price), use

=INDIRECT("[Fruit.xls]Sheet1!"&A1)

, where A1 contains the cell reference -- $D$1, $D$2, $D$whatever.

As explained yesterday, this (the INDIRECT function) will only work when both files are open ; to get it to work when the source file if closed, you need to download Laurent's add-in. Please do not start threads over.

Rgds,
Andy
 

Read other 1 answers
RELEVANCY SCORE 57.2

Hi,

New here. I dug up a thread that Zack Barresse solved many years ago. I am looking to do the exact same thing. The link to the thread is below. My file is infinitely more complicated than what that user was asking for so I need a bit more help tuning the VBA. Link: http://forums.techguy.org/business-applications/710581-automatic-email-alerts-using-excel.html

Some specifics:

- I am using Outlook not Express
- Excel 2007
- All the functionality is complete for monitoring several live streams of securities data with several trade indicators.
- It is consolidated onto one sheet for manual monitoring (Picture below). Basically takes copious amounts of data and reduces it to just IF and AND functionality for the triggers for easy use from all the other sheets.
- The workbook will be open and running/refreshing on its own 24/7 as it is now.

I am a busy guy, I just need the VBA to automatically email me remotely when any of the 7 currency pairs causes a trigger when I am on the go. I can log trades from an app on my phone.

One other hurdle would be that if say (Using percentages to keep it simple) that a trigger would be if something reached as high as 80% to send the notification email. But where the system refreshes every 60 seconds it shouldn't send another notification each time it remains at or above 80%. Just the once. It may remain there for hours and that is a lot of emails.


Thoughts? and many many thanks in advance.
 

A:Excel - Auto Email based on cell value

Read other 10 answers
RELEVANCY SCORE 57.2

Dear Fellows

I am looking for help for a macro which can copy data to other sheet based on adjacent cell value which i define.

For example i have data attached in a sheet.

i want to copy data based on value present in E column to different sheets. if it is ES then all ES rows should be copied to sheet ES with roll number name father per and dept.

Same is for other departments, on different sheets. There will be 9 departments overall.

Looking for response
 

Read other answers
RELEVANCY SCORE 57.2

Hi guys,

Can you please help me further expand the macro below? I need it to also look between the ranges of C24 and Z24 and hide the respective column. (i.e need some sort of loop)

i.e

if C24 is 0, then hide column C
if D24 is 0, then hide column D
etc...
Sub Hide_Column ()

If Range("H24").Value = 0 Then
Columns("H").EntireColumn.Hidden = True
Else
Columns("H").EntireColumn.Hidden = False
End If

End Sub
 

A:Solved: Hide Columns based on value of cell

Read other 9 answers