microsoft.public.excel.newusers | Microsoft Newsgroups

I am trying to create a simple tool log that also incorporates a sign in/out sheet as a second worksheet. What I want is to be able to select (not using cut + paste) several rows and by simply being selected on "tool list" worksheet, temporarly copied into "sign_in" and "sign_out" worksheets. I need the data selected from sheet 1 "tools list" to fill rows (starting at 20) of the next 2 sheets, and then end user simply prints needed sheet, for employee to sign. This allows me to select only the tools that that employee is checking in/out at that time and print that list from a

6/3/2010 11:01:45 PM

=?Utf-8?B?Z3lycmE=?= <gy...@discussions.microsoft.com>

Sorting Problem

I have a large (800 rows X 20 columns) data sheet that I am trying to sort by numbers in column C. These numbers are from 7 to 9 digits in length. When I try to sort the sheet, Excel uses the left-most digit in this column across to right to sort. Nine digit no.'s beginning with 1 end up at the top and further down 7 digit numbers beginning with a 6 are included. When I recieved this data sheet this column was labled as General and I tried to change it to number. Any suggestions?

6/3/2010 1:22:11 PM

=?Utf-8?B?RW5nckpvaG4=?= <EngrJ...@discussions.microsoft.com>

Excel

How do I format inside a cell - each sentence on new line.

6/2/2010 11:18:13 PM

=?Utf-8?B?TUhpbGw=?= <MH...@discussions.microsoft.com>

NEW MENU - List of Files to Open

Hi, In Excel 2003, one could to create a new menu and then choose commands for such new menu. I used to create a list of files to open (different from the "most recent" list). How does one do it in Excel 2007? Thanks.

6/2/2010 4:52:09 PM

=?Utf-8?B?Q0Y=?= <...@discussions.microsoft.com>

The Day After ???

June 2, 8.00 am and everything running normal. What's happening ? Does anyone know ?? Regards John

6/2/2010 11:48:25 AM

"John" <jo...@newlook.com>

JUST DO IT

HI THIS IS KAJAL AGARWAL:- WE WRTEN ABOUT FOR UK GIRLS CONTENT. THERE PEOPLE ARE CULTURE AND THAT CITY STATUS ALL ABOUT. PLEASE VISIT FOR http://ukgirlsbody.blogspot.com PLAY CAR RACE GAMES AND FREE DOWNLOAD AND ENJOY YOUR MIND FRESH. FOR FUL DETAILS VISIT http://andhraonlinegames.blogspot.com

6/2/2010 9:13:42 AM

KAJOL <uknew...@gmail.com>

working with textboxes-VBA

I'm not new to excel but quite new to VBA. I'm doing a deficiency log and have 2 input forms. One for project info that will be linked to the same cells and I need to be able to call it up for edit but the cell/textbox links will always be the same. The other will accept text inputs and put them in a running named range and I need to be able to access the named range and the related cells so that the original entry can be edited or added to. Navigating the named range is working fine but the text boxes interaction is not working. On my first attempt, evrything worked great an

6/2/2010 6:38:55 AM

zxc <zxc.64bb...@officefrustration.com>

how can i group coloum

how can i group coloum in Excel.

6/2/2010 5:55:01 AM

=?Utf-8?B?eWFzZWVu?= <yas...@discussions.microsoft.com>

how do I use the daily calorie and fat percentage template?

I'm am new to MS Word/Excel 2007 and new to templates. I just downloaded the Daily calorie and fat percentage template and wonder how do I use it? Do I enter food and calorie amount and Excel enters calories from fat for me? Please reply. Thank you.

6/1/2010 8:29:01 PM

=?Utf-8?B?UmFlYjIy?= <Rae...@discussions.microsoft.com>

What Excel formula converts hourly wage to annual salary

I need help creating a simple formula that converts an hourly wage to an annual salary.

6/1/2010 8:24:05 PM

=?Utf-8?B?RW50cmUgTm91cw==?= <Entre N...@discussions.microsoft.com>

#VALUE! result when using defined name in formula

I am learning how to name cells and use these names. I tried to name a cell in my Summary sheet using the sum of cells in my Detail sheet. When I press enter, the cell returns a #VALUE! What am i doing wrong? Trina

6/1/2010 7:51:01 PM

=?Utf-8?B?VGFjcmllcg==?= <Tacr...@discussions.microsoft.com>

text column - via macro

Hi Can someone write a macro for me to text column with the folloing eg in Column A, I have 4602101 - AAAAABBBBBBBCCCCCC so, I want macro to separate as put 4602101 in column A and the text in column B

5/31/2010 11:56:01 PM

=?Utf-8?B?Um9oaXQ=?= <Ro...@discussions.microsoft.com>

The last day

Hi all Today is a sad day because tomorrow MS will close the Excel newsgroups. I want to say that I hade a great time in the Excel groups the last years. Sharing knowledge is a great thing After tomorrow we must use the MS forums and I hope it will give me the same fun as I hade with the newsgroups. Maybe this page will help you if you start using the MS Forums and not like the web interface http://www.rondebruin.nl/nntpbridge.htm Thanks everybody for everything, see you in the MS Forums -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm

5/31/2010 7:04:45 PM

"Ron de Bruin" <rondebr...@kabelfoon.nl>

How do I find older versions of a spreadsheet

I did a sort on a spreadsheet and the one column looks like it was not included, i have to find an earlier version of the spreadsheet and cannot remember how to find the instruction

5/31/2010 5:53:01 PM

=?Utf-8?B?UGVwcGVybWludA==?= <Pepperm...@discussions.microsoft.com>

Reverse Row Order?

I have a file where each row contains data about a geographic location. The order they are in is south to north. I now have a need to reverse the order. That is have them now list north to south. Thanks for your help.

5/29/2010 9:14:21 PM

trvlnmny <trvln...@yahoo.com>

Combo Box

Hi, how can i make this code work in Combo Box (Activex Control) to populate data fields in excel? I got it to work in Combo Box (Form Control) but it will not work in Combo box (Activex control). thank you Here it's the code: Dim LINDEX As Integer Dim LAddress As String Dim LPhoneNbr As String Dim LRow As Long Dim LFound As Boolean 'Retrieve project number number LINDEX = Range("F30").Value 'Move to PAYABLES Sheets("PAYABLES").Select LFound = False LRow = 3 Do While LFound = False 'Found matching project, now update address and phone number inform

5/29/2010 4:39:41 PM

josros60 <josros60.6471...@excelbanter.com>

Golf scores

I am trying to change the cell colour depending on the input against the actual Par . ie Column A = the actual par for each hole, Column B is the actual score if the input for cell B2 is greater than cell A1 the cell = Red """" """""" """" """ = to """ """ """" = Green """" """""" """""""" less """" """ """ """" = Purple Many thanks

5/29/2010 12:49:01 PM

=?Utf-8?B?UG9wIFN0dXJtYW4=?= <Pop Stur...@discussions.microsoft.com>

Data Analysis Toolpak for Student Treacher edition originaly insta

I bought a laptop with the MSOffice 2007 Student Teacher edition as an original installation. I can't see how do add the Dala Analysis Toolpak. Does anyone have any advice please?

5/29/2010 3:34:01 AM

=?Utf-8?B?cGpqZW56?= <pjj...@discussions.microsoft.com>

Header

I am new to this Excel 2007 and don't know how to put a title where the lettered columns are. I need it to be centered across 4 columns. Thanks for the help

5/29/2010 12:38:01 AM

=?Utf-8?B?QmVsaW4=?= <Be...@discussions.microsoft.com>

How do I swap data in columns and rows around?

I've exported a load of data into excel but the info in the columns I want in rows and vice versa. I'm sure there must be an easy way to flip them.. Can anyone help?

5/28/2010 1:07:01 PM

=?Utf-8?B?TW9ua2Vyb28=?= <Monke...@discussions.microsoft.com>

program link

Hello, I know it's possible to enter a website url into a cell, and then open the website by clicking on the cell. Can I do the same thing with one of my own programs? i.e. open a program by clicking on its name or shortcut in a cell? If so, how ? Thanks KK

5/28/2010 11:51:23 AM

"KRK" <tre...@yeleek.nospam.freeserve.co.uk>

Rephrasing Interior.ColorIndex 36 question.

How can I write a formula for a column of colors, (some have numbers, some don't) that will go down the column and look for Interior.ColorIndex 36 (light yellow) and return the number of cells down that particular color is located? Cell A2 Interior.ColorIndex 36? No. Could be blue, but not wanted. Cell A3 Interior.ColorIndex 36? No. Could be white, but not wanted. Cell A4 Interior.ColorIndex 36? No. Cell A5 Interior.ColorIndex 36? No. .. . . . Cell A218 Interior.ColorIndex 36? YES! Answer in formula cell A1 would be 216. First cell is question, last cell is the color, so th

5/27/2010 11:21:01 PM

=?Utf-8?B?TGluZGE=?= <Li...@discussions.microsoft.com>

Conditional formula with an if statement

I am wanting to create a "envilope" budget sheet and have ran into a problem. What I am trying to do is make everything in Column B all negative unless I put a figure in Column A, which would make the Column B Positive. Example: Column A Column B Deposit Car (nothing here) $50 (this will show up negative) $500 $500 (This figure will show up positive) I want to be able to add numbers in both column A and B but reflect the appropriate sign as an expense (with nothing being added into deposits) or as income, when I deposit

5/27/2010 10:04:43 PM

=?Utf-8?B?VHlsZXIyMDA2?= <Tyler2...@discussions.microsoft.com>

How DO I get the bold face toggle to show

Can someone tell Both the standard formatting toolbar to show For example B for bold the Dollar sign $ and back ground bar like the color icon to appear

5/27/2010 9:59:45 PM

=?Utf-8?B?QnJ1Y2UgUGxpemFrIGUtbWFpbCBicGxpemFrQHlhaG9vLmNvbQ==?= <Bruce Plizak e-mail bpli...@yahoo.

Data conversion: Text to Numeric to Support Averaging

I have a mix of grades (academic achievement) in numeric (98, 86, etc.) and text (A, B+, etc.) format that I need to average for a final grade. While I can use LOOKUP variants to display the text as numeric, I have yet to figure out how to manipulate the text so it can be AVERAGEd with the numeric data. I am not totally new to Excel; however, I figured there are smarter folks in the community that may have already wrestled this issue into a solution. Congratulations! Please share your results...thank you!

5/27/2010 9:57:17 PM

=?Utf-8?B?RnJvZ3M1?= <Fro...@discussions.microsoft.com>

How do I hyperlink from spreadsheet to content within a word?

I am trying to link a Word document content (inside the .doc) to my spreadsheet. I need help with this as the on-line help shows how to hyperlink between spreadsheets or xls file and Wed based info. I can not see anything instructions on how to do this with word.

5/27/2010 9:15:59 PM

=?Utf-8?B?S2F0aHkgV2lsbGlhbXM=?= <Kathy Willi...@discussions.microsoft.com>

Finding last occurence of Interior.ColorIndex 36

I have been searching for a formula to help me find the last time (most recent) color 36 appears in a column of colored cells. Most of the time there is no typed information and when there is, it is not the same for every color 36 cell. The cells are not conditionally formatted. C. Pearson's site is great, but I can't find what I need. I don't want to change color, I don't want to know how many times it shows up, I just want to find the last time it is in the column. I could count down to find it, but there are over 15,000 columns spread over several worksheets. I have Excel

5/27/2010 9:11:49 PM

=?Utf-8?B?TGluZGE=?= <Li...@discussions.microsoft.com>

Excel 2007 will not refresh cells

I am currently using Excel 2007. I have a spreadsheet that I want to use to do some analysis of various situations. So here is my problem. I have several columns that have totals at the bottom. I have no problem getting the columns to total initially. However, if I plug in another number in the column, the total stays the same and won't refresh or re-total the column. I don't recall that this was a problem when I worked with Excel 2003. Can someone please tell me how to get the totals to update when I enter some new numbers in the column? Thanks in advance for the help.

5/27/2010 9:07:31 PM

=?Utf-8?B?RFk=?= <...@discussions.microsoft.com>

Formula Help PLEASE!!!!

17 worksheets transferring data to a summary page complete! Except for.... I have J2 who's contents are 200, and I have L2 who's contents are 0 (until someone enters something). Now I need to make M2 =J2-L2, BUT I need M2 to stay 0 until someone enters a number into L2. When I put the formula into M2, it of course says 200, but this looks really bad to the higher ups. Is there any formula that I could use for this issue? Now M56 is the total of M2:M55 which I want to transfer to the summary page, but don't want it to have any numbers until L2 is filled in. I hope I expalined t

5/27/2010 8:44:23 PM

=?Utf-8?B?V2F5bmUgQ2FkaWdhbg==?= <WayneCadi...@discussions.microsoft.com>

Excel Invoice followon autonumbering

Hi Can anybody help me please I have designed an invoice, I want it to assign a new invoice number everytime a new invoice is generateded. Please could somebody give me an answer in clear jargon free wording, as I am really new to excel and I havent got a clue what I am doing. Many thanks, Chris

5/25/2010 8:53:01 PM

=?Utf-8?B?Y2p3MDY0?= <cjw...@discussions.microsoft.com>

New To Formulas - Help please

This is probably very easy, but im having trouble - I want to find a formula that does the following IF H49 + G49 = F49 and F49=I49 then True If it doesn't False I want both parts to be used. If I was only doing the first part of the formula, before the AND, I can get as far as the following =IF(H49+G49=F49,"True","False") it is the 2nd part I am stuck on, how do I show the AND F49=I49

5/25/2010 6:15:03 PM

=?Utf-8?B?a2lyc3Rpa2F0ZQ==?= <kirstik...@discussions.microsoft.com>

How to insert static time using a laptop?

New to this. Sorry if very simple question. I'm using a laptop and the suggested method of inserting static date and time of hitting CNTL+ doesn't work. Is there another method? Thanks much.

5/25/2010 6:08:01 AM

=?Utf-8?B?RCBQaWNrZW5z?= <D Pick...@discussions.microsoft.com>

excel 2007 csv gibberish

I'm using Office 2007 English. When I open a previously saved csv file that was saved containing Hebrew text, it opens as gibberish. When I open saved Excel file that is Hebrew it opens correctly. Why would cause this to happen suddenly?

5/24/2010 10:03:09 AM

"Fran" <...@my.com>

How do I calculate monthly gains/losses in excel

For a family budget how would I calculate monthly gains/losses in Excel?

5/23/2010 6:53:01 AM

=?Utf-8?B?cmFnaW5ncml2ZXIzMA==?= <ragingrive...@discussions.microsoft.com>

Formula returned in vlookup function

I've used vlookup for a while now in the office 2003. Just converted to office 2007. Now when I do a vlookup I get the formula displayed in my current cell instead of a returned value. I can't figure our what I'm doing wrong. Can someone help? Thanks bmc

5/21/2010 4:31:01 PM

=?Utf-8?B?ODd2ZXR0ZQ==?= <87ve...@discussions.microsoft.com>

I would like to convert my dollar totals into a bar chart format

I am attempting this for the first time and would appreciate help. Thank you.

5/21/2010 3:48:01 PM

=?Utf-8?B?c2hpcmxleXdlc3Rvbg==?= <shirleywes...@discussions.microsoft.com>

AND - OR

Is it just me, or are the AND and OR functions reversed logically? Is there a tutorial somewhere on how to use them? The help files in Excel are their usual confusing self. Jim

5/20/2010 7:57:26 PM

RST Engineering <jwei...@gmail.com>

Excel format conversion

Hi guys, is there a way to convert the following 123456789 to 123-456-789 or abcdefghi to abc-def-ghi I need to convert a long list of serial numbers so I can look for them, but doing it one by one will take me an eternity. Thanks

5/20/2010 5:23:01 PM

=?Utf-8?B?QWFyb24gSA==?= <Aaron ...@discussions.microsoft.com>

Re:formula to convert 15 minute to hourly data

This formula should work: =AVERAGE(OFFSET($B$2,(ROW(A1)-1)*3,,4)) this averages range B2:B5 copying down will automatically change it to: =AVERAGE(OFFSET($B$2,(ROW(A2)-1)*3,,4)) which averages range B5:B8 -- Best Regards, Luke M "penny" <abby@hotmail.com> wrote in message news:... > Message-ID: <32af0b05d7ed4af89105200502fb35a4@newspe.com> > X-Mailer: http://www.umailcampaign.com, ip log:68.45.155.120 > Newsgroups: microsoft.public.excel.newusers > NNTP-Posting-Host: 22.bb.5446.static.theplanet.com 70.84.187.34 > Path: TK2MSFTNGP01.phx.gbl!TK2MSFTNGP04.phx.gbl!newspe.com >

5/20/2010 3:12:09 PM

"Luke M" <lukemor...@nospam.com>

spreadsheet switches to bold involuntarily messing up figures

This is Microsoft Office 2003. I'm typing out end-of-year audit for accountant. sometimes when I type in a number in the column,it changes to bold automatically without me asking it to.This totally messes up the total figure at the bottom of the column. what am I doing wrong?

5/19/2010 6:36:01 PM

=?Utf-8?B?bG92ZWx5IGxhdmVuZGVyIGxhZHk=?= <lovely lavender l...@discussions.microsoft.com>

Calculation

In one colum I have different years eg. 2009, 1979, etc.. In the next column I have 2010. What I'm trying to do is subtract from each colum to show how many years a person has been in employment eg. 2009 joined company 2010 left company. I know I can do =2010-2009, but how do I drop the formula. I have tried putting in the colum eg. =a-b, but this doesn't work. If I do it the other way I have to do it individually. Can anyone help?

5/19/2010 4:14:01 PM

=?Utf-8?B?S1RDNTM=?= <KT...@discussions.microsoft.com>

Continued Headers on successive pages in an Excel document

Hi, I am using Excel 2007. Headers on my first page (in Columns A3, B3, C3, and D3) are as follows: Date Test 1 Test 2 Daily Average I would like these headers to continue to the successive pages. How do I do this? Thank you.

5/19/2010 12:58:01 PM

=?Utf-8?B?bW9vbg==?= <m...@discussions.microsoft.com>

Find and Replace

Could you please elaborate what is the function of Control Find and Replace. Especially when using it to replace a formula to a new coloum

5/19/2010 2:44:01 AM

=?Utf-8?B?Ymlv?= <...@discussions.microsoft.com>

create text effects in excel

MS Word allows you to go to FONT, TEST EFFECTS and make the text "blink" on and off. Can you do the same in MS Excel?

5/18/2010 11:05:01 PM

=?Utf-8?B?cGFuZGE=?= <pa...@discussions.microsoft.com>

Conditional Formatting

Hi I run Excel 2K Conditional Formatting in Excel 2K only allows three conditions to be applied. I need 8 conditions. What I have is 8 check boxes that indictate TRUE or FALSE depending on wheather the check box had been ticked or not. Check Box 1 linked to cell IN2 Check Box 2 linked to cell IO2 Check Box 3 linked to cell IP2 Check Box 4 linked to cell IQ2 Check Box 5 linked to cell IR2 Check Box 6 linked to cell IS2 Check Box 7 linked to cell IT2 Check Box 8 linked to cell IU2 I would like to nominate a cell (say U2) that changes colour depending on which of the

5/18/2010 10:25:01 PM

=?Utf-8?B?Sm9obiBDYWxkZXI=?= <JohnCal...@discussions.microsoft.com>

Pivot tables

I have a pivot table. The columns are month and rows are sales people. I want to display the grand total for the current month from the pivot table in another cell. The pivot table is based on a named range so the grand total line may not always be in the same row. Is that even possible? If so could someone please point me in the right direction. TIA gls858

5/18/2010 7:22:50 PM

gls858 <gls...@yahoo.com>

Help with If statement

I have this If statement in H12 and it works except when E12 is blank I want H12 to be blank. =IF(E12=0%,"Closed",IF(E12=100%,"closed","open")) I'm not sure how to make that happen. Could someone please help me. TIA gls858

5/18/2010 3:25:58 PM

gls858 <gls...@yahoo.com>

Please Help!!!

I am trying to find a function to solve my problem. I'm not really sure if there even is one. Pretty much what I need is if G3 <10, then I need H3 to =G3xB3. If G3>10 but <24, then I need H3=G3xC3. and finally, if G3>24 then H3=G3xD3. I'm not even sure if this makes sense to anyone but me, I'm obviously no math whiz and even worse at excel so please help me if at all possible!!!

5/18/2010 2:38:02 PM

=?Utf-8?B?QURXMTU4Nw==?= <ADW1...@discussions.microsoft.com>

Opening any excel document NOTHING shows

I am using Excel 2007 and when I open any excel sheet/work book, new or existing, I have a totally blank sheet. Nothing shows unless I shrink down the sheet/workbook and then restore it. Does anyone have any ideas? on what I can do to resolve this, other than to continue shrinking & restoring. Thanks.

5/18/2010 11:56:01 AM

=?Utf-8?B?a2lyc3Rpa2F0ZQ==?= <kirstik...@discussions.microsoft.com>

how to make a bar graph

how do i take off the chart and put a bar graph in excel

5/18/2010 4:09:01 AM

=?Utf-8?B?bG9scHJpbnpl?= <lolpri...@discussions.microsoft.com>

Pages: 2 3 4 5 6 7 8 9 10 11 12 13 14 15

Newest Articles

Window Live Mail Auto Forwarding
25 min. 28 sec. ago

Win32.Gael.3666 got past Windows Defender
3 hour 29 mins ago

ANN: IT COULD GO DOWN INTO THE 40's TONIGHT HERE IN THE WINDY CITY SUBURBS!
3 hour 57 mins ago

ANN: THE PRICE OF SPEEDING TICKETS IS GOING UP HERE IN ILLINOIS!
4 hour 1 mins ago

ANN: OBAMA WANTS 2 SPEND ANOTHER 50 BILLION!
4 hour 13 mins ago