Over 1 million tech questions and answers.

Create a list from Google Sheets difers if it is horizontal

Q: Create a list from Google Sheets difers if it is horizontal

Hi!

I'd like to get a few cells in a list from a Google Sheets.
I have the following data:
First list horizontally: 1 in C2, 2 in D2, 3 in E2
Second list vertically: 1 in C5, 2 in C6, 3 in C7
Here is the test sheet: https://goo.gl/UDooqL

I use the following script:

function onEdit(){
var tabla = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var aktivcella = tabla.getActiveCell();
if(aktivcella.getColumn() == 1 && aktivcella.getRow() > 1){
var vizszinteslista = tabla.getRange(2, 3, 1, tabla.getLastColumn()).getValues();
var fuggolegeslista = tabla.getRange(5, 3, tabla.getLastRow(), 1).getValues();
Logger.log(aktivcella.getValue());
Logger.log(vizszinteslista);
Logger.log(fuggolegeslista);
tabla.getRange("E8").setValue("a script lefutott");
}
}

This results in the log:

[<<timestamp>>] Igen
[<<timestamp>>]] [[1.0, 2.0, 3.0, , ]]
[<<timestamp>>] [[1.0], [2.0], [3.0], [], [], [], []]

Why the two list differs?

Thanks.

Read other answers
RELEVANCY SCORE 200
Preferred Solution: Create a list from Google Sheets difers if it is horizontal

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 59.2

under file word and excel show by default the last 4 documents created/modified. I have this set for the max - I believe it was 8 or 10. I am not sure why but as of this morning, this has defaulted to 4 and I cannot remember or find how to change it back to the max. l
I looked under options but don't see it there.
Can anyone please help me.
 

A:List of recently opened docs or xls sheets

Tools > Options > General. This may vary according to version, but basically you're looking for the Recently Used Files List (AKA "RUFL") setting.
 

Read other 2 answers
RELEVANCY SCORE 58.8

Hello..

type
xyz
xyz
xyz
ccc
ccc
ccc
ccc
ccc
ccc
zzz
zzz
zzz
zzz

etc... but several thousand rows each with their own "type" ordered by type

how can i create a separate spreadsheet for each type...

dont know what this process is called...

surely there is a faster way than copying each type and pasting into a new xls doc...

(dont want to create tabs)

Thanks for any advice
 

A:Solved: how can you create multiple separate sheets from one sheet xls?

Read other 6 answers
RELEVANCY SCORE 55.2

Original post in 2009:

https://social.technet.microsoft.com/Forums/windows/en-US/94f1ad37-9110-4273-a473-ed02e36af386/is-there-a-way-to-disable-explorer-automatic-row-scrolling-in-list-view?forum=w7itproui
Example: You have a folder open with pictures in it. The Explorer window for said window is in List view mode, and at least 2 rows are visible.
The file you want to open is in the 2nd row. When you click the file, it automatically scrolls the list so that the file you selected is in the left-most row, rendering any double-click on the 2nd or subsequent rows ineffective. Instead of opening the file,
it selects the file, immediately scrolls it's row back, selects the new file that has scrolled into that row in the same position and scrolls it back as well. 



Is it possible to institute a small delay on the automatic scrolling to allow for double-clicking or disable the behavior entirely?



Sorry if this has been covered before, I couldn't find any relevant info through searching.
There is a lengthy discussion, including feedback from Robinson Zhang that the discussion would be forwarded to development. But no changes. 
The auto scroll without a delay is terrible--it makes dragging/dropping into subfolders a nightmare, because the window is always scrolling to the left as soon as the icon enters the window. An extremely poor feature which desperately needs to be addressed.

Read other answers
RELEVANCY SCORE 54

I'm trying to sort columns A, B and C alphabetically so that the correct # in Column A corresponds with columns A and B.
Thank You,
Gary
 

A:Google Sheets alpha

Well Column A are numbers in numerical order. The sort will not change because it's in order already.

What column are you looking to be in alphanumeric order?
 

Read other 1 answers
RELEVANCY SCORE 54

Hi All,
I am a secretary of a football club and I am looking to make a membership database using Google sheets which I can sync to Google drive and allow me to update while in the club office or while I am on my home PC.
As well as a database of members names and addresses, I would have column's for member type, DOB, email and a photo which I would like to open up in another page when I click on it


I was wondering if someone out there would have any ideas of how I could make this as I'm a bit of a novice.
Thanks in advance
Brianljnr
 

A:Google Sheets Question

Brian, you can probably find instructions at Google Docs \ Sheets Help.
 

Read other 1 answers
RELEVANCY SCORE 53.2

As mentioned in the heading, is it in any way possible to reset several checkboxes all at once?
 

Read other answers
RELEVANCY SCORE 53.2

Hi all, lurker and infrequent poster here with a few questions about scripting buttons in google spreadsheets.
(Please be patient with me - my only relevant-ish experience here is with MatLab)
 
 
I am setting up a google sheet for people to suggest items for the office and for others to vote on them. For each item, I want there to be a "yes" tally and a "no" tally, rather than a single tally that takes the difference. In order to stop people from cheating and just filling in a cell with whatever value they want, I am using buttons scripted with Google's apps scripts. (If you haven't used it, this youtube video gives a simple explanation, and is similar to what I'm doing: ).
 
So far, I have my rows (items) with two buttons each (yes/no). I was hoping there was a way to automate the creation of these buttons, so more are added as people add more suggestions to the bottom of the list. I'm guessing the easiest way would be some master button that "refreshes" and adds the buttons to a row only when the item-name column has been filled in. The problem is, I can't figure out how to create a new button from within a script.
 
My other concern is how to stop someone from voting on an item more than once, as this spreadsheet will be accessible to them as many times as they'd like. I will be sharing it to our email list, so only someone logged into their email can access this. I'm sure I can track it this way, but I don't know how to get that informat... Read more

Read other answers
RELEVANCY SCORE 53.2

Hi all, lurker and infrequent poster here with a few questions about scripting buttons in google spreadsheets.
(Please be patient with me - my only relevant-ish experience here is with MatLab)
 
 
I am setting up a google sheet for people to suggest items for the office and for others to vote on them. For each item, I want there to be a "yes" tally and a "no" tally, rather than a single tally that takes the difference. In order to stop people from cheating and just filling in a cell with whatever value they want, I am using buttons scripted with Google's apps scripts. (If you haven't used it, this youtube video gives a simple explanation, and is similar to what I'm doing: ).
 
So far, I have my rows (items) with two buttons each (yes/no). I was hoping there was a way to automate the creation of these buttons, so more are added as people add more suggestions to the bottom of the list. I'm guessing the easiest way would be some master button that "refreshes" and adds the buttons to a row only when the item-name column has been filled in. The problem is, I can't figure out how to create a new button from within a script.
 
My other concern is how to stop someone from voting on an item more than once, as this spreadsheet will be accessible to them as many times as they'd like. I will be sharing it to our email list, so only someone logged into their email can access this. I'm sure I can track it this way, but I don't know how to get that informat... Read more

Read other answers
RELEVANCY SCORE 52

I am using conditional formatting with a custom formula in Google Sheets to fill color the minimum and maximum values in a column.

The minimum works just fine:

Code:
=$AG:$AG=min(AG:AG)
But if I change min to max nothing in the column gets highlighted.

Code:
=$AG:$AG=max(AG:AG)
The range is set to AG2:AG25
 

Read other answers
RELEVANCY SCORE 48.8

I recently created a data c.d. with over 100 files on it .Would anyone know how I could create a List of Contents? I have tried copy function in "detail view" and this works, but I can't paste contents into Excel, "new letter", Microsoft Word , Notepad, Word pad. I was successful in doing a print screen ,this would require several prints.
The CD is a 700MB CD-RW and I used Adaptec software , the "add contents" to cover did not work. (I doubt you could read 100+ lines) . Ideally 1 full sheet of paper that I could fold and place inside, would be o.k .

OS windows 200 pro
 

A:Create A List Of Contents

Read other 9 answers
RELEVANCY SCORE 48.8

For my Archos 70 Internet Tablet 250GB:

How do I create an MP3 play list ... ???

I can only play one song at a time, which is annoying. I'd like to be able to play all the songs in a folder, or create a play list ....
 

Read other answers
RELEVANCY SCORE 48.4

I know there's a command prompt to do this, but it only works on the current folder. I have folders within folders and I need a program to easily list all those files.

A:Want a program to create a list of my files

dir /s
lists current and all child folder contents

Read other 0 answers
RELEVANCY SCORE 48.4

Just moved to Windows 7 from XP and struggling with Windows Live Mail (amongst other things!). Very basic question but I can't find how to add a new Contact list.

A:WLM 2011 -how do I create a new Contact list

Did you save (export) your old contact list as a CSV or WAB file? Or do you want to add the contacts individually?

Click on the "book" down in the left bottom corner. This will take you to the contact list. You can add them there individually or click on Import in the header ribbon and import your saved file from XP.

Read other 5 answers
RELEVANCY SCORE 48.4

Iím having trouble creating a distribution list with Outlook 2003 on XP Pro SP3. I know how to do it, have done it before, and just did it with the same rev Office on our laptop under Win7. When I try to create one, I get the attached error msg. My outlook.pst file is not on the C partition (on purpose), but this is nothing new and Outlook knows where it is. Email works fine and the contacts list works fine. I donít use the address book. Any ideas?

Thanks in advance.
 

Read other answers
RELEVANCY SCORE 48.4

Hi, I don't even know if what I want to do is possible.

I'm creating an html slideshow with over 600 entries, so I need to list all of the file names in the code, separated by a comma. The file names are all the same except for the numbers being sequential. Example: slide001,slide002,slide003,... Is there any program that can generate a text file like this? Typing this out would be incredibly tedious.

Thanks in advance.
 

A:Solved: Create a sequential list

Read other 16 answers
RELEVANCY SCORE 48.4

Hi, I'm using Outlook 2007 on Windows 7. Let's say I have 1000 general contacts in my Contacts list. I would like to create a new group or contacts category out of 250 of those contacts, and call it "Art Galleries." I've been researching for hours on how to do this, and can't find any useful directions. I can right click contacts in "Contacts" and "categorize" them. But when I create this "search folder," nothing shows up. In the "Contacts" view of Outlook, I can "Add New Group." It's easy! You just click "Add New Group" and name it. But then what? You get a new group, but how do you add contacts to this group? What I essentially need to do is this:

1 -- Create a specific group of contacts: eg. Art Galleries
2 -- I want to be able to open this group so that I can see all members
3 -- I want to be able to do (2) things with this group: a) email members of the group individually, and b) "Mail Merge" entire group to Word as mailing labels.

Can someone please provide specific instructions (or a link to instructions) on how to create this specific group, or contact list, or category (whatever it's called)? I can do the mail merge by selecting contacts one by one, it's creating the separate list that is being problematic. Thanks so much!

Read other answers
RELEVANCY SCORE 48

I needs some info on dependent list in excel to create validation. Please find below my example.

one work sheet has the employee detais in two differnt columns(A and b) master data.
Eg;
sat - Manager
sai - DBA
sss- Manager
xx - Team leader
AA- Seniour programmer.

i want to implment the validation in another worksheet based on the above master data. Eg: This sheet has 3 columns.
Designation, Employee name and Salary,

Once i type the designation in that column then Employee list needs to filter based on the inputted designation. Example if i enter Manger then employee list needs to display sat and sss only. it sould not allow other names.

Please Note : Macro is not allowed.

Regards
Raghul
 

A:Dependent list in excel to create validation

Read other 7 answers
RELEVANCY SCORE 48

Hello,

I have Outlook 2003 and have been added as a delegate to someone's mailbox with full rights. I would like to create a distirbution list with the other users contacts, but I'm unable to.
I go into create new dist list, click on "select members" and it doesn't show the other users contacts. Only the global address list along with my own contacts.
How do I set it up so the other users contacts do show up in that list.

I did do a search on the internet and can't seem to find the answer. I found a lot mentioned going into their contacts properties, click on Outlook Address Book tab and selected "show this folder as an e-mail Address Book" and then give it a name, which I have done.

Your input is appreciated. Thanks.
 

A:Unable to create a distribution list as a delegate

Anyone?
 

Read other 2 answers
RELEVANCY SCORE 48

I am wanting to create a distribution list in Outlook 2007. But I don't want to add each email address in my contact lists. Is that possible?
Thanks!
 

Read other answers
RELEVANCY SCORE 48

Hi all,

What would be the best way to create and print roughly 1500 barcodes?

i am wanting to create a barcode which is either a number or text (predefined) and then print the labels on the A4 sheets you can get.
how would people suggest doing this? i haven't found any software up to now that can do this out of the box. there looks to be a lot of free options out there so ideally i would like to use one, has anybody done anything similar?

any pointers are appreciated

JPL
 

A:Solved: Create Barcode labels from list

Hi, I haven't done what you are planning, I did hoever try it once (out of curiosity) and all I did was download some barcode font and make sure that my text was conform the barcode requirements and that worked.
I remember using Google to find it.
 

Read other 3 answers
RELEVANCY SCORE 48

Dear All

I am hoping to get helped with a macro or a formula which can select best students for limited seats

for example for a course of "ch" i have 4 seats, i want to select best students who can have "ch" based on their score. then i will go for other course "el" and same for all

i have included a dummy data for information, and wanted result on another sheet. if possible different sheets for different courses can be made
For the students who are assigned to specific course, should not be included in other courses.
Its kind of a merit list for different courses.

Please help
 

A:want a code or formula to create merit list

Read other 11 answers
RELEVANCY SCORE 48

Hi,

I cannot find clear concise info on creating a distribution list for my client. He has Windows 8 and Hotmail.

Please advise,
Thanks,
John
Microsoft Certified Systems Engineer

Read other answers
RELEVANCY SCORE 48

hi,

I'm hoping someone can help me perfect a script/batch file etc that will list my folders that do NOT have a particular file extension in it, currently I've been using something similar to the below which would create a list of all directories on the X drive containing jpg files but what I really want is a list of all the folders where I forgot to add the jpg for instance, having to go through the list and comparing to the full folder list to look for differences is too time consuming and often leads to some being missed:

X:\>dir x:\*.jpg /w/o/s > \jpglist.txt
For example, using the above .jpg extension as an example imagine I had:

X:\2009pictures\holiday.jpg
X:\2010stuff\work.jpg
X:\2011work\reminder.txt
X:\2012pictures\holidaysnap.jpg
X:\2013\todo.doc

I'd like an output text file that says:

X:\2011work
X:\2013

Since these are the folders that do not contain any jpg files.
Really hope someone could help with this, would save me loads of time. I saw an old thread where someone was asking about a similarish type of subject ages ago and got some helpful replies so really hopeful a kind person on here can come to my rescue!

DOS - list files in folders without path

A:DOS - how to create list of directories without a particular file extn

Code:

dir /b /s x:\|find /v /i ".jpg"
Replace x: with actual drive letter

Read other 7 answers
RELEVANCY SCORE 48

I have many folders with names of clients and would occasionally like to print a list but without retyping them I can't seem to do that. I also have photos that I would like a physical list of but again without retyping them all.
Any ideas?

A:How can I create a list of folders in WORD without retyping them all?

Hello, this is a little bit of a crude way of doing it but it will work.

Click Start>Run. Type 'cmd'. In the command prompt change the directory to the folder you want by typing 'cd /D FOLDERLOCATION' and click enter. An example: 'cd /D C:\Folders'.

Then type 'dir' and press enter.

This will list the folder names as well as a few other bits of information. Right click within the command prompt and select mark. Highlight the text and click enter to copy. Then paste into word.

Another command is 'dir > C:\Folders.txt'. This will save the information on your C: Drive in a text file called folders.txt.

Simply open the txt file with notepad and copy the contents into word. You will probably have to remove some of the other information like folder size.

I hope this helps.
Dave

Read other 9 answers
RELEVANCY SCORE 47.2

I'd like to start keeping a tally on these, if anyone else has ideas please share! Often hidden devices and services block malwarebytes and other .exe tools like hijackthis.example:Please begin by clicking Start > Control Panel > System > Hardware > Device Manager > View > Show Hidden Devices? Scroll down to Non-plug and Play Drivers and click the plus icon to open those drivers.? Then search for TDSSserv.sys? Others: legacy_gaopdxserv.sys, legacy_msqpdxserv.sys? Let us know if you find this or not.? If you do find it, right click on it, and select Disable. Do not try to uninstall it.? Also if TDSSserv.sys is found and you disable it, then you must reboot immediately.? After reboot continue on with other cleaning instructions you may have been having problems running.my list so far from various posts and experiences:Then search for TDSSserv.sys? Others: legacy_gaopdxserv.sys, legacy_msqpdxserv.systdss(other random characters) - variant of tdssserv.sysuac(other random characters) - I have seen this on winxp machines which is a red flag. SKYNET(other random characters)ab56sy26 (or similar 8 character random name)dda7731akbiwkmqowtskqwUACrgwrubqholgoodlist?1394 ARP Client Protocol, AFD, ASCTRM, ASPI32, Bepp, dmboot, dmload, EABFiltr, Fips, Generic Packet Classifier, HTTP, IP Netowrk Address Translator, IPSEC driver, ksecdd, MBAMSwissArmy, mdmxsdk, mnmdd, mountmgr, NDIS Sytem Driver, NDIS Usermode I/O Protocol, NDProxy, NetBios over TCIP, Null, Parport, P... Read more

A:Help create a list of common fake hidden devices

is it common for the fake ones to have a yellow flag near/issue flag?

also is it a good idea to create a whitelist/goodlist or will that lead to more issues (viruses using legit names)
added:
"serial" to the bad list

Read other 4 answers
RELEVANCY SCORE 47.2

Hi all, I am starting to have a lot of pinned items on my taskbar. Is there a way to add some into a list I can expand from the taskbar. Here is what I have at work on my XP. Something similiar would be useful!



Thanks Hornet

A:Create Taskbar Pinned Items Into an Expandable List

Maybe set the taskbar setting to never combine might work you can try it:

Taskbar Button Grouping - Enable or Disable

Read other 6 answers
RELEVANCY SCORE 47.2

I want to create a list of all files in a child folder.
There are about 300 files of various file types in the folder
- would it be possible to create such a list in cmd.exe window

If so how would I do that ?
- in the past I have dabbled with commands to release stubborn drives but that is the extent of my experience.

I think I need to CHDIR to the target folder but I dont know how to then create a complete list of files in the cmd window
- I am a little out of practice writing script to create a new TXT file with the list of files.
- Wiki - List of DOS commands looks promising so I thought cmd.exe might be easier and quicker than script

Thank you

A:How can I create a list of files contained in a child folder

Hello Russell,

You might see if the context menu below may work for you for this.

Context Menu - Add View and Print File Directory

Read other 3 answers
RELEVANCY SCORE 47.2

I know that the outlook and microsoft word have the mail merge to create labels. However, I could not find a way to create a LIST (not label) only, so i can send someone else my mailing list. Basically, I want to create mailing list by using my outlook contacts without retyping the contact information in a table form or whatnot.

Please help me
 

A:Not create labels but LIST to send to others to use for mail merge

You can use File/Export to create a csv file which can be imported into most email programs or used as an Excel spreadsheet.
 

Read other 1 answers
RELEVANCY SCORE 47.2

I am trying to find a way of creating a drop down list that will include more that one column of information.
My cell that I wish to select from the drop down is A1.

I have a list of items on a separate worksheet or further down to select from the drop down list is; column A includes a description of a product, column B is the price and D is the type.

I would like that when I select the product in the drop down list (for example from A11), that the price (from B11) and that the type (from C11) also will stay with the product and appear in all 3 cells; A1= product, B1= price C1= type. so the price and type would remain with the product regardless if they were not chosen.

A B C
Product Price Type
Shoes $2 Sports
Sandles $3 casual

So If i was to select shoes in the drop down, it would appear in cell A and $2 would appear in cell B and Sports would appear in cell C
 

A:How to create a drop down list that includes more than one column of data?

Kisongo,

Hi, and welcome to the forum. You could use a userform for what you want. If you want to go that route I could or some one else may be able to do it. I'm not sure how what you want can be done with a formula. May be some one with more knowledge may be able to do it that way.

Take a look at the attachment. This is something I put together for another user. It can be modified for your purpose.
 

Read other 2 answers
RELEVANCY SCORE 46.8

Using Google Sheets. Why am I getting this error msg? "Cannot sort a range containing merges." I DON'T have any merged columns, or merged anything. No hidden columns, or at least they weren't hidden when I tried to do the sort.

I tried to attach the file as a XLSX, and CSV, and both formats gave me an error.

A:Error Msg "Cannot sort a range containing merges." in Google Sheets

Quote:
try selecting all cells, then click Format > Merge cells > Unmerge


https://productforums.google.com/for...cs/b1B5ZswXytE

A Guy

Read other 3 answers
RELEVANCY SCORE 46.8

So, I've been looking up the topic for quite a while and it's suddenly become critical to what I am doing. Everywhere I have looked, I see lots of ways to copy multiple sheets into one sheet. This doen't do me the least bit of good. I have two 70+ tab spreadsheets. One for actuals, one for forecast. I need to copy the actuals for the first 5 fiscal periods of the year into the Forecast file. As there are 70+ sheets, I would prefer not to do this one at a time. In know in the previous versions of Excel, I could simply highlight all the sheets, highlight the data I needed, hit copy, and paste the data in the new sheet. So long as the sheets were laid out the same, it was never a problem.

Do you have any idea how to do this now?

Thank you.
 

A:Excel 2010 copying multiple sheets into multiple sheets

Read other 7 answers
RELEVANCY SCORE 46.4

I just installed Google Drive and I'm trying to get used to using it. Under "Create" (this is on the web) I see no option for creating a new folder. When I watch the tutorials they all have a "folder" option there. I can create folders from the desktop Google drive.......

Any advice appreciated.
 

Read other answers
RELEVANCY SCORE 46.4

It's difficult to describe my situation in words, so I'll just show you what I'm trying to do.

I have a table that looks like this:

A, B, C
Name, Hours, OT hours
Jane, 166, 0
Jack, 163, 17
Mike, 168, 0
Dot, 167, 24
Erin, 164, 8
Carmen 158,0

and I want to create a list that will have 2 rows if there are OT hours, and 1 if there are not.

A, B
Jane, 166
Jack, 163
Jack,17
Mike,168
Dot, 167
Dot, 24
Erin, 164
Erin,8
Carmen, 158

I can't use macros or VBA. It has to be formula driven. I can use a helper column or two. The starting table will change depending on who charged hours where. I've been trying to use IF and OFFSET and ROWS to do it, and it works until there's 2 consecutive rows that have OT hours.

Just to clarify, I just need to know how to get column A listed properly elsewhere in the spreadsheet - I can derive Column B using vlookup.

Thanks so much!
 

A:Solved: MS Excel: create list based on data in a simple table

2 Formulas - 1 for finding the name, the other for finding the appropriate value.
Note - must start on row 3 or greater.

Names (mine start in cell G3): =IF(G2<>"",IF(G1=G2,INDEX($A$2:$C$7,MATCH(G2,$A$2:$A$7,FALSE)+1,1),IF(VLOOKUP(G2,$A$2:$C$7,3,FALSE)>0,G2,INDEX($A$2:$C$7,MATCH(G2,$A$2:$A$7,FALSE)+1,1))),$A$2)

Hours (mine start in cell H3): =IF(G3=G2,VLOOKUP(G3,$A$2:$C$7,3,FALSE),VLOOKUP(G3,$A$2:$C$7,2,FALSE))
 

Read other 3 answers
RELEVANCY SCORE 46.4

Hi 
I'm new to developing excel add-on.
I'm trying to add a drop down list to a cell, this is what i have done so far
  Range ddlRng = worksheetname.Range[
                    worksheetname.Cells[firstRow, Column],
                    worksheetname.Cells[lastRow, Column]];
                ddlRng.Validation.Add(XlDVType.xlValidateList, XlDVAlertStyle.xlValidAlertStop, XlFormatConditionOperator.xlBetween, "Opt1,Opt2,Opt3", Missing.Value);
at validation.add() line it throws an exception saying "Exception from HRESULT: 0x800A03EC"
and this is the StackTrace 
"   at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)\r\n   at Microsoft.Office.Interop.Excel.Validation.Add(XlDVType Type, Object AlertStyle,
Object Operator, Object Formula1, Object Formula2)\r\n   at MS.ProductionPlanningTool.Excel.CommonPack.ControllerServiceClass.AddMaterialVersionList() in D:\\MidasCloud\\CloudTFS\\ProductionPlanning\\MSP2\\MS.ProductionPlanningTool.Excel\\CommonPack\\ControllerServiceClass.cs:line
1892"

Read other answers
RELEVANCY SCORE 44.8

Hi My friends,

I use excel 2003 and want to create a drop-down list right after selecting a choice from another drop down list.
For example: from a first drop down list of different brand of cars, the second drop down list is created listing different models of the brand of the car that i just picked up in the first list. Lets say we have three list and we want to select and make a drop down list according to a choice from another drop down list.
Is that possible doind this without using macro and instead using only the validation data / List and source?

Other question: from a choice from a drop down list, a pain brush picture will be displayed on another excel cel. is that possible?
Can someone please help? Many Thanks.
 

A:How do I create a drop down list from another drop down list?

Read other 9 answers
RELEVANCY SCORE 42.8

when u type like "L" and the list comes up with all the things that uve searched for that start with "L" how can i delete all those? there has to be a way. answer fast.

A:on google, the list that comes up...

Shift & Delete.

Read other 2 answers
RELEVANCY SCORE 42.4

Hi,

i was trying yesterday to find out for several hours how to create in Outlook 2000 distribution list with names chosen upon one, specific outlook "category"... I know how to create distribution list itself... I know how to make outlook to show me all names in my address book with this specific category... BUT, how mix it together and in the end receive distribution list with all names of this category included, I cant do it, i am too big idiot comparing to MS coders.... ((

Yours, but very sad and disappointed about my mental possibilities

Jazzek
 

A:Outlook 2K: How to create distribution list based upon certain outlook category???

Hi Jazzek -- I just did this, with the help of Russ Valentine at the MS Outlook newsgroups. Here are the instructions he sent me (and I used successfully):

"Change the Contacts Folder View to Categories. Right click and drag the
desired Category to
a newly created sub folder then choose Copy. Make sure the new sub folder
has been enabled as an email address book by right clicking on it and
choosing Properties and Outlook Address Book Tab and checking the box to
enable
as email address book. Create your Distribution List but make sure the Show
Names drop down field points to the new sub folder then shift select all the
contacts and voila."

I hate cruising the MS Newsgroups, as the interface is so weird and searching the archives is a total pain on their site (and incomplete in my newsreader), but I DO occasionally get help there.

Hope this helps. If I've misunderstood your problem, post me back.
Carol
 

Read other 1 answers
RELEVANCY SCORE 42

Hi everyone, you know when you're on the google home page and you double-click the input field where you enter your search words; you get a dropdown list showing previous seaches you've done. Well, is there any way to disable this feature? ....this might be an IE thing, I'm not sure. I'm using IE6 if that matters.

Thanks
 

A:Google Dropdown list

Read other 9 answers
RELEVANCY SCORE 42

hi all
i want to know how to delete the things that google save when u search about something like in this pic
 

A:how to delete google list?

double click on the bar to get that history dropdown like shown in the image aboce, then move your mouse over the top word "barbi" then start taping your delete key
 

Read other 2 answers
RELEVANCY SCORE 42

Hiya,

Newbie to Techguy!

I wonder if anyone can help me. I wanted find out if there is a way of deleting or amending the dropdown list that lists all the searches on google or other search engines.

Please see attached print screen of what i mean.

Any help or advise would be appreciated. Thanks
 

A:Google dropdown list

ok follow this:

Open Internet Explorer

Tools/ internet options/ content tab/ autocomplete

uncheck web addresses

then go to internet options / general tab

and click on clear history
joan
 

Read other 3 answers
RELEVANCY SCORE 42

This morning I received the following e-mail request for help from a friend.QUOTE: you know when you get google up and type in a web site you want, and then search, and the next time you do it a lit of everyone you have ever contacted comes up, is there a way of deleting any of the names, my granddaughter says she has never found a way. I have got loads of them which I don't use any more and the list is getting longer. UNQUOTE I know what she means and I hope you do also! Is there a way of removing this helpful completion of a URL when entered into the GOOGLE search box? My thanks in advance.

A:That Helpful Google List

Try clearing your Internet History, Temp files, Form Data, etc in Internet Explorer - Tools.

Read other 10 answers
RELEVANCY SCORE 42

I would like to somehow copy the "Now Playing" list from Windows Media Player and get it into a word processor to edit as I like. Unless I'm missing something obvious there does not seem to be any "Print" or "Save List" or similar option. I've tried highlighting the list and using Copy and Paste but that doesn't work. Any ideas?
 

A:How can I create an editable "Now Playing" list in WMP?

Save the now playing list as a playlist first by clicking the drop down arrow and 'save playlist as', choose 'M3u' in the save as type drop down box.
Then go to the saved playlist file and open directly with word. (right click it, open with, word) You'll have your editable info ready to go.
 

Read other 2 answers
RELEVANCY SCORE 42

Hi!

I just wonder, what's the difference (if any) between creating a regular YouTube account directly on www.youtube.com, and creating a Google Account that's linked to YouTube? If I go for the Google Account, will I still have a username on YouTube like "Decoy8" to log in with and that will be shown on comments and such, or will it be my email address?...

I do have a YouTube account today, a regular one that was created prior to the Google acquisition. But I was thinking about creating a new one, and I'm trying to decide if it should be a YouTube only account or a Google Account that works with YouTube.

Has anyone tested this? I mean if there is no difference, then why is there a option to create a regular YouTube account or a Google Account linked to YouTube?...

Thanks!
 

A:Should I create a YouTube or Google Account?

Read other 8 answers
RELEVANCY SCORE 42

In google chrome, under new tab, there are few shortcuts which leads to applications or some websites. Like the youtube and gmail bookmark app comes preinstalled. However, i was wondering if it is possible for user to make such a bookmark app/icon of their favourite sites in "new tab".

A:How to create Bookmark app for Google Chrome?

not sure if you can modify the default tab page you want but there is a speeddial app that will do exactly what you want. Just go to your app section and do a search for speeddial. There are several to choose from.

Read other 1 answers
RELEVANCY SCORE 42

I am wondering why google chrome have so many process when I never even browsing(0 TAB)?
I thought that was normal but i open up firefox and ie to try.. they used 1 process only o.o

A:Google chrome create a lot of process

I checked my chrome and with just one tab open in chrome I see 3 entries in the Task Manager. If I open a second tab, I see one additonal task manager entry.

Read other 9 answers