Over 1 million tech questions and answers.

T460p 3-cell battery

Q: T460p 3-cell battery

Can someone point me in the direction of a 3-cell battery that will work with the T460p? I know it'll only give me a few hours of juice, but I'd like a battery that is flush with the base for when I travel outlet to outlet. Thanks.

Read other answers
RELEVANCY SCORE 200
Preferred Solution: T460p 3-cell battery

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 60.4

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

Read other answers
RELEVANCY SCORE 60.4

Hi, all!

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

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

Thanks! Your help is appreciated.
 

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

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

Read other 3 answers
RELEVANCY SCORE 60.4

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

Read other answers
RELEVANCY SCORE 59.6

I use the Dell Inspiron 15r 5520 model laptop and i want to replace the battery. It cuurently works with a 4 Cell battery but I want to replace it with a 6 cell  battery. Is it possible to do so ? Else does it affect the system negatively? 

Read other answers
RELEVANCY SCORE 58.8

Upgraded from T420s to T460p by moving SSD with Windows 8.1 Pro x64. Updated all drivers and software with System Update and online scanner. Everything now works fine, except Lenovo Settings reports "No battery is installed". I do have a battery installed, and Windows shows charge status correctly. I have the same problem with a 2nd battery, so it's not the battery. InstallingLenovo Power Management Driver for Windows 8.1 (32-bit, 64-bit) - Laptop(more than once) has not helped. Everything is normal in Device Manager.Any thoughts?





JohnThinkPad T460p [ Win8.1Pro64 | i5-6440HQ | 16GB | 1TB SSD | WQHD | 802.11ac | BT | Cam | FR ]

Read other answers
RELEVANCY SCORE 58

I recently tried to replace my 6 cell laptop battery with a 9 cell. With the 9 cell install it will not charge and laptop will not operate on AC power either. Please help

Read other answers
RELEVANCY SCORE 58

Someone needs to get a new battery for a very old laptop they have. The battery doesn't work so they have to have it plugged all the time otherwise it wouldn't work. Laptop is 15.6 and sort of heavy but the thing is they never take the laptop outside the house. It will mainly be used on one floor in the house.


100% of the time the laptop is used in the kitchen area where there is a table where its connected using a charger to the wall. Thus if the person had a working battery, they could carry it around the house even though the laptop will stay in one place usually. However because right now the battery doesn't work, it does but it goes out very fast less than 1 minute, they need a new battery.


Is it better to get a 6 cell or 9 cell battery? The laptop will be used at home 100 percent. The thing is this person said if 9 cell last longer, get it. However, im sure 9 cell batteries make the laptop much heavier and has that back part sticking out right? I know this isn't a big deal if you going to stay inside but wouldn't it be a problem/annoyance if you have the laptop on yourself when on the sofa? Does the 9 cell would be really heavy on an already heavy 15.6' laptop?


Also 6 cell batteries last for around 2 hours i believe. How many hours does a 9 cell last for usually?


The thing is majority of the time the laptop will be plugged in but its very annoying at the moment as the laptop has to be connected 100 percent of the time since the battery is no good at... Read more

A:6 Cell Vs 9 Cell Battery for Laptop?

It's a piece of hardware so you're in the right area.

I have a Dell Inspiron N5010 that has a 48WattHour battery. A 9-cell battery would give longer working time when on battery-only so if it is offered and the price is affordable I'd get it.

As for physically working, it may lift the back edge of the Notebook higher but that's not a problem, usually have rubber feet on them. I find that type of rise is actually easier for typing as most Desktop keyboards have feet to raise the back edge, fingers seem to 'flow' better.

Read other 2 answers
RELEVANCY SCORE 57.6

Hi. After upgrading BIOS to 2.12 the CPU frequency is locked to the lowest possible (disregarding BIOS settings). Plugging in the battery makes it work again.For the sake of prolonging my battery life I ususally run without it when safely docked at home.Anyone else experiencing this? I assume it's a bug?

A:Bios upgrade to 2.12 on T460p locks cpu frequency to lowest when running without battery

It sounds like a bug might have been fixed.  I would expect it to slow down if you had just a battery (no A/C) or just A/C (no battery).  The charhing circuity won't "cook" the battery.  It will stop charging when it is fully charged.

Read other 1 answers
RELEVANCY SCORE 56.4

I use the Dell Inspiron 15r 3537 model laptop and i want to replace the battery. It cuurently works with a 4 Cell battery but I want to replace it with a 6 cell  battery. Is it possible to do so ?

A:Can i replace a 4cell battery with 6 cell battery?

It looks like it is possible - however, realize that the 6-cell battery is larger than the 4-cell and will not fit entirely inside the system  -it will extend beyond the rear of the system (along with adding weight, of course).

Read other 1 answers
RELEVANCY SCORE 54.4

I have bought my laptop, with 6-cell battery, and recently I have realized that it is just not enough/ 2.5-3.5 hours are good, but just not good iif you actually want to do something on your computer....
Anyway I heard about external 9-cell battery that can be plugged in to the computer, where can I buy? can you explain how it works please?

A:6-cell battery and the ext 9-call battery

A 6 cell battery for a laptop is pretty standard and is usually self contained right within the laptop. You can replace that 6 cell battery, with a 9 cell battery. Since the 9 cell battery has more cells and lasts longer, the battery itself is natually larger. So, they often either stick out of the back or out of the bottom of the laptop. Oh yeah, they also weigh more because of the extra cells.

Read other 5 answers
RELEVANCY SCORE 52

my laptop is HP ENVY dv6-7300ex Notebook PC can i find 9 cell battery original compatible with my laptop

A:Battery 9 cell

HP Part number: (17) Battery: 9-cell, 100-Wh, 3.0-Ah, Li-ion battery 672412-001 Manual p. 30 HP does not sell the battery directly from the Parts Store.  Here is a genuine on amazon.com: https://www.amazon.com/HP-Original-672412-001-DV6-7000-DV7-7000/dp/B00DETM3B8/ref=sr_1_3?ie=UTF8&qid... If this is "the Answer" please click "Accept as Solution" to help others find it. 

Read other 1 answers
RELEVANCY SCORE 51.2

Hi, can anyone who has a 12 cell battery for their laptop please tell me how long the battery lasts, and what laptop you use. I just want to compare different 12 cell batteries and how long they last according to the laptops they use. Thanks

A:How long does your 12 cell battery last?

I don't have a 12-cell laptop battery, but I just wanted to point out that there's cells and there's cells. The energy storage capacity of different "cells" used by different manufacturers varies widely, as does the current draw by different laptops. A 17-inch "aircraft carrier" laptop is going to consume a lot more juice than an Atom-based 9" unit with an SSD. Hence, their runtimes on a "12-cell battery" will be hugely different.

For what it's worth, I used to have an Asus 1000HE which ran for almost 10 hours on a 9-cell battery (win7), before it was snatched away from me by a family member who was quite happy to resort to underhanded hardware acquisition tactics.

Read other 3 answers
RELEVANCY SCORE 51.2

I believe that some desktop PC's have a rechargeable button cell battery on board? I've just had to dismantle an old machine and I found this particular battery on the circuit board. amazon.com/Newsun-CR2025-Coin-?irect/184-1019633-5016856

The text says "These button cells are not technically rechargeable" so are they saying that it is or isn't? If it really were, would it not be stamped onto the battery??
Just got me thinking about these types of batteries in general, anyone got more knowledge on the subject?
 

Read other answers
RELEVANCY SCORE 51.2

My netbook won't start up after a turning itself off a few times. I did drop the netbook and it's possible that fins, that connect the netbook to the no battery, are bent. I can't be sure that the problem is the cell battery, but if I buy one, could I try it and return it if it's not that?

What is the difference between a 6-Cell Li-Ion 4400mAh Battery and a 6-Cell Li-Ion 5200mAh Battery?
http://us-store.gateway.com/category.aspx?catid=53

A:I think I need a new cell battery for my netbook.

if it turns on while plugged in it will point towards the battery, but it could also be damage to the motherboard where the battery connects.
does the battery light show its charging when connected?
easiest way to see if its the battery is to use a volt meter, if the battery shows a greater voltage than that stated on the battery its self (e.g 18v will be about 21v when charged) then its not likely damaged

Read other 2 answers
RELEVANCY SCORE 50.8

I have recently purchased an Acer Aspire V Nitro VN7-591G-792U Laptop. It has a 3 cell Li Battery.One of the greatest issues with this model (other than heat) is short battery life.Is there a larger battery that can be purchased for this model? [Yes, I know performance takes current, current causes heat and drains batteries. I am asking if I can get a bigger fuel tank.]

A:Is there a larger battery (6 cell) for the Acer As...

Due to the nature of a intergrated battery, on top of the fact that this battery is probably-definitely custom made only for this type of model, I doubt Acer has a larger battery size for it, attributed to the fact that it would need to be bigger, and also not very much needed. If you need proof, look here: http://i1.wp.com/laptopmedia.com/wp-content/uploads/2015/03/main-text.jpg What I can suggest is that you go to Windows "Power Options" and mess with the controls to reduce battery use, it doesn't seem to do much, but it really, REALLY does. At the cost of performace, which is really only seen if you are doing heavy, intensive work.




First, CALM DOWN and look at my profile picture. Calm? Now post your message. If I helped, a Kudos would be great! Marking as solution will help others as well, thank you!

Read other 1 answers
RELEVANCY SCORE 50.8

i just baught a new 12 cell battery for this laptop. i needed longer battery life. i put the battery in the laptop and it fully charged over night. the battery is an hp battery. when i went to test the battery for an estimate of how long  it would last by removing the ac cord the computer imeditatly shut off. I've run all the tests i can think of and all test say the battery is good and fully charged. i put the old battery back in and it kept the laptop powered on with out the ac cord. i uninstalled the windows complience driver and let that reinstall.  any other ideas ideas?

Read other answers
RELEVANCY SCORE 50.8

I want to buy a laptop (17 ") with 9 cell Battery,because in HP & Dell sites they are saying it can stay up to 9 hours !
Some friends tell me its fake because a laptop have a high specs and 17" ant stay more han 5 hours !

A:Can 9 cell Battery stay up 9 hours ?

Hello Baxxter I have never used one of these batteries but a look here makes me think it is not worth the money; DELL 85 WHr 9-Cell Lithium-Ion Battery for Dell Latitude D620 Laptop : Laptop Accessories | Dell

Look at the ratings tab

Read other 9 answers
RELEVANCY SCORE 50.8

Hey

Can someone tell me if it's possible to get a 9 cell battery for the Satellite Pro U400-13G.
And if it is then what is the part number?

Best regards Anders

A:Can I get 9 cell battery for Satellite Pro U400-13G?

Do you know Toshiba Options & Accessories website?

Check this page:
http://eu.computers.toshiba-europe.com -> Peripherals & Services -> PS Options & Accessories

There you would find all compatible options.

As far as I know this battery could be compatible with the Sat Pro U400 series:
*Battery Pack (Li-Ion, 9 Cell, 6000mAh) PA3537U-1BRS*

Bye

Read other 2 answers
RELEVANCY SCORE 50.8

Hello,I'm looking to get a external 6cell battery for the Thinkpad T460. I cant seem to find one on the Lenovo website. I looked at other computer store websites but I cant find a 6cell battery for T460.I see ones for T440 or T450 but nothing for T460.Will the batteries for T440 or T450 work for T460?Also, am I correct in thinking that the battey with code'0C52862' will work for the T460? Thanks in advance,Jason

Read other answers
RELEVANCY SCORE 50.8

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

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

Read other 6 answers
RELEVANCY SCORE 50.4

I have Dv7t-7300 (C2Y65AV) and the battery finally died. I originally ordered it from HP brand new with 9 cell MU09 battery.Ebay is a disaster area - some listings have 6 cell battery under the MU09 name. The first battery did not charge pass 58%, second simply did not fit (it did not even have the OEM 4-LED test bar on the back).HP official one is out of stock http://store.hp.com/us/en/PDPStdView?storeId=10151&urlLangId=-1&productId=138247&urlRequestType=Base...I made a mistake and trashed the original battery so I don't even have the OEM part number!Where should I go to get the correct 9 or 12 cell battery?

Read other answers
RELEVANCY SCORE 50.4

Lenovo Community I'm in need of a new 9 cell battery for an older Lenovo model (T400) the Lenovo price is $179.00 (which is fine) but a see many other advertised prices as low as $33.00.  Anyone know why such a discrepancy. I would expect Lenovo?s prices to be "slightly? high but not as much as $146.00.  $33.00 is too good there is something I'm not aware of when it come to new batteries. Comments

Read other answers
RELEVANCY SCORE 50.4

My computer is an HP Pavilion dv6t-7000. I purchased a 9-cell battery as second battery and I switch it out from time to time with my other battery. I have never had a problem with it charging or keeping a charge. Suddenly, I find that it won't charge above 47% of capacity. Only two of the four LED lights on the battery will light up. It charges up to 47% and stops. It will show that the unit it plugged in but not charging.  If I was seeing a degradation of the battery over time, I could accept that, but this happened suddenly. Any thoughts or suggestions?

A:MO09 9 cell battery suddenly won't charge over 47%

Hello Geoaddict, Thank you for posting on the HP Forums! I understand the battery will not charge to 100%. To start, please try Testing and Calibrating the Battery. You should be able to find out if the battery has any issues.. If the battery appears to be fine, you can try to improve your battery performance.  For more information on improving battery performance, please review the following document: Improving Battery Performance (Windows 8, 7, Vista). If none of this helps, you can try purchasing a replacement battery if the computer isn't in warranty. If it is, you should be able to get a replacement over HP phone support. You can utilize this website to learn how to contact HP appropriately, based on your region: Contact HP Worldwide Please let me know if you have any other questions or concerns, and if this helped you. Thanks for choosing the HP Forums. Have a great day! Mario




I worked on behalf of HP.

Read other 2 answers
RELEVANCY SCORE 50.4

I have a two-year old Aspire One D270-1401.  I am pretty happy with it.  It runs Win 10 flawlessly, has allowed me to double the RAM to 4G (only 3+G of which is accessible since the system is 32 Bit). But the battery is useless and I need to run the computer constantly with external power.  The battery wasn't much use even after a year had passed; by now it's a paperweight. But I can't find a replacement.  Everywhere I find a so-called "replacement battery for AL10A31", it turns out to be a 6- or 9-cell battery that does not fit the computer correctly and prevents the display from opening beyond 30 degrees or so. This seems like terrible support for a computer that has so much possibility for longer term usefulness.  I know there are many good computers out there.  In fact, I have some nice 64 Bit systems I use on a regular basis, but this little gem is perfect for those apps that require a 32 Bit system; and it's wonderfully portable, also. Does anyone have any suggestions?

Read other answers
RELEVANCY SCORE 50.4

I have a new 12 cell battery for my acer 5535. Computer beeps a warning and shuts back down on start-up. Incorrect battery message. battery is a 12 cell, 10400mAh, AS09A41. The battery is made for an Acer 5517-5535. Does something need to be re-configured in the computer to accept the battery? The battery will run the computer if the computer is plugged in to the AC first and then the battery is installed, then unplugged from the wall. Both batteries are 11.1v
 

A:Acer 5535 won't accept my new 12-cell battery

The Acer Specs say "48.8 W 4400 mAh 6-cell Li-ion battery pack" The 12-cell may not work here
 

Read other 8 answers
RELEVANCY SCORE 49.6

It is supposed to be a 9-cell one, but works as a 6-cell now.It worked fine for the first couple months, but now it can only be charged to 75% around, the most.I tried quite some cycles by fully discharging it then fully recharging it, but it did not work out.It is manufactured by Panasonic.I trid another new 9-cell battery, but still the gauge only shows up to 75% around. It does not make any sense. I suppose it is a battary gauge problem, but resetting it does not help at all.I even reinstall the whole XP window system, but it did not work.Any ideas? Solutions? Any upgrade of the gauge software?

A:Z61m 9-cell lion battery cannot fully charged

Please Help! Anybody?Thank you!

Read other 9 answers
RELEVANCY SCORE 49.6

The stock coin cell battery that powers the cmos on my motherboard has japanese words, but it says CR2032 3V. If I put a Energizer or Panasonic battery of the exact type in there for example, will it work fine?
 

A:Will any brand of coin cell battery work in a motherboard?

You're in luck. Any make (panasonic, energizer etc) will work just fine. If your battery isn't already completely dead, remember to save your bios settings before removing the battery, or your setting will revert to default. If your battery is already dead, then no need to save your bios settings.
 

Read other 4 answers
RELEVANCY SCORE 49.6

I need to purchase an original Dell Precision 5520 laptop battery.
Li-polymer 3-cell (56 Whr) with ExpressCharge: Dell P/N YWYV6
I recently bought my 5520 with the 97 Whr 6-cell battery which occupies the space for the SATA hard drive.  I contacted Dell sales to buy the 3-cell but they do not have one available.

Read other answers
RELEVANCY SCORE 49.6

Hi there,
I ordered a Latitude E5570 from Taiwan Dell and opted for a 6-cell 84WHr battery (and M2 SSD as storage, knowing 6-cell and HDD cannot coexist in this machine), but disappointingly when the machine arrived I found out it was only equipped with a 4-cell 62Whr battery. Despite the 6-cell battery has always been marked as available on Taiwan Dell E5570 webpage, Taiwan Dell told me (only after the machine arrived) that it is currently unavailable, but they will not let me return the machine, because according to them it's not an option for customized products.
Frustration aside, right now what concerns me the most is whether or not the 6-cell 84WHr battery will ever be available for ordering from Taiwan Dell, and if not, how can I acquire it. I can't find this battery even on US Dell accessories website.I believe the part number of this battery is either HNH3K or WJ5R2.

Read other answers
RELEVANCY SCORE 49.2

HiJ have x260, No internal battey. only have 3 cell external. Instead of the internal battery is only dummy. can j replace dummy internal battery?thxv

Read other answers
RELEVANCY SCORE 49.2

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 44.8

Hello -  My x220 does not lock into  Mini Docking Station Series 3 that I bough recently. The rubber pads on the battery seem to be preventing the laptop from being docked. (Not sure if I am doing something wrong instead.) Also I am trying to set up a multi monitor display ( Dell U2415). Will appreciate some inputs on how I should resolve both the issues or a link if that has been covered before .  

Read other answers
RELEVANCY SCORE 44

i have a hp pavilion dv7-core i5,17.3" screen and the battery is a 9 cell li-ion-93hr but it can't go past 3 hours on battery power even on power saver mode and discrete graphics turned off(always on intel HD graphics)..is this normal?
i never game,just listening to music,watching movies and mostly browsing the internet.

A:9 cell battery not living up to its "potential"

It's impossible to say if it is normal or not because there are two many other variables that factor in. The only way to know for sure is if you had a lower cell battery to compare it to. Considering you have a 17.3" screen, 3 hours sounds like a great number. The larger the screen, the more power it draws. Typically, people with that large of a laptop screen aren't too concerned with battery power, as they aren't lugging it around that often. Those laptops are usually referred to as desktop replacements.

Read other 9 answers
RELEVANCY SCORE 44

So I made a post over on seven forums but I was told to bring it over here...

I have a Dell Vostro 3650 running Windows 8.1 The battery was giving me about 30 minutes battery life so I bought a new, 9 cell, OEM battery.The "Probl

em" with the 9 cell battery is that it seems that Windows 8 is not really detecting the battery? I'm not sure. It will only tell me "unknown time remaining". It will not give me a notification of when the battery is going to die (Except the physical red button lighting on the front of the computer).

In terms of battery life, the battery works fine. I get hours and hours of battery life so I know the battery is functioning properly. In the BIOS, it is detected as battery performing regularly. I don't know why it is not showing the time. I tried uninstalling the Microsoft ACPI drivers in device manager and rebooting but nothing changed. I was a able to SHORTLY borrow a similar laptop to mine, but running windows 7. The time remaining was being displayed.

My Bios version is on the latest version. Why is this happening

The Battery was bought directly from DELL.

I have tried calibrating the battery. How to Calibrate Your Laptop

I downloaded a program called battery bar... And while not perfect, the program is able to give me estimated time remaining.. Length of time the laptop has been on battery. Why can this program do it, but windows cannot?

A:9 Cell Battery Not Being " Detected" Windows 8.1

do you have dell quickset installed?

Read other 12 answers
RELEVANCY SCORE 43.2

I have a Dell Vostro 3650 running Windows 8.1 The battery was giving me about 30 minutes battery life so I bought a new, 9 cell, OEM battery.The "Problem" with the 9 cell battery is that it seems that Windows 8 is not really detecting the battery? I'm not sure. It will only tell me "unknown time remaining". It will not give me a notification of when the battery is going to die (Except the physical red button lighting on the front of the computer).In terms of battery life, the battery works fine. I get hours and hours of battery life so I know the battery is functioning properly. In the BIOS, it is detected as battery performing regularly. I don't know why it is not showing the time. I tried uninstalling the Microsoft ACPI drivers in device manager and rebooting but nothing changed. I was a able to SHORTLY borrow a similar laptop to mine, but running windows 7. The time remaining was being detected. My Bios version is on the latest version. Why is this happening?

A:9 cell Battery is not being "detected"

Hi have you tried calibrating the battery. On-the-Go articles | Dell

Read other 8 answers
RELEVANCY SCORE 43.2

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

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

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

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

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

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

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

Anybody know a workaround for the bug?
 

Read other 1 answers
RELEVANCY SCORE 43.2

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

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

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

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

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

Any help would be greatly appreciated.
 

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

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

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

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

Pedro
 

Read other 3 answers
RELEVANCY SCORE 43.2

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

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

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

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

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

Rollin
 

Read other 1 answers
RELEVANCY SCORE 42.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 42.8

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 42.8

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

Here is how the data looks now.

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

Here is how I want the data to look

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

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

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

Code:

Public Sub CopyData()

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

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

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

Loop

End Sub


Rollin
 

Read other 2 answers
RELEVANCY SCORE 42.8

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

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

Read other answers
RELEVANCY SCORE 42.8

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

A:Changing Cell Info, Date tracks when cell changed

Read other 6 answers
RELEVANCY SCORE 42.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 42.4

Using Excel 2003 in Windows XP

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

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

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

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

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

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

Read other 3 answers