Over 1 million tech questions and answers.

Conditional Hiding Rows based on a cell value selected from a "data validation" list

Q: Conditional Hiding Rows based on a cell value selected from a "data validation" list

Hi.

I'm a beginner when it comes to VB Script and so I am struggling to work this out. I basically have a worksheet that contains information about different staff members. The sheet is set up so that column A (from row 8 on) is their name and columns B to L (also from row 8 on) are other staff attributes. Due to several reasons, there is more than one listing for each staff member (up to 40). The database is supposed to be there so that any staff member can come in and look up their information (or that of any other staff member). However, with so many listings and so many staff members, it becomes an unmanageable database. I could just create filters so that staff members could simply filter out other employees; however, this would create issues. Instead, I have created a cell above the table (say C2) where staff members can enter their name via means of a data validation list (which is linked to a list of staff members on another sheet). I would then like all rows in the table to hide except for those where the name in column A = C2.

I have searched this on the net and I keep seeing similar responses that all say it's hard when there is data validation / formulas involved. Is there a way this can be done?

Cheers

Read other answers
RELEVANCY SCORE 200
Preferred Solution: Conditional Hiding Rows based on a cell value selected from a "data validation" list

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

RELEVANCY SCORE 119.2

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 111.2

I am using Excel 2010

I want to limit a validation list based on the contents of Cell D4
There are 4 lists possible based on the contents of D4:

If cell is 1 = list (on datasheet tab) should be limited to range A42:A71 only

If cell is 2 = list (on datasheet tab) should be limited to range A72:A87 only

If cell is 3 = list (on datasheet tab) should be limited to range A88:A90 only

If cell is 4 = list (on datasheet tab) should be limited to range A92:A93 only
Thanks
 

A:Excel 2010: Limit validation list based on another cell

Soooo... is this possible or no?
 

Read other 3 answers
RELEVANCY SCORE 111.2

I am hoping that someone can help me with what may be a complex question.

I have a spreadsheet, similar to the demonstration file I have attached. In it, there are a range of columns. One set of columns (A - D), shows a list of numbers that are references to items in a store, and it also shows their location in the store, so it acts as a floor-plan. The next column (E) lists those items again to show the dollar amount that those items have produced in total sales (F).

So, what I'd like to do is to add a conditional formatting to show me the "cold" and "hot" spots on the floor-plan so I can see where sales are most concentrated. I would assume that this would be done with a colour scale (using the range of values in column F to work itself out)?

Either way, the figures in column F would change weekly, so the relevant cells in columns A - D would need to automatically change when they're matching cells in column E - F change.

I hope this makes sense, as it's difficult to explain, but any help that someone could provide would be greatly appreciated.
 

A:Solved: Creating Cell "Cold" And "Hot" Spots Based On Values In Microsoft Excel 2007

Read other 16 answers
RELEVANCY SCORE 111.2

Hi there
sincerely hoping & wondering whether someone out here could help me by offering me your solution or suggestion ?

My situation is as follows:
In my worksheet there is about 600 cells scattered all over the sheet that are to represent different monetary value figures, that I have used NAME MANAGER to define as MONEDATA1, MONEDATA2, and MONEDATA3 (each holding around 200 cells, which is the approx.limit allowed by NAME MANAGER for Excel 2010). Thing is, my work revolves around dealing with 12 different countries of currencies, and so all these monetary cells, in CURRENCY format, thus need to be 1 out of 12 different currencies with respective currency signs, at any one time I do some calculation. So, they must convert into 1 of those 12 currencies, each time determined by a selection from a single dropdown list of 12 currencies located at the top of the worksheet in one particular cell I data validated, which is $C$6.

Now, I just need the worksheet to convert all the 3 groups MONEDATA1, MONEDATA2 and 3 simultaneously, instantly when 1 of the 12 currencies is chosen in $C$6, by using a VBA code. Is there a best way to resolve this need ?

Could you help me with the above problem ? Thanks in anticipation and advance ! Greatly appreciated any help.
cheers & have a nice day there,
Jason.
 

A:Excel data validation and executing a code based on selected value

 

Read other 1 answers
RELEVANCY SCORE 109.6

Hello to evrebody,
I have look into the answers and the solutions about "hide/unhide rows based on the cell data" but i am not abble to understand how its work and apply to my sheet.
On theattached sheet i explain what im looking for.
Pleaseo play it and hope to help me and give a solution please.
Thanks in advance.
Jose
 

Read other answers
RELEVANCY SCORE 109.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 109.6

I have an entire column of data that I need in one cell. When combined I need each piece of data to be surrounded by " " and a , between each one.

151
183
2001

results = "151","183","2001"
 

A:Solved: Excel Column of data place in one cell with "data", "data" results

ASAP's "Merge row data" ("Columns and rows" category) will do 99% of the work for you.

http://www.asap-utilities.com/

(edit: "entire column" -- do you mean full from top to bottom? )
 

Read other 2 answers
RELEVANCY SCORE 104

Sorry for the need help asap but I need this for work tomorrow and am pretty stuck any help would be great.
I'll try to explain clearly. In my worksheet there are 4 tables of portfolios. Each column is a month. The rows in the tables are "triggers" and "volumes". The triggers are prices to buy the volumes. For each month, there are 7 triggers (7 prices where you could buy a volume in a month). So lets say in Jan 12, Ill make a trigger (Trigger 1) in Portfolio B for $200.

My goal would be that the rest of the Triggers in that Month will now be "XXX" (or even highlighted red or something). In the previous example, Trigger 1 in Portfolio A,C and D is now "XXX".

I have attached a sample book.

I'm having trouble because I keep getting a circular reference. Like I said, this is kinda urgent so any help (even if its after tomorrow) would really be great- thank you in advance.
 

A:"Conditional Formating" for cell values in columns(Need help asap!)

So the way I have approached this conditional format - would require a lot of different formulas for each trigger

for Trigger 1
Two conditional formats
1) =(B3<>"") - set to STOP IF TRUE - this keeps the cell where you enter the price with NOFILL
2) =(OR(B3<>"",B25<>"",B47<>"",B69<>"")) - I use this and format the fill colour to be RED

ALL i'm doing with the OR is testing the 4 sections A,B,C and D to see if they have a value in , if they do then turn red

So that set of conditional formats - applies to trigger 1 in section A, B,C,D

So you can copy this Paste special > format - for section A l apply to trigger 1 - Type A, B,C,D and can be copied across the months

now for section B you need the same formula and cant just copy down - as it will move all the cells down , and if you use $ it will need to have all the $ written into the section A for the different triggers
so i had to copy in sections and add/remove the $ - took about 20mins to setup on the sheet

i suspect a macro is needed really

Any way , I have completed all the cells for Sheet After and for the Year

have a look at the conditional format and you should see what I mean about the copying bit
and you can see the way it works across all the different triggers and months

as i say a macro maybe easier - just depends how you are applying it
 

Read other 3 answers
RELEVANCY SCORE 101.6

Hi all,

I am trying to develop a cost calculator based on several drop down lists. I have used the following formula:

=AVERAGEIFS('Scope Of Work'!I:I,'Scope Of Work'!C:C,C6,'Scope Of Work'!F:F,'Cost Calculation'!D6,'Scope Of Work'!G:G,'Cost Calculation'!E6)

Cells C6, D6 and E6 in the Cost Calculation Tab are all drop down menus based on data validation. The formula works when all 3 cells have a selection value but I also want it to calculate if only one or two of the drop down lists have been populated, any ideas?

Thanks,

Mark.
 

A:Solved: Excel 2007 - Dynamic formula based on Data Validation List

Read other 11 answers
RELEVANCY SCORE 97.6

I haven't been able to find any hits on this when searching, although I have to expect it has been brought up before. It is behavior that I used to see in Windows XP, but have definitely noticed it in Windows Vista when running in the XP "classic" view.

I navigate the Start Menu Programs Group list and run a program. Everything is fine. I eventually put my computer in Standby mode. Later, I wake up the computer and go to the Start Menu Programs list again. This time, I may see one or two different behaviors:

The last programs group I accessed is now hidden from view. There is a double arrow at the very end of the programs folder list that when clicked, it shows the programs group that was hidden from view.The whole programs group list is almost completely hidden, except for the last couple of programs groups that I accessed in the last session. Again, the double arrow icon is at the end of the list and when clicked, the whole programs folder list reappears.

I find that this behavior is inconsistent, but most frequently happens after accessing Microsoft Office programs. Unfortunately, because I was familiar with this behavior in Windows XP, I didn't make a mental note of when I first started noticing it in Windows Vista (I've been using it on my laptop for over 3 years). It could be that it wasn't happening initially when I first got my laptop, or I simply didn't pay attention as the frequency was low. But, I've come to notice it more lately and I'... Read more

A:Peculiar "folder hiding" behavior in start menu programs list

It's not clear to what you're seeing. Are you talking about the list of programs shown when you click on the Start button? Perhaps you could post a screenshot.

Read other 16 answers
RELEVANCY SCORE 93.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 92.8

Hi,

Is it possible to hide the entire row if the formula result is "x". (in Excel)

In my spreadsheet, I have vast numbers of results that show up as N/A. This is the correct answer, but it's making the spreadsheet hard to read because of how many there are. It's easy enough to sort afterwards, but I was hoping a a more elegant solution existed?

Thanks for any help!
 

A:Solved: Hiding rows based on formula result

Read other 13 answers
RELEVANCY SCORE 92

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 90.4

I double-click and get "search" instead of "open"--only when I click a disk, like Hard Drive C: or Floppy A: or CD F: and so on.

It didn't used to do this, so I must've inadvertently changed some setting somewhere, but darned if I can find it now.

Any ideas?
 

A:Solved: On the "my computer" list, I double-click on disks and get "search" instead of "open"

Read other 12 answers
RELEVANCY SCORE 90.4

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 90.4

I have a sheet with several hundred rows. Starting in Row 4 through the end of the sheet are mixed dates in column 1 and ALL rows from Row 4 through the end of the sheet hidden. I want to be able to type in a date in Cell A1 and have all rows that have that date in Column 1, Row 4 through the end of the sheet to become unhidden. Secondly, I would like to type some other code like "999" or something in Cell A1 to have ALL rows become unhidden. Thirdly, I would like to either type another code or just delete anything in Cell A1 and have ALL rows from Row 4 through the end of the sheet to become hidden again.
Tech Support Guy System Info Utility version 1.0.0.4
OS Version: Microsoft Windows 7 Professional, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM)2 Duo CPU T6600 @ 2.20GHz, Intel64 Family 6 Model 23 Stepping 10
Processor Count: 2
RAM: 3963 Mb
Graphics Card: Mobile Intel(R) 4 Series Express Chipset Family, 1853 Mb
Hard Drives: C: 453 GB (298 GB Free); F: 931 GB (710 GB Free);
Motherboard: TOSHIBA, Portable PC
Antivirus: Webroot SecureAnywhere, Enabled and Updated
 

Read other answers
RELEVANCY SCORE 90.4

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 90.4

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 89.6

every time i try to open one of this folders a window apears with this content
cant have acces to C:\Documents and Settings\Mike\Local Configuration\{one of these folders} acces denied
this affects my IE i cant download nothing thru IE all my files on that locations i cant set dispaly pictures on WINDOWS LIVE messenger and all thinks that has anything to do with those folders
any suggsestions or idea
hope you can help me
pd ive scanned my computer and its all clean also i cant install windows XP serivce pack 2 im kinda stucked :/
 

A:cant open "temprorary files" "aplication data" "program data"

Read other 11 answers
RELEVANCY SCORE 89.2

Not a major issue, of course, purely cosmetic, but still a minor annoyance none-the-less:

I have a number of card reader drives that I never use (haven't even removed that plastic cover tape from them to help keep the dust out) that show when viewing the "Computer" window that displays drives. Is there any way to hide specific unused drivers from this view? Not remove drive entirely, of course, I may need to use one in the future, but just to hide them so they aren't visible, until I may chose to make them visible again?

Thanks as always,

Russell

A:Hiding unused "removable storage" devices from "Computer" folder

Hello Russell,

You could check Hide empty drives in the Computer folder in Folder Options to have them stay hidden until you insert a card. When a card is inserted, the drive will display in Computer.

Drives - Hide or Show Empty Drives in Computer Folder

Hope this helps,
Shawn

Read other 3 answers
RELEVANCY SCORE 89.2

Hi all, long time reader, first time poster. I searched around and have found similar queries to what I require however I haven't been able to adapt these solutions with any success so here we go....

I have a list of businesses in a spreadsheet with information such as name, phone number, e-mail, website, postcode etc. I would like a search box on the side, say in cell O2 where a user can input part or all of a postcode e.g. (LS19 or LS) and those that do not begin with LS would be hidden. The postcodes are in column G.

I'm trying to make this as simple and user-friendly as possible so employees can find businesses in a certain area with ease. Thanks in advance for any help and please feel free to ask questions.

Chris Needham
 

A:Excel VBA : Hide rows based on cell input.

Seems nobody had the answer so I found a work around myself. Just in case anybody else wants to do a similar thing. Using auto filter is the easiest way.
Code:

[SIZE="3"]Sub Search()
Columns("G:G").Select
Selection.AutoFilter
ActiveSheet.Range("$G$1:$G$999").AutoFilter Field:=1, Criteria1:="*" & Range("O2").text & "*", _
Operator:=xlAnd
End Sub[/SIZE]

Where G is the column to search for and O2 is the users input data.

Guess this can be closed now, thankyou all for your help.
 

Read other 1 answers
RELEVANCY SCORE 89.2

Excel Masters, I am not sure how to loop through the following code for multiple row formatting. The code works fine if the user has selected cells within a single row. However, when multiple rows are selected, the 'With ActiveCell' formatting only works for the first row selected. How can I loop the 'else' statement to format the ranges for all rows with a cell selected?
Private Sub Button_DeleteRow_Click()
Selection.EntireRow.Interior.ColorIndex = 3

msg1 = MsgBox("Delete this row?", vbYesNo)
If msg1 = vbYes Then

Selection.EntireRow.Delete

Else

Selection.EntireRow.Interior.ColorIndex = xlNone
With ActiveCell
Range(Cells(.Row, "AA"), Cells(.Row, "AN")).Interior.ColorIndex = 15
Range(Cells(.Row, "c"), Cells(.Row, "d")).Interior.ColorIndex = 15
Range(Cells(.Row, "a"), Cells(.Row, "a")).Interior.ColorIndex = 15
Range(Cells(.Row, "j"), Cells(.Row, "j")).Interior.ColorIndex = 15
Range(Cells(.Row, "n"), Cells(.Row, "n")).Interior.ColorIndex = 15
End With

End If

End Sub

On a related note, I already have a separate worksheet change event (ByVal Target As Range) running on this worksheet.
 

A:Solved: Excel Macro - Loop selected-cell formatting for multiple rows

Something like:

Selection.EntireRow.Interior.ColorIndex = 3

msg1 = MsgBox("Delete this row?", vbYesNo)
If msg1 = vbYes Then

Selection.EntireRow.Delete

Else

Selection.EntireRow.Interior.ColorIndex = xlNone
SelRows = Selection.Resize(, 1).Cells.Count
Cells(ActiveCell.Row, 27).Resize(SelRows, 14).Interior.ColorIndex = 15

'(and so on)

End If

?

On a related note, I already have a separate worksheet change event (ByVal Target As Range) running on this worksheet.Click to expand...

If you mean "how do I bypass that for Selection.EntireRow.Delete then:

Application.EnableEvents = False
Selection.EntireRow.Delete
Application.EnableEvents = True
 

Read other 2 answers
RELEVANCY SCORE 88.8

whenever i open task scheduler I keep getting the message

Error: selected task (o) no longer exists. To see the current tasks click refresh.

even after repeated clicking refresh the same message is displayed.

also on both task status and active tasks it says Reading data failed

wats happening?

A:Task scheduler (win7) fails to read data. Error: "selected task (o) no longer exits"

Can you not remove (o) from the scheduled task list?

If not then it might be that Task Scheduler has been corrupted by something, not sure how task scheduler is stored, but in system32 there is 3 files (taskschd.dll, taskschd.exe, TaskSchdPS.dll) that are all related to Task Scheduler, but not sure if any of them could be the cause of this issue.

Read other 1 answers
RELEVANCY SCORE 88.4

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 88

Install win7 x64 (ultimate) runs fine. After about a week, this error appears in when starting task scheduler.I know something is wrong because of scheduled task will not run, so I check task scheduler and get this error.So, I check the registry entries for scheduled tasks and make them match the %systemroot%\system32\tasks folder.The error goes away.... BUT  and this is what no one else checks, go ahead and click "display all running tasks".Good luck!  "Task Scheduler cannot access Task Scheduler"...  ie. media center will no longer wake up and record shows..defrag will not run.. nothing scheduled.  In some test installs, the machine will no longer go to sleep!!.(and yes.. I tried uninstall MCE and Reinstalling it along with any other apps)Task scheduler is still broken and will not function.  You can add a new task, but the normal required system tasks no longer exist. So Win7 is broke!!   Just becaues the Task {0} error is gone doesn't prove anything!After dealing with this for about 2 months straight I'm about to send Balmer screen shots of the damn error messages and ask why there are no answers for this or why is task scheduler locked out to to the local admin. Why are there not verbose debugging tools available so I can try and find out exactly what it happening?You see, I'm 99% sure something in windows is doing this and corrupting itself. It's not a external program.How do I know?? because in many of my test... Read more

Read other answers
RELEVANCY SCORE 88

I came across this error in the Task Scheduler when checking scheduled task and it happened as soon as the application was opened so I did a little searching and found out the first occurrence was due to the Defrag schedule and found a solution for that here :

[/URL][/IMG]

http://answers.microsoft.com/en-us/...s/01e60fa1-8004-40b4-9cf0-247fb80edb56?auth=1

So now that took care of that error and decided to check a few more folders and sure enough I located another error of the same having to do with the AppID folder in the TaskScheduler Windows folder and it seems as though the PolicyConverter entry is missing from the task scheduler in this folder and more than likely from the Reg. I have not done a search there yet but it is located in the Windows Task folder system files . I will cut to the quick here and ask shouldn't I be able to import export that entry from a system Reg that has the entry to the system that does not have the entry and reboot and go back into the TaskScheduler to see if the entry is there now ? Of course I would first back up the system Reg or probably just do a complete back up first the continue .

I have attached some more Images for anyone's ? if need be .

I preformed sfc /scannow more than once with no results .

The images below are from a working system .
 

Read other answers
RELEVANCY SCORE 86.8

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 86.8

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 84.4

Hi All,

My W8.1 laptop has recently started going to "Locking" mode when I press the power button (on the machine) and/or select "Shutdown" from the start menu. I've checked the power settings and the PC is definitely set for shutdown as opposed to some other function such as sleep, hibernate, etc.

So basically after I click or press the power button, the screen schows "Shutting Down" (as would be expected) but after a few seconds changes to "Locking". Once the operation is complete I'll need to tap any key (to wake it up) and then click shutdown from there. Only then will the machine fully shutdown.

I'm not sure how this behavior began but I haven't been able to trace it back to 3rd party software. ANy thoughts or solutions appreciated! Thanks.
 

A:PC goes to "Locking" mode when "Shutdown" is selected

Read other 7 answers
RELEVANCY SCORE 84.4

I am receiving these 2 error messages (see below). Message #1 pops up first and then is followed by Message #2

Message #1:

"hpqthb08.exe-strong name Validation Failed which says, (Strong name validation failed for assembly C:\Program Files\HP\digital imaging\bin\hpqthb08.exe The file may have been tampered with or it was partially signed but not fully signed with correct private key )"

Followed by Message #2:

hpqth08.exe Common Language runtime Debugging Services. Click OK to Terminate or Cancel to Debug

HELP!
 

A:ERROR MESSAGES: ""hpqthb08.exe-strong name Validation Failed..."

Closing duplicate to: http://forums.techguy.org/windows-nt-2000-xp/545998-error-messages-hpqthb08-exe-strong.html
 

Read other 1 answers
RELEVANCY SCORE 84.4

I am receiving these 2 error messages (see below). Message #1 pops up first and then is followed by Message #2

Message #1:

"hpqthb08.exe-strong name Validation Failed which says, (Strong name validation failed for assembly C:\Program Files\HP\digital imaging\bin\hpqthb08.exe The file may have been tampered with or it was partially signed but not fully signed with correct private key )"

Followed by Message #2:

hpqth08.exe Common Language runtime Debugging Services. Click OK to Terminate or Cancel to Debug

HELP!
 

Read other answers
RELEVANCY SCORE 84

Anyone--who's skilled in formula set up,

I am not sure if my formula (=IF(AND(E6="N/A"),"No Data",IF(OR(AND(E6="W"),AND(E6="L")),D6,"0")) is set up correctly--but does not meet my expections.

Can you please help me with this? Basically IF "WIN", copy # from other cell, IF "LOSE", put down "o" (zero). See attached-- to give you an idea of what I am talking about. Hope to hear from you by tonight? I need the answer before tomorrow's games.

Thank you.
 

Read other answers
RELEVANCY SCORE 83.6

Hi,

I have a couple of questions if you could possibly help me.

I have a cell where I want an employee to input the approximate (or actual) age of a person. To make this easier, I have created the following list - baby, child, 16-20, 20's 30's, 40+, Unknown. The problem is that sometimes the employee will know the exact age of the person - and I could do with capturing this information. Is there any way, other than elongating the list (adding on 0,1,2,3,4 etc), that the cell can be validated in such a way that you either input an actual age (say 00-100) or choose from the drop down list above?

The second question is -

I have 2 questions on an excel spreadsheet: -
1 - What is the number of clowns in the circus? Answer to be put in cell B3 (minimum 0, maximum 9)
2 - How many clowns had red noses? Answer to be placed in cell B4 (minimum 0, maximum 9).

Currently, both cells are validated to produce a drop down menu of 10 options - 0-9. What I want is to ensure the inability to place a higher number in cell B4 than B3. But I want to keep the drop down menu's (using list on validation). Can this be done?

Any help would be greatly appreciated.

Mark
 

A:Cell - Data Validation

It might help us to help you if you told us the exact program you are using.
 

Read other 3 answers
RELEVANCY SCORE 82.8

I have a cell that I want it to only be allowed to =0 when Cell B4="Yes" (it has a drop down yes or no). When B4="No" I want the user to be able to input any numerical value into C4.

I tried using Data Validation, by putting custom: =IF(B4="Yes",0) but then it errors when I try to input a value in C4 when B4="No"

Any ideas?
 

A:Excel: Make cell =0 if another cell = "Yes", but allow any value when it ="No"

Hi, welcome to the forum,
"I have a cell" well, there are more than one on the sheets I assume C4 is the cell where you want to enter any value except when if B4 = "No", correct?

Another importan thing, which version of Excel?
I suggest you use the on event and a datavalidation that only alloes numbers in C4.

I don't know how acquainted you are with sheet events or VBA for that matter

But see the attached file and put it to good use.
 

Read other 3 answers
RELEVANCY SCORE 82

So far i have read you can't do this. So i'm wondering how you achieve this the correct way. I work for a gas field company and the database i am redesigning has a lot of fields that need validation, like well site names, company names etc. The person who built the original database had no validation at all, and you could find the word Production spelled 12 different way sometimes. Made it very hard to keep data readable.

So the part im working on now is the well sites list. I have a table called Well Sites. I have a main work orders table where they must choose a well site which is a lookup of the well sites table. This is fine and dandy, however. If they choose not to use a name in the drop down list, they can simply type anything they want, which is what i want to avoid. I want them to ONLY be able to type names that exist in the well sites table.

I was hoping it would be as easy as setting up a validation rule but from what google is telling me that is not even possible. So how do i control what user's enter. I do NOT want to type in a list of 600 well site names using OR for a validation rule. That is unmanagable, but i need to restrict what they can type so we don't get mis-spellings and mis-labeled wells.

Now i understand some things but some things i've just never done before prior to now. If i setup a one to many relationship between two tables then it seems to work like i want. Only values that exist in the other table can be entered into... Read more

A:Field Validation based on another tables data

Read other 6 answers
RELEVANCY SCORE 82

I've worked up a Cricket scoring program, and I need a cell value to remain unchanged once it has been calculated. (For the game's aficionados, one value is runs scored at the end of each over, and another for runs total at each fall of wicket).
By trial and error I've got a sort of result, but I run into "circular function" error message on the first operation, but I can "cancel" out of that, and it doesn't occur again for the rest of the entries up to the final score result. So it's not an elegant solution. The rest of the prog's operations work perfectly.

As is plain, I'm no expert on Excel. Anybody have any ideas?
 

A:How to make an "Excel" cell value "stick"?

Read other 14 answers
RELEVANCY SCORE 81.6

I use XP Pro....
I keep my audio files in folders. And I don't know why every now and then when I open these folders all the files show in "Tile mode". I hate that and always convert them all to "List mode". But in a few days they go back to all showing in "Tile mode" again.

Is there a way to make all the contents of folders Always show in "List mode"?
 

A:Make folder contents always show as "List" not "Tiles"?

Read other 6 answers
RELEVANCY SCORE 80.8

I have a chart in an Excel spreadsheet, and it has several "series" in it. Some of the series are charted as "lines", and some are "areas" that fill in the entire background of anything from 0 to the value I have entered.

I have one particular series that is showing up as an "area" but I want it to be drawn as a "line" instead, so it DOESN'T fill in the area below it. I currently have the "background" as "none", but now I have a line from the last value down to "0", and that's what I want to avoid...

Thanks in advance!
 

A:Solved: Excel 2003 - how to change a chart data series from "area" to "line"??

Read other 8 answers
RELEVANCY SCORE 80.4

I have two disks configured: First C: is a active partition SDD. Second one is D:, which is old active disk and used now only for backups.
I'm starting with selecting no folders at all in the "indexed Locations".


<Screen shot will follow>

Next I select disk C. As result not the folder from disk C is taken over but from disk D:
<Screen shot will follow>
I have no chance to select any folder from disk C.
Index Rebuild does not help.

Read other answers
RELEVANCY SCORE 80.4

Hello

how can I delete "saved password" and "form data" of microsoft
edge manually ?!

after too much search in google ....

I trid to delete some value of the following registry address
HKEY_CURRENT_USER\SOFTWARE\Classes\Local Settings\Software\Microsoft\Windows\CurrentVersion\AppContainer\Storage\microsoft.microsoftedge_8wek yb3d8bbwe\MicrosoftEdge\

also I tried to delete some files in the following folder
%LocalAppData%\Packages\Microsoft.MicrosoftEdge_8wekyb3d8bbwe\

and finally I could not find the way ...!!!

please help !

A:delete "saved password" and "form data" from microsoft edge manually

Hi,
Welcome to the forums, go to settings (... dots from top right), click view Advanced settings and "Manage Saved Passwords".
HTH.

Read other 0 answers
RELEVANCY SCORE 80.4

I have a Sony Vaio Notebook running a Windows XP (Pro) operating system.
The Notebook cotains 2 drives. A "C" drive and a "D" drive.
I would like to add the "D" drive letter to the drop down menu of the "Send To" button.
Can anyone help me with this?

Thank you very much.
 

A:add a "drive letter" to the "send to" drop down list

Place a shortcut to the drive (or folder) you want to be the target in c:\Documents and Settings\"Your User Name"\SendTo folder. That is the directory from which the Send To menu is loaded. I'm looking at a win2000 system and the XP location may be slightly different but it's somewhere in there. If you put the shortcut in the "Default User" folder then whenever you create a new user, that user will have the same option.

Welcome to TSG -- stay a while.
 

Read other 2 answers
RELEVANCY SCORE 80.4

Hi there I have noticed that my drive letters shown in disk management are different from those being shown in "list volume" in the windows recovery console command prompt. Below are some pictures, number one showing my current partition setup with the drive letters and number two-four showing what is shown in "list volume" in the windows recovery console command prompt.

SEE PIC #1 ; SEE PIC #2, SEE PIC #3, SEE PIC #4

NOTE: If I do a "list volume" in a non recovery console command prompt the drive letters are shown as they are shown in disk management.

A:Drive letter in "list volume" WRE is different from "My Computer" Fix?

I believe that is normal since the recovery console assigns letters based on which partition it sees first. It is not aware of the fact that the System Reserved partition doesn't get a drive letter assigned as does Windows.

Read other 2 answers
RELEVANCY SCORE 80

I only get the BSOD when playing games, not any specific game, but any, sometime i can go a whole week of playing games and have no BSOD at all, and somedays 5 minutes after a game is running it will BSOD everytime, all day long. When I try to Run any game like GW2 Or Inquisition my pc turns into Bluescreen with an error CRITICAL_PROCESS_DIED or KERNEL_DATA_INPAGE_ERROR ..I've already Updated all my drivers and reinstalled all my games, also run chkdsk /f and memtest with no problems.


This is the screen:

Also this is my dump config:
(note that i have windows 8.1, not 7)

Still it doesn't create any File or Folder and when the BSOD happens the blue screen say that its collecting info but it doesn't get off 0% .
It's the same with the critical process died it just goes to the blue screen saying its collecting info but it also doesn't get off 0%.

I'm completely baffled with what to do as the blue screen view hasn't picked up anything and i cant find the dump files.
 

A:"Critical Process Died" & "Kernel Data Inpage Error"

Hi BTW, welcome to the TSG Forums....

You may find this from the MS Community helpful. If Greek is easier to understand than this article then come back to this Forum and someone will help you.

http://answers.microsoft.com/en-us/windows/forum/windows8_1-system/windows-81-bsod-kernel-data-inpage-error-and/b67ae41a-9228-4462-9c53-d1f5d115f784

T.
 

Read other 1 answers
RELEVANCY SCORE 79.6

All,

Ok, Here we go again. I have another very basic DB, that i have plans for later. Right now I just have one tbl/qry/frm/rpt. In the report I have some static labels, and I would like them to be visible/invisible based on data being present or not. I have attached the db. The code I thought would work is below. Let me know where I am going wrong if possible. Thanks
Code:
[SIZE="3"]Private Sub Detail0_Format(Cancel As Integer, FormatCount As Integer)

If Me.Wk_Zn_1_8_Tickets = True Then
Me.Label147.Visible = True
Else
Me.Label147.Visible = False
End If

If Me.Wk_Zn_9_15_Tickets = True Then
Me.Label152.Visible = True
Else
Me.Label152.Visible = False
End If

If Me.Wk_Zn_1_5_Tickets = True Then
Me.Label153.Visible = True
Else
Me.Label153.Visible = False
End If

If Me.Wk_Zn_6_12_Tickets = True Then
Me.Label154.Visible = True
Else
Me.Label154.Visible = False
End If

If Me.Wk_Zn_13_15_Tickets = True Then
Me.Label155.Visible = True
Else
Me.Label155.Visible = False
End If

End Sub
[/SIZE]
Let me know if you can help.....Thanks.

Nuschool33
 

A:Solved: Hiding Labels based on data in Access Report

Read other 11 answers
RELEVANCY SCORE 79.2

I just got a new Hewlett Packard computer with Windows XP. The CD drive is a combo CD reader, writer and DVD. The main reason I need it is to backup my many documents, database programs (RootsMagic family history, Quicken, etc.), photographs and drawings. The pre-installed burning program on the computer is Adaptec's (I think) Sonic RecordNow!, which is useless for my needs because of the way it works. The HP tech suggested I download DLA to enable me to use "drag & drop" through Windows Explorer, but I haven't had much luck with that, either. What I need is to be able to use a CD-RW as a giant floppy - to add, delete, copy, edit and move files, just as I do on my regular floppies, using "drag & drop" through Windows Explorer, or "save as...". What software do I need for this? Please use "baby-talk" with me, because I don't understand any of the initials, terms and technical language I see all over these forums. Thanks, Dellasha
 

A:Data backup and storage to CD-RW's using "Drag & Drop" or "Save as..."

The most versatile program for that is "Nero"
The latest version Nero6 Reloaded is a bit bloated, maybe the NeroMIX will do better for you. Read the specs here: www.nero.com

The part that interests you specifically is InCD.
 

Read other 5 answers