Computer Support Forum

Dates not populating on Excel Spreadsheet

Question: Dates not populating on Excel Spreadsheet

windows nt 6.1 vlookupI've created a spreadsheet in Excel. I've also created a calendar on a separate sheet. I need for the dates on the calandar to populate onto the spreadsheet. I know the VLookup formula. However, it's not populating onto my spreadsheet.I'm using Windows NT 6.1.

Relevance 100%
Preferred Solution: Dates not populating on Excel Spreadsheet

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

Answer: Dates not populating on Excel Spreadsheet

Let's start with the fact that your OS (Windows NT 6.1) has nothing to do with this. VLOOKUP is an Excel function, unrelated to the OS version.Next, you said:I know the VLookup formula.You might, but we don't, nor do we know how either of your spreadsheets are laid out. Since we can't see your workbook from where we're sitting, there is no way for us to offer any suggestions related to your issue.Perhaps if you posted some example data, along with the formula you are using and the expected output of that formula, we could be of some assistance.Before posting any example data, please click on the following line and read the instructions found via that link.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 85.69%

My spreadsheet is several pages long and I had a date column using the format mm/dd/yy. Excel is replacing my dates with x's or numbers. What do I need to do to keep my dates?

Answer:Excel is changing my spreadsheet dates to x's or numbers

Are the numbers five digits like: 41357If so, then it's possible those are DATES, Excel stores dates as a number representing the number of days since 1900-Jan-0Try reformatting the numbers and see what you get.As for the X's, are they X's or Hash Marks: ###If Hash marks, it just means the cell is to small to display the date,if there X's then I have no idea.MIKEhttp://www.skeptic.com/

5 more replies
Relevance 84.46%

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Enterprise, Service Pack 1, 32 bit
Processor: Intel(R) Core(TM)2 Duo CPU E7500 @ 2.93GHz, x64 Family 6 Model 23 Stepping 10
Processor Count: 2
RAM: 3037 Mb
Graphics Card: Intel(R) G41 Express Chipset, 1294 Mb
Hard Drives: C: Total - 305242 MB, Free - 67280 MB;
Motherboard: LENOVO, To be filled by O.E.M.
Antivirus: System Center Endpoint Protection, Updated and Enabled

hello

i am new here i might stumble a bit, my apologies in advance. i am a Marine engineer by profession and now i have been helping out in the office since we don't have a Technical Manager, my computer software skills are also limited that is why i need help.

i have 45 crew reporting to me with all sorts of certificates with different expiry dates. i have managed to compile an excel spreadsheet with their names including certificates but since i am in between operations and the office i need excel reminders to my emails and to one nominated person at least 60 days before expiry to avoid catastrophic shipping delays while people are revalidating their certificates.

please find attached spreadsheet with names and relevant certificates (highlighted in green). your assistance will be forever appreciated. i will be glad if i can able to do it by myself so when changes are needed i can just execute them. thank you in advance.
 

Answer:excel spreadsheet with expiry dates auto reminders

I would not be able to code this, but a coder would have needs/questions:

1. A worksheet with Name and Email address. This is so that info does not need to be hard-written into the code.
2. When do you want it emailed? When you open the file? Automatically, even if you don't open the file? With a button click by you?
3. What version of Excel and Outlook are you using?
 

1 more replies
Relevance 75.44%

Hey everyone,

I've got kind of a tricky one here. I need to have client information from three separate excel spreadsheet, auto populate a master list. I don't have the option of using access, so I'm left trying to use macros and visual basic programming.

The issue is really the sort and filter functions. I can bring the data from all three sources, and each client has a unique ID code. But replacing duplicate records and merging the rows from different spreadsheets is proving difficult.

Does anyone have any suggestions of an alternate way to achieve this? Or even some tips on the excel functions I should be using? Anything is appreciated.

Answer:Populating Master Spreadsheet w/o Access

There could be some useful information here:
Top ten ways to clean your data - Excel - Office.com

Filter for unique values or remove duplicate values - Excel - Office.com






Quote:
Third-party providers

The following is a partial list of third-party providers that have products that are used to clean data in a variety of ways.
Provider Product
Add-in Express Ltd. Advanced Find & Replace
Merge Cells Wizard
Add-Ins.com Duplicate Finder
AddinTools AddinTools Assist
J-Walk & Associates, Inc. Power Utility Pak Version 7
PATools PATools Advanced Find Replace
Vonnix Excel Power Expander 4.6
WinPure ListCleaner Lite
ListCleaner Pro
Clean and Match 2007

4 more replies
Relevance 66.83%

I have entered a column of dates showing just the day and month e.g. 15/10 (15 October). I wish to include the year (last two numbers) - is there any way this can be done without having to enter each date separately ? I tried using 'Format - Numbers - Date' entering the correct year in the first cell and then dragging the mouse over the required cells, but then I get '03' as the year regardless of what I initially entered.

Answer:Dates on Works spreadsheet

Could tell us the software your using? I'm using Xp Office, and that does it how you want it done.

4 more replies
Relevance 66.42%

I have no idea if this is even possible, but I would like to create a spreadsheet that auto-populates a series of dates based on one date that the user enters. Let's say I have a goal date to complete a project, and for every project I work on, something needs to happen 6 weeks prior to the goal date, another thing needs to happen 4 weeks prior to the goal date, and something else needs to happen 1 week and 5 days before the goal date. I would like to set up 4 cells in Excel: one for the goal date, and three for the various things that need to happen leading up to that goal date. I would like to be able to enter the goal date into the main cell and have the other three cells auto-populate with the correct date based on what I enter in the goal date. For example, if I enter a goal date of 11/01/2016, I would like the other three cells to automatically populate themselves with: 09/20/2016 (6 weeks prior), 10/04/2016 (4 weeks prior), and 10/20/2016 (1 week and 5 days prior). Is this possible? Can Excel return dates in that way?

Answer:How can I auto-populate dates in Excel based on other dates?

Sure, it's easy. Excel internally stores Dates and Times as numbers. Each day is a whole number and time is the decimal portion of that day. See here for a pretty good explanation of how Excel deals with Dates and Times as well as links to all the various Date and Time functions that Excel offers:http://www.cpearson.com/excel/datet...As for your question, simply subtract the number of Days required from the cell with the Goal Date.With 11/01/2016 in A1, use this to return 9/20/2016:=A1-42(42 is 6*7, or 6 weeks.)I'll leave the other two formulas to you. ;-)Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 66.01%

Hi,I picked up a macro from another forum that i want to use for renaming the tabs on my "weekly planner" spread sheet. Basically it's a planner that we re-use every year so each year i just want a simple way of renaming each tab to update it with the "week commencing date" for the 52 weeks of the year.The macro i'm using is this:Sub RenameSheets()Dim nxtName As Integer For nxtName = 1 To Sheets.Count - 1 Sheets(nxtName + 1).Name = Sheets(1).Cells(nxtName, 1) NextEnd SubIt works well if you just want to rename the sheets (sheet1, sheet 2 etc) but if you try to insert dates it doesn't allow it due to the dates automatically containing / which isn't allowed on a tab.I am a major amatuer at Excel so any help on this would be massively appreciated.I've tried simple things like doing the dates in other cells and then using them as the base and making A1 column (=B1) etc as this means that the cell doesn't contain a / but this doesn't work as i suppose the source cell still contains a /.Sorry if this sounds majorly stupid but it would save me a lot of time in the long run if i can sort a solution to this.Many thanks, Adam.

Answer:Cannot rename tabs on my spreadsheet using dates

Hi,I have managed to overcome this by adding .Text after the 3rd line from the bottom.Hope this helps others with the same problem.Adam,

2 more replies
Relevance 66.01%

I want to format an invoice so that the dates of the month change to the current month just by entering the date one time in the first cell. The invoice would include all the days of the month. How do I do this? Thanks for your help.

Answer:Formatting calendar dates on spreadsheet

Hi,You can try this:In cell A1 enter =DATE(YEAR(TODAY()),MONTH(TODAY()),1)This will return the first day of the current month & yearor just enter the date for the first of the required month.The date must be in a format Excel recognizes as a date.In cell A2 enter =A1+1This will give the second of the monthDrag the formula in cell A2 down to A28This will give the first 28 days.In cell A29 enter this formula: =IF(DAY($A$1+28)<>29,"",A28+1)This tests whether 28 days after the 1st of the month is 29 (or 1 - i.e. 1st of next month)If it isn't 29, it returns "", else it returns the dateThe same approach is used for A30 and A31A30 =IF(DAY($A$1+29)<>30,"",A29+1)A31 =IF(DAY($A$1+30)<>31,"",A30+1) Format all cells with the required date format.Hope this is the sort of thing you were looking for.Regards

4 more replies
Relevance 63.14%

I am currently undertaking a project where i want to reference a number to a description.

For example i have coded parts which are just numbers which need to tie into a description.

What i want to happen is if i type the number in A1 the description will automatically go into A2.

I have hundreds of different parts with different descriptions.

Is it possible to do this?

Thanks
 

Answer:Excel Populating cells

Do you already have a reference table that matches the parts and descriptions? If you do (lets say on a sheet named Reference in cells A1 through B100) you could use an IF statement with a VLOOKUP to show the description if something is in A1. Try the following formula in the cells you want to show the description in:

=IF(ISBLANK(A1),"",VLOOKUP(A1,Reference!$A$1:$B$100,2,0))

I'm just typing this in the reply here, so it may not be 100%. This also assumes that your reference table has the part numbers in column A and the descriptions in Column B. Let me know if this helps!
 

3 more replies
Relevance 62.73%

Date list formatted X/XX/XXXX, but showing as 1/0/1900

Answer:Excel date not populating correctly

Have no idea what your problem is, you will need to expand on your explaination a bit.MIKEhttp://www.skeptic.com/

10 more replies
Relevance 61.91%

I am trying to find formulas that will help me self-populate the form that I have. There is a database that I am trying to use the V-lookup to search that data base and then give me an output on the form. Is there any way I can do that? For example, if I put in a person's name and then the rest of the sheet fills out automatically?

More replies
Relevance 61.91%

Hi everyone,

I read a post on Tech Support Guy that was similar to my question however seeing as the thread was quite old, I thought I would ask again to see if there were any new ways of doing this.

I have a spreadsheet with Name, Surname, ID number, Verification Code, Employee Number, Activation Requested. I then have a mailbox in Outlook where people can send a mail confirming their ID numbers.

I would like to set up a macro that will automatically populate the Activation Requested column once a mail comes in that matches the Name, Surname, ID number fields (so the cell will either be blank or have "No" and once a mail comes in matching the above fields, it will change to "Yes").

I am quite comfortable in Excel but have only recently started to dabble with modules in VBA so by no means do I understand extensive coding or the jargon that goes along with it.

So, my questions are:

1. Is there code available that I can use to set up the above (in a step-by-step manner as I would like to understand what I am doing and not just blindly copy/paste)?

2. Would the macro run automatically once my workbook has been opened in order to update mails that may have come in when Excel wasn't running?

Thank you in advance for any advice
 

More replies
Relevance 61.91%

I have an excel page that lists a value in column A and in column B is the total number of units that have that value. This is a typical histogram. Unfortunately, the equipment we use spits out the data already having summed up the instances of each unit. I want to re-populate the spreadsheet with all the values in the list. Don't ask why, someone is asking me if it can be done. Here is an example: (extremely shortened)
Col.A - B
0.11 - 2
0.13 - 3
0.15 - 7
0.18 - 2
0.20 - 1

I want the spreadsheet to then read:
0.11, 0.11, 0.13, 0.13, 0.13, 0.15........0.18, 0.18, 0.20 (but all in one column)

Can it be done.

Thanks
Ronyace
 

Answer:Solved: Excel - Populating data from histogram

12 more replies
Relevance 60.68%

I have an Excel 2007 worksheet (main worksheet) that has many columns (15) and rows (800). One column has five different sets of initials. I need to some how figure out a way where I can take that one "Initials" column and then extract three others columns data into five new worksheets (one for each set of initials). So that I can seperate each initials data into its own worksheet (for only that specific set of initals).

I also need this to auto populate somehow from the main worksheet. I have spent all day trying to figure out a formula for this and I can't seem to make it work. I have figured out how to filter the data but can't seem to get it to auto populate.
 

Answer:Solved: Excel 2007 Question about auto populating from one worksheet to others.

14 more replies
Relevance 59.45%

I am trying to open a spreadsheet that was created in Excel 97 using Excel 2000. The links and macros that are on the sheet seem to prevent it from opening. There are a load of error messages but I just cannot get the thing open. I have searched so many places, found the same problem but no answer.

Can anyone help?

Leanne
 

Answer:Excel 2000 problem when opening Excel 97 spreadsheet with links and macros

Welcome to TSG.
Can this file be opened fine in Excel 97? Any chance that it is corrupted?
What are some of the error messages you are getting?

 

3 more replies
Relevance 59.45%

Hi Folks,
I have a valued Excel 2003 spreadsheet that, I can currently only open in Excel 2007. However, an error message has been displayed that Excel was unable to read some of the document and it did a recovery. The file has now lost a few key sections. I have attached the error log below.

Any suggestions please?

Thanks,
Dave

<?xml version="1.0" encoding="UTF-8" standalone="true"?>

-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">

<logFileName>error033640_01.xml</logFileName>

<summary>Errors were detected in file 'C:\Users\User\Documents\tool sourcing.xls'</summary>
-<additionalInfo>

<info>Excel recovered your formulas and cell values, but some data may have been lost.</info>

</additionalInfo>

</recoveryLog>
 

More replies
Relevance 58.63%

I'm trying to Merge an Excel spreadsheet to Outlook and provide alerts for critical dates in said spreadsheet in the Outlook calender !
 

Answer:Excel - Merge Excel spreadsheet to Outlook with Alerts

Welcome to TSG faithtronic.

I've never done it but your thread has been setting here a while. A method to do this here http://www.ehow.com/how_5685419_create-calendar-excel-data.html

I would start with a couple of dates so not to screw up the whole calender! There are some sharper excel folk on this site that might provide a better answer. But this is a starting point?
 

1 more replies
Relevance 58.63%

Hi
I am trying to export data from word or excel form into a spreadsheet. I have tried the macro at http://forums.techguy.org/business-applications/257309-exporting-word-form-data-excel.html and it worked for all text fields but not the drop down list options that I have in my form. Can anyone please help/

I have never done this before, hence the struggle. Any help would be much appreciated.

I attach the word form and the excel form which also includes the excel spreadsheet that will collate the data for analysis.

I would prefer the form in word and have it set up as that indicated in the forum thread above but picking up the data from the drop down lists as well.

Thanks
LAD786
 

Answer:Export data from word or excel into Excel spreadsheet

Hi there, welcome to the forum.
It seems this post you added on August 12th hasn't given you much answers.
You mention the two files, OK, But what I don't understand
I am trying to export data from word or excel form into a spreadsheet. ...
Click to expand...

You probably forgot to attach the macro's with it, that is if you did anything with the link you mentioned.
If you could attach the files with the macros, I could take a look and see what I can do for you.

Another thinng From Word or Excel.

Which one is it going to be?
 

1 more replies
Relevance 57.81%

I have some VBA code that copies all the filenames in a Windows folder and pastes them into an Excel spreadsheet. Here it is: Dim myRow As Integer Dim myFile As String Dim mySheet As Worksheet For Each mySheet In Worksheets mySheet.Select mySheet.Unprotect Next mySheet Sheets("Files").Select Range("a1").Select myRow = 1 myFile = dir("*.xls")Do Until myFile = "" Cells(myRow, 1) = myFile myRow = myRow + 1 myFile = dirLoopThis works really well except I have to open the file that runs the code from within Excel, otherwise I get the file names from the default file location. I'd like to open the file from a desktop shortcut and have the code go to the directory of my choice. I've tried ChDir and opening a dummy file at the beginning of the macro, but neither of these works.Hope you can help. Thanks, MaryPS The above code might be useful to Onizuka

Answer:Excel VBA copy filenames into Excel Spreadsheet

ChDir should work. You need to specify the full path to the folder in " quotes.

8 more replies
Relevance 57.4%

For some reason as I have added dates to cells, they are not getting converted to the Date type I have selected: 15/03/2009I type in my entries in this format:March 15, 2009 (usually it converts immediately but not this time)I've tried selecting the columns of cells with dates, Select>Format>Cells>Date and Type but nothing changed (although one date was converted to 03-15-2104Any suggestions?

Answer:converting excel dates in Excel 2003

Dat's cuz they're probably not being recognized as dates by Excel. My guess from afar is that the cells are formatted as Text and aren't accepting any other formats. Excel is finicky like that sometimes.Try this with one of your stubborn "dates"...let's assume it's in A1=DATEVALUE(A1)Now format that cell anyway you want.Then do a Copy...PasteSpecial...Values to eliminate the formula.

7 more replies
Relevance 55.76%

Hi,

After a power outage a particularly important file gets the error "Excel cannot open the file.xlsx beacause the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file. The file format has not changed. Is there a safe free program that can uncorrupt a file? I have tried Open and repair, changing the format, and using open office. Also tried using recova but the file was not lost.
 

Answer:Solved: Excel 2007 spreadsheet gets error "Excel cannot open the file .xlsx.." How ca

https://support.microsoft.com/en-us/kb/820741

and 5 ways are shown here http://www.wikihow.com/Recover-a-Corrupt-Excel-File
 

2 more replies
Relevance 54.53%

I am sure this is obvious to folks out there!
I have a short list on numbers in a list of cells (e.g. - c3: c14) and I want the spreadsheet to select the lowest value entry and display it in another cell.
Do I use an 'IF' formula? How

More replies
Relevance 54.53%

I have accidentally forget my password to open a protected xls. Anyone got any idea?
 

Answer:MS Excel spreadsheet

Sorry to say but you won't receive any assistance with password cracking in this forum. There is no way to verify that you are the true owner of the workbook and/or that you have the right to view to protected material. For all we know, you may be trying to open a workbook that belongs to someone else which may contain sensitive private information about others.

Regards,
Rollin
 

1 more replies
Relevance 54.53%

Every month for several years I have accessed my own spreadsheet offline from desktop icon.
To utter consternation and increasing frustration, today OPEN brought up the file BUT can do nothing with it.
Same results with backups on different drives.

Consequently told browse to find program from which can OPEN. Obvious choice MSN Excel. Result: "Cannot find any version ...to open file for edit".

Further on I installed msn xlviewer. In Open process came box, "Office Source Engine (Process ID: 2120) running. Need to Close". How/where to do so no idea. I am on Vista Ultimate with !E7; note not included in list for this item.

FYI, I only have Office 2002 (with Excel 2002), but cannot even remember last time I used it for anything. Also note many MSN references to Office 2003, but hardly ever 2002.
Point is, HOW CAN I GET BACK WHERE I WAS & NOT BE REFERRED TO NEED FOR A PROGRAM (EXCEL)?
Only secondarily (and reluctantly) interested in making Excel function to restore ability to use my spreadsheet.

I will be most grateful for help in this unexpected problem.
 

Answer:Spreadsheet with/without MSN EXCEL

Well, I can give you advice on installing an alternative (freeware) program that you can work with your spreadsheet with.

Check out http://www.openoffice.org . It's an open source alternative to MS Office, and can open MS Office documents, spreadsheets, etc.
 

11 more replies
Relevance 54.53%
Question: Excel Spreadsheet

I started logging my miles for work and stuff. I want to make it count two different sets of miles. The first bot I have is total miles, which is expressed as =SUM(I6:I35) I want a second one, I just don't know how to make it work.
 

Answer:Excel Spreadsheet

9 more replies
Relevance 54.53%

Sheet 1 is an order form, sheet 2 is product #s and descriptions, I want to choose a product on sheet 2 and have it populate the first blank row on sheet 1

Answer:I have an Excel spreadsheet,

Well, now we know what you want.If you need any help with that, feel free to ask.

2 more replies
Relevance 54.53%
Question: Excel spreadsheet

I am trying to figure out if you can merge information into Excel but have it show up as a cell comment?

I have a large amount of information that needs to fit onto one page, and have cells that have enough text to wrap around. So, instead I was going to have it be a cell comment, but wondered if this would work with the information being merged into Excel?

We currently merge information for this particular document from Act2000 into Excel. Please let me know if this is possible, and if not, if I have any other options?

Thanks in advance!
 

Answer:Excel spreadsheet

Hi.

I've left this sit without responding long enough.

Either I don't understand what you're trying to do (though I think I do), or you are asking for the (next to) impossible.

Why are you not using Word to do this? Comments are rather cumbersome in Excel, as well as a lot of text.
 

1 more replies
Relevance 54.53%

Hey,

I have a weekly Poker group and I made a spreadsheet for it to keep track of all the satistics. Iv managed to make a worksheet for each season and then I thought wouldnt it be cool to have an 'overall' worksheet to show the overall standings - sorta like a league table ladder.

Here are the things I want:

1# In each of the seasons, in the ranking ladder, I need a tiebreaker like rebuys to break ties. Because when there is a tie, it glitches and it shows my name twice.

2#In each players profile in each season, under the average placing column, in the average, I need a formula that doesnt count the 0s, because if someone doesnt show up, there will be a zero, and the current formula counts that 0 as a placing. It saves me manually having to exclude the 0s from everyone's average at the end of each season.

3#If you open the overall tab, you will see the overall standings ladder. That is the beast I am hoping to get up and running with your help. I want it cover all the stats across every season automatically. So when a new seasonis made, it will track it auto, when a new player is added, it will track it auto. The primary column will be score obviously, then for tie breakers use re-buys again. In this table Score refers to Profit in the player profiles,1st, 2nd 3rd refers to how many time each player has finished 1st 2nd or 3rd all together, Average placing refers to the average placing column in the players profile, Prize Money refers to the gross column in the ... Read more

Answer:Excel Spreadsheet Help

I also tried to attach the spreadsheet but it doesnt seem to work...

Cheers,
Joronamo.

1 more replies
Relevance 54.53%
Question: Excel Spreadsheet

I have a spreadsheet of students names, their subject results (F,P,C,D) for each stage for example STAGE 1 STAGE 2 STAGE 3
JOHN BLOGGS P D C C P C P P P P P P C P P C D
Each stage has a set number of subjects be it 5 or 6. What I would like to be able to do is
automate the spreadsheet so that as each stage is completed a master list is update with the stage the pupil is now enrolled and the pupil automatically transferred to the next stage.

Can anyone help me please.

Many thanks
NiftyK
 

Answer:Excel Spreadsheet

12 more replies
Relevance 54.53%
Question: Excel Spreadsheet

I am setting up a spreadsheet for my classes, and I am wanting to see if there is a way to sort a column by male, female pattern. (I was hoping to be able to sort the list that way in order to prepare a seating chart....boy, girl, boy, girl etc...)

...I know that it will sort it by lumping the males together and then the females or vice versa... But I am hoping there is a way to be able to alternate the boys and girls.

But before giving up I thought I would ask you all here, since you have been a big help in the past.

Thanks in advance!!!

=O)
KimlaiKy
 

Answer:Excel Spreadsheet

You could have another Column where you have numbers pairing them.
ie. Sort them Male/Female and then for the Males enter 1 for the first and 2 for the second and then drag that sequence down to the last male. The repeat that for the Females.
Now sort by value first and then m/f and you should have boy, girl.
I think.
Actually you get Girl, Boy etc
Make it G & B instead of F & M to get it as Boy Girl.

The column with the values can of course be hidden.
 

1 more replies
Relevance 54.53%

I have a pricelist i need to make changes to. It has about 300 prices on. I dont want to do it manualy. How do i add 7% to all my prices?

Answer:190.23 plus 7% on excel spreadsheet

Try this:
A B
1) Old Price New Price
2) $10.00 $10.70
3) $200.00 $214.00
4) $3,000.00 $3,210.00

In cell B2 enter the formula: =(A2*0.07)+A2Drag down as many cells as needed.Now select your New Price cells and do a Copy Now select your Old Price cells and do a Paste / Special / ValuesDelete column B and your done.MIKEhttp://www.skeptic.com/

4 more replies
Relevance 54.53%

I was sent an Excel spreadsheet attached to an email. I need to get it filled out, and sent back. I'm able to view the spreadsheet, but when I click on a cell, I'm not able to type anything in the space.
I've never used Excel before, and am clueless, as you can surely tell.
So, can someone fill me in on how to fill this in?

Thanks!!
 

Answer:How to use Excel Spreadsheet

Hi there,

It sounds like your worksheet may be protected. With this sheet activated click on Tools | Protection; What does it say, Protect Worksheet or Unprotect Worksheet?

Also, if possible, how about zipping and attaching an example workbook?
 

3 more replies
Relevance 54.53%

Hi there,

I am going to try to word this as simple as possible, but i am having trouble coming up with a formula to work between TWO worksheets, and i am not even sure it is possible.

Basically these two worksheets contain similar data, however, only one of them is updated, and i would like the other worksheet to populate itself based on what is entered on the first worksheet.

I have figured out how to do this using IF statements, however, as new data is entered into the first sheet, i would have to continuously build IF statement formulas.

My question is, is there a way to make a formula based on the following that would work absolutely (When you drag it down changing per row it would display the data i need):

WHEN data in column one, matches data in column one on sheet 2
AND
Data in column three match data in column 3 on sheet 2
THEN
display data in specific cell on sheet 1 to specific cell on sheet 2

I know that it seems simple to build an IF formula, and nest it. But is there a way to build a formula that would search the entire sheet matching the data and displaying without having to build a specific fomula for each row?
 

Answer:HELP! with an Excel Spreadsheet

Hi Jake

Are you ever a candidate for Visual Basic for Applications (VBA), which comes for free with Excel. You can buy a book on it -- I got good value from the Weekend Crash Course book on the subject. However, you can also get started easily by recording macros and then editing them. There are tons of resources on the internet (google for VBA and Excel and whatever term you want help on) and the Help in VBA is also very helpful. One of my favorite websites on Excel is mrexcel.com. Bill Jelen (aka Mr. Excel) has written tons of articles and books on Excel and is one of Microsoft's preferred gurus, although he doesn't work for Microsoft.

To start VBA from within Excel without recording a macro, just hit Alt-F11 and start using it.

Have fun!

Jeremy
 

3 more replies
Relevance 54.53%
Question: excel spreadsheet

Excel spreadsheet not auto updating. What can I do other than hitting f9?
 

Answer:excel spreadsheet

try open excel,click on the tools menu,click on the calculations tab and set the radio button to automatic
 

2 more replies
Relevance 54.53%

Looking for some help?. I am using the following macro to insert a blank row (to separate varying Group rows) and then, Subtotal Column B per each Group:
Sub GroupInsertRowAndTotal()
Dim lngRow As Long, lngStart As Long
lngStart = 2: lngRow = lngStart
Do: lngRow = lngRow + 1
If Range("A" & lngRow) <> Range("A" & lngRow - 1) Then
Rows(lngRow).Insert
Range("B" & lngRow) = "=SUM(B" & lngStart & ":B" & lngRow - 1 & ")"
'Remark the below line if you want to convert the formulas to actual values.
'Range("B" & lngRow).Value = Range("B" & lngRow)
lngRow = lngRow + 1: lngStart = lngRow
End If
Loop Until Range("B" & lngRow) = ""
End Sub

If possible and practical, I would like to edit the above with additional VBA code using the respective ?Subtotal? generated above to populate Column M (starting in row 2) with the following formula:

=(1-(b2/$b$13))/(b2/$b$13); =(1-(b3/$b$13))/(b3/$b$13); =(1-(b4/$b$13))/(b4/$b$13); (etc.)

[Note 1: Same formula calculation for cells (b2:b12) and for illustration purposes only, $b$13 = the cell location of the first Subtotal?. Then, repeat based on cell location of next Subtotal?. RE: All columns are ?blank? in each Subtotal row except for Column B]

I am trying to automate current daily spreadsheet that usually has in excess of 1000 rows which doing manually, is obviously ver... Read more

Answer:Need VBA help for Excel Spreadsheet

Your text says the groups vary. What distinguishes a group?

Stoneboy
 

3 more replies
Relevance 54.53%

Hi, I have a column of about 2000 numbers, I want to put four spaces at the fron of the numbers. Is there an easy way to do this on a Excel spreadsheet?Thanks

Answer:Excel Spreadsheet Help Please

That's a bit unclear to me. Do you mean that you want to:a) pad them with four spaces in front? They won't be treated as numbers anymore if you do that.b) make them *appear* to have 4 spaces in front but still be treated as numbers.c) be padded with leading zeroes.A few examples would help.

5 more replies
Relevance 54.53%
Question: Excel Spreadsheet

Can somebody help please. Have a spreadsheet something like this

DATE DATE DATE
CM789 Y L Y
CF897 Y Y Y
CM856 L L Y
CM742 Y Y Y
CF7854 L Y L

TOTAL 3 3 4

What I am trying to achieve is to get a total by either CM or CF for each date
ie

CM 2 1 3
CF 1 2 2

Can somebody help please
 

Answer:Excel Spreadsheet

7 more replies
Relevance 54.53%

I have a very large Excel table that I need to convert into an XML document to display on the web in various ways. I found a macro online that creates a very nice and clean XML document -- www.meadinkent.co.uk/myxml/XL_to_XML.txt
However the table has lots of external links and none of the link attributes come through to the XML.
Likely there are a variety of ways I could do this but my experience with Excel is very limited, so any advice would be greatly appreciated!

Thanks in advance!
 

Answer:Excel Spreadsheet to XML

16 more replies
Relevance 54.53%

Hi,
I have a question about excel 97
I'm setting up an excel spreadsheet for a Reading Teacher.
She needs 4-columns called Names,Hearing/Sounds, Stanine, and
Writing/Vocabulary.
The question I have is the columns called (Writing/Vocabulary) and
(Hearing/ Sounds)will have scores and the teacher would like to click on Desceding or Acsending and sort the scores to see which student needs more help by checking lower scores.
How do I do that so that the scores will move with the names when she sorts them?
Any help would be greatly needed.
thanks walk12
 

Answer:Excel Spreadsheet help

Hi walk12,

If the data is selected from those specific columns, you can go to Data -> Sort, you should be promted to Expand the selection (I believe this is in 97). If not, select all 4 columns, Data -> Sort, Sort by Hearing/Sounds (or whatever). This should do it for you. There are also formula solutions to do this instead of sorting. Just depends on how much you want to manipulate your data. HTH
 

3 more replies
Relevance 54.53%
Question: EXCEL spreadsheet

Attached is a file where I need to allocate the dollar amount. I need to allocate the dollar amount, proportionately, from cells C84 & D84 (Management Volume Challenge) across the values in each of the columns C3, D3 through C72, D72(SINGLES and KIND SIZE). Cell F84 is the area where the dollar value for a reduction or increase. The row items in BOLD are summary lines and do not require an allocation of dollars.

Thanks for your cooperation in advance.
 

Answer:EXCEL spreadsheet

Nothing is bold. It's a TXT file.
Try uploading the file again.
This time, do not SAVE it as a text file.
Instead, copy your file, change the file extension from xls to txt using Windows Explorer and not Excel.
Then load it.
 

1 more replies
Relevance 54.53%

Attached is a spreadsheet I have 2 questions on. I have read many posts out here but I haven't gotten any to work.

1. How do I remove the page # that appears on each page?
2. Is it possible to sort the contents of a single cell? I want to sort the following data that is in a single cell: Magellan, PrimeSource-GSH, UBH, Quest, Value Options, Intergroup, Cigna, CBHNP, CCBHO, Gateway Assured, Aetna, Highmark, Premier Blue, Freedom Blue, Unison, MH Net, LifeSynch, LifeSynch MC, Medicare

Any help would be much appreciated.
 

Answer:Need help with Excel spreadsheet

8 more replies
Relevance 54.53%
Question: Excel Spreadsheet

Hi,
I have to import values into a website. This information is for electrical transmission flow. Based on the number of paths I have and the duration I select. I would like the spread sheet to create the lines for me and have them populate the correct field. I am attaching an example. The Por and Pod are the To and From. Currently in my spreadsheet I have 7 paths setup. If that changes though I would like it to automatically add the additional path in the correct place. I also show 3 hours for the duration, but this could be days or months and it might be broken up in hours days months. Example for Months it would be 7/18/2009 0:00 to 8/18/2009 0:00. I generally post 1 year of monthly values so on the Input page I was thinking about asking the user for the duration (Start to Stop times), Increment (hours, days, Months), and path names (To and From) and have excel create the attached worksheet with those colums filled in. I am not sure I have explaned the situation very clearly so if you have any questions please ask.
Thanks,
Joe
 

More replies
Relevance 54.53%
Question: Excel and dates

Hi All,I am updating a old spreadsheet and wanted to add some work days down the side of it. The problem I have is that I only want Mon-Friday dates to be listed. For example....12/3/201212/4/201212/5/201212/6/201212/7/201212/10/2012etc.....For some reason I can't get it to work right. In this example you can see that the first work day for Dec is the 3rd and that the 8th and 9th are passed over because they are a weekend. I know I have done this before I just can't remember how I did it. I was able to click on a cell and drag down to highlite a months worth of cells and put in a formaula in the first cell and then all the dates would just show up below it. Anyone have any ideas?ThanksSpoiler

Answer:Excel and dates

Quote from: Spoiler on December 14, 2012, 10:10:41 AMI know I have done this before I just can't remember how I did it. I was able to click on a cell and drag down to highlite a months worth of cells and put in a formaula in the first cell and then all the dates would just show up below it. Are dates for all rows part of the existing data? If so, then one approach might be to add a column to show the day of the week and then use a Filter to show all days except Saturday and Sunday.

6 more replies
Relevance 54.53%
Question: Excel dates

I have a friend from california he has got office over here in europ but because of work he needs too change his dates in excel too american format how can i do this?

Answer:Excel dates

Hopefully this guide will help.

2 more replies
Relevance 54.53%
Question: excel dates

Filename: SysInfo.exe
Full Path: c:\Users\JIMBO\AppData\Local\Microsoft\Windows\INetCache\IE\RBAGCWGH\SysInfo.exe

____________________________

____________________________
Developers
Not Available

Version
1.0.0.2

Identified
6/27/2016 at 5:17:31 PM

Last Used
Not Available

Startup Item
No
____________________________
Many Users
Thousands of users in the Norton Community have used this file.

Mature
This file was released 4 years 8 months ago.

Good
Norton has given this file a good rating.
____________________________
Source File:
sysinfo.exe

____________________________
File Thumbprint - SHA:
8243b4ea661b060fe8cf4babc11ab5f51eadd28a0c9d66303183e8eceace8234
File Thumbprint - MD5:
Not available
 

Answer:excel dates

What is your problem and/or question?
 

2 more replies
Relevance 54.53%
Question: Excel and dates

I have two columns of dates, A and B. Column B is just As date plus 30 day. What i want it to do is, whenever i update column A's date, i dont want column B's date to change. how do i do that??

Answer:Excel and dates

i dont want column B's date to change.Remove the formula that updates B?MIKEhttp://www.skeptic.com/

24 more replies
Relevance 54.53%

I have a column of calendar dates (A1:A100) that do not include Saturdays or Sundays. I have certain production times for various products that I must base off of these dates and am having trouble counting an amount of days that doesn't include any Saturdays or Sundays in my count. Example below.

10-02-2006 I need to add 18 production days to this date. Workdays only being Mondays-Fridays, I need the answer of the formula to equal 10-25-2006.

Can anyone assist?

Ron
 

Answer:Need Excel HELP with Dates

7 more replies
Relevance 54.53%

I've got a strange one, I think !!!Current date is 16 Jan 2005, and in my module I say Dim CurrDate As LongCurrDate = Format(Now(), "00000")This sets CurrDate as 38369Later in the module I want to compare this date with one from a cell ...Dim MyNewDate As LongMyNewDate = Range("N" & MyStoreRow) ... value is 17 Jan 2005The value being returned in MyNewDate is 38369, not, as I would expect, 38370 ...In another worksheet, the new date in Nxx is 18 Jan 2005, and this returns a value of 38370, not 38371 ... Any ideas as to what's happening here ?!?! Is my Current Date wrong ? Is this a known 'problem' ?!?!?

Answer:Dates in Excel VBA (again !) ...

I'm not sure what is goung on but you would be better off working with Dates rather than LongsSub test()Dim mydate As Datemydate = Now()MsgBox mydateEnd Sub

6 more replies
Relevance 54.53%
Question: excel dates tip

Can anyone let me know the formula for coverting a date held in excel as yyyymmdd into dd/mm/yyyy.Many thanks

Answer:excel dates tip

Assuming that is a text value try=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))where A1 holds the text date.

2 more replies
Relevance 54.53%

I'm trying to set up a spreadsheet so that each time I open it, the time between two dates is calculated. The two dates would be today (the day I open the spreadsheet) and a date about 10 years away. Any help would be appreciated.ThanxDD

Answer:Excel - between two dates

For examplein A1 30/03/2017in B1 =TODAY()in C1 =DATEDIF(B1,A1,"d")

10 more replies
Relevance 54.53%
Question: Excel Dates

Eldest daughter driving me mad.At business she is working on a database in Excel.She tries to shorten the DOB entry as for example23/11/29 for someone born in 1929 but it comes out as 23/11/2029 yet when she enters 23/11/31 it comes out as she wants it as 23/11/1931. Is there something we need to format in Cells/Date?Brambles

Answer:Excel Dates

and have the same problem! Using excell 2000 and my cells are formatted correctly. Very strange, however there are lots of very helpful people on this site and here's hoping.Taffy

3 more replies
Relevance 54.53%
Relevance 54.53%
Question: Excel Dates

I have been using this formula to let clients know when their bills are due:
=DATE(YEAR(A1),MONTH(A1),DAY(A1)+90)
this ends up looking something like this: 1/1/04
however, I have had a request from them to have it look more like this: 1-Jan-2005.
Any help would be greatly appreciated. Thank you.
 

Answer:Excel Dates

12 more replies
Relevance 54.53%
Question: Dates and Excel

I have a sheet in excel which I input my daily results. Some dates or blocks of dates are missing as I am unable to gather the data. (vacation, travel, etc)Column A is the date (mm/dd/yyyy)Column B is the result (0.00)I have another sheet with the following:Column A has a list of all dates (month and day only) (366 rows) Columns B through M have the year in row 1I need to lookup the month and the day and attach the year based on the column year (this is easy)=VLOOKUP(DATEVALUE(MONTH($A2)&"/"&DAY($A2)&"/"&YEAR(C$1)),Generation!$B:$C,2)BUT I need the exact date data returned. VLOOKUP returns the closest lower value.If no exact date then return 0 or "".Is there an easy way to do this in Excel without writing code?Thanks for helping in advance!

Answer:Dates and Excel

If you want an exact match, you need to use FALSE or 0 in your VLOOKUP as the optional range_lookup argument:=VLOOKUP(DATEVALUE(MONTH($A2)&"/"&DAY($A2)&"/"&YEAR(C$1)),Generation!$B:$C,2,0)Review the VLOOKUP Help file to see the options for this argument.If an exact match isn't found, this will return #N/A, so wrap the formula in an IF(ISNA()) function to get a "" of 0 if the VLOOKUP evaluates to #N/A. This will return "":=IF(ISNA(VLOOKUP(DATEVALUE(MONTH($A2)&"/"&DAY($A2)&"/"&YEAR(C$1)),Generation!$B:$C,2,0)),"",VLOOKUP(DATEVALUE(MONTH($A2)&"/"&DAY($A2)&"/"&YEAR(C$1)),Generation!$B:$C,2,0))

4 more replies
Relevance 54.53%

Hello,
I have a master workbook with 20 worksheets. 5 worksheets in the worksbook are distributed to field reps, but the remaining 15 worksheets are not. What is the best practice for receiving the 5-worksheet workbook from the field rep and importing the data into the 20-worksheet master workbook? If I merely use Copy Sheet I am able to copy the worksheets into the master workbook but then I have to remove the pathname references in each of the copied worksheets in order to map the data in the master workbook - which is quite cumbersome. Suggestions?
 

Answer:Populating data from one Excel workbook to a master workbook

Hi jpirhalla, welcome to the forum.

Have you tried moving the sheets over. Dragging the sheet from the field reps back into the now-15-sheet book?
 

2 more replies
Relevance 54.12%

Hi, Each time I calculate a formula on my excel spreadsheet the answer comes up as zero. I have never had this problem before so I not sure what has happened. The correct formula is in the cell but the answer shows as "0" instead of what it should be. It won't copy correctly either. It is driving me mad. Hope you can help. thanks
 

Answer:Excel spreadsheet problem

12 more replies
Relevance 54.12%

Is it possible to capitalize text in a excel spreadsheet? (Office 2007)Thanks

Answer:Is it possible to capitalize a excel spreadsheet?

If you mean convert an existing sheet then you'll need VBA.First click the Office button (top left), click Excel Options, tick Show Developer tab in the ribbon and click OK. Then press ALT + F11 to open the Visual Basic Editor, select Module from the Insert menu and paste into the white space on the rightSub tocaps()Dim c As RangeFor Each c In ActiveSheet.UsedRangec.Value = UCase(c.Value)Next cEnd SubPress ALT + Q to close the code window, on the Developer tab click Macros, click on tocaps then click the Run button.

3 more replies
Relevance 54.12%

Hi, have recorded a macro for clearing 10 spreadsheet database filters. Have tried to tidy the code within Visual basics but having trouble. How do i make the Macro operate quicker. Dave 52
 

More replies
Relevance 54.12%

I have an XL spread sheet from which I would like to set up a database. Is it possible to insert the info easily into an Access table without having to re-type it all? Abortive attempts so far! - there must be a way (isn't there?)

Answer:Excel spreadsheet into Access - possible?

found this that might work click here TIP #10: BRING EXCEL DATA INTO ACCESS (Versions 7.0 & 97)"""To bring data from a Microsoft Excel spreadsheet into Access, first open both programs and minimize Access. Highlight the data in Excel that you want to import into Access. Point to the edge of the highlighted data, then ctrl/drag to the Taskbar and hold above the Access icon (DO NOT release the mouse button) until Access opens up. Access will automatically import the data. """

4 more replies
Relevance 54.12%

I have uploaded a sample of the spreadsheet I am trying to modify and I kinda have it working the way I want and I need these costs broken out the way I have them. I will try to explain what I want the best I can so bear with me.

I want "Total" to capture if it is an expense or income. (right now it is not)

I want "Balance" to reflect if it is an expense or income. (right now it is not)

I want any unpopulated cells to show nothing or ""

This is probably simple for an excel wizard but I only know excel good enough to get into trouble!

Any help is appreciated, thanks, Joe
 

Answer:Solved: Can someone help me with this Excel spreadsheet?

16 more replies
Relevance 54.12%

I have created a spreadsheet to track monthly financials
My problem is I want a YTD column for revenues and expenses to automatically calculate when I enter the new month totals...I have set up a column (d9) for monthly revenue and a column (e9) for the YTD expense...I know it would be easier to create a column for each month but I already have a report that gives me that detail if I need it...this report is really for each employee to see each month how their budget line items are doing...I was told this is doable but I would need to write a macro and that is where I really need the help...Have no idea where to begin

Thanks,
p
 

Answer:YTD Totals on Excel Spreadsheet

13 more replies
Relevance 54.12%

I have a spreadsheet that I need to sort by column (P) which has formulas in it that added data from each row across. I checked all my formulas and they are correct. I had to delete 3 separate rows so I highlighted each one and went to "insert/delete rows, columns" etc. and deleted them there. I then went to DATA and sorted by column (P) from highest value to lowest value and that computed correctly. The data in each row however shifted so each row is incorrect. I don't know how to fix this. Can someone PLEASE help!! This is the only spreadsheet I work with and have never had a problem. I know I must've done something wrong but I've been working on this for 2 days. Did I mention I hate excel due to my ignorance of how it works??? HELP!! Thanks in advance.
 

Answer:Solved: Excel Spreadsheet HELP!!

13 more replies
Relevance 54.12%

I'm trying to create a spreadsheet to keep track of attendance points at work. First of all let me explain my companies attendance policy. We have a no fault attendance points system. If you are late for work or leave early under 30 min you get 1 point. If between 30 min-2 hrs, 2 points and a call off or late/leave over 2 hrs is 3 points. After every 30 days of no occurances 2 points are subtracted from your total. And if you go 6 months with no occurances you get what is called a "good attendance credit" which means if you have an occurance, you don't get any points for it.

I've created a generic spreadsheet (which I have uploaded here) of how i want to keep track of it, I plan to use a worksheet for each employee on my shift. Though if if I do get this together, I do know a few other people who would like to use it for their employees as well.

My biggest problem is in the F column. Is there a way to set it so that If row A-E is null that there is no value input for F? I don't like how the total goes all the way down the page, and it will confuse some of the less computer savvy people when I'm trying to counsel them on attendance. Also is there a way to autopopulat the point totals? So if "Call Off" is selected in column C that "3" is populated in column D?

Thanks in advance for your help. Also if you have any other suggestions please let me know.
 

Answer:Need Assistance with Excel Spreadsheet

I have the logic down i'm just not sure how to implement...

*If D16 is null then F16 is null (but stiil keep the sum function)
*If C9 = "Call Off" then D9 = 3 and so on and so forth
*If B16 is < 6 mo then D16 = 0,
* F cannot be > 0
*If B16 greater than or equal to 30 days C23 = Drop Off
 

2 more replies
Relevance 54.12%

I'm using office XP in WIndows 98. I am unable to access any of my excel spreadsheet shortcuts on the desktop or directly by double clicking in my docs folder. However if I first open the excel spreadsheet and then open file from the file menu I can access all or any spreadsheets. Why can't I access any file as shortcut please?

Answer:Excel Spreadsheet Shortcuts

It may be that your file associations have been lost. Did you participate in the SO6 challenge recently.Resolution : Open Windows Explorer, select Folder Option, from the view menu.Select the File Type's (3rd) tab at the top of the new window.Check there for the XLS file exstension and check it opens with excel.Report back with the results.

3 more replies
Relevance 54.12%

I have created an excel(2003) program into which I can import daily pricing mutual fund & stock data from yahoofinance.com. It works quite well and the pricing data refreshes automatically each time I open the spreadsheet.
My question is: how can I create another program that will give me the identical results with bond prices? Apparently, the Yahoo website only allows me to enter fund or stock symbols.... not bond cusips.

Any help would be appreciated.

Greb

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)2 Quad CPU Q8200 @ 2.33GHz, Intel64 Family 6 Model 23 Stepping 10
Processor Count: 4
RAM: 4028 Mb
Graphics Card: NVIDIA GeForce 9800 GT , 1024 Mb
Hard Drives: C: Total - 476837 MB, Free - 419624 MB; D: Total - 114439 MB, Free - 17665 MB;
Motherboard: Intel Corporation, DG43GT, AAE62768-300, BTGT941001B4
Antivirus: avast! Antivirus, Updated and Enabled
 

More replies
Relevance 54.12%

System: Windows 7 Home Premium, SP 1, 64 bit
Laptop: ASUS K52F-BBR9
Printer: HP Deskjet 3000 J310
 
I solved a problem with an Excel spreadsheet that would not print, but have no idea why my solution worked. Perhaps someone can explain?
 
Problem:  I had to print 2 Word documents and 1 Excel document. The Word documents printed fine. The Excel document would not print. 
 
Symptoms:
(1) I had configured the HP Deskjet printer preferences "Paper/Quality" for "Plain Paper, Fast Draft Quality". 
(2) The document showed up in the print queue for the HP Deskjet but it never printed. 
(3) I opened the Excel document, clicked on Print. Under "Printer", the HP Deskjet was listed.
(4) In the Excel Print screen, clicked on "Printer Properties". The "Media" drop down list showed "Normal Quality", not "Fast Draft Quality". This led me to believe that although the document appears to show the correct printer, for some reason it was not communicating properly with the printer. The drop down list should have displayed "Fast Draft Quality" like it usually does.
(5) I stopped the print spooler, ensured there were no files in the Spool\Print folder, started the spooler. Problem still existed.
(6) I rebooted the computer twice. Problem still existed.
(7) I opened an empty Excel document, copied the contents of the Excel document that would not print to the new document, then saved the new document with a new name. I was able to successfully print the new docume... Read more

Answer:Could not print Excel spreadsheet - why?

Hi,
I don't see any point where you define the print area of the spreadsheet. The new sheet had a default definition which may have been the difference.
Keep us posted

5 more replies
Relevance 54.12%

I'm using Excel 97 and I have some old spreadsheets my father created to keep up with money he loaned people (he died 3 years ago or I'd just ask him!). I'm trying to collect this money for my mother and though I am able to use the spreadsheets the way they are, there's something on there that is driving me CRAZY because I cannot figure out what he did or how to get rid of it. There's a line that goes across the screen under row 2 and down the screen between column A and B. It goes all the way to end of the possible rows and columns, not just to the end of the spread sheet information. It is NOT a regular gridline or border. If I delete the entire row 1 it moves to just below row 1, but deleting more rows or columns does not eliminate the line. It is really just a picky thing, but I HATE it when I can't figure something out.

Oh, just discovered a couple of additional clues that may mean something to an Excel guru!! The information entered into cells A1 and A2 stays on the screen even if I'm waaaaay out past all information filled cells either row or column wise (in other words, if I'm in cell 65536 IV, I can still see A1 and A2 and the information in them on my screen) AND the black line I'm seeing actually extends past the last cells available into the gray part of the screen. When I've paged down as far as it can possible go and row 65536 is in the middle of my screen the black line continues on to the bottom of t... Read more

Answer:lines in Excel 97 spreadsheet

I finally found it. I knew it had to do with locking or freezing panes, but couldn't find where to fix it. YAAAAAY, I did it!! For anyone else who wants to know....in Excel 97 it's under the "window" menu, then freeze or unfreeze panes.

Thanks anyway, guess I just needed to know you were there if I needed you!!
Patti
 

3 more replies
Relevance 54.12%

I am trying to get a spreadsheet where a chart including a list of employees and dates of the month indicate which dates the employees are scheduled for.

I would like a second worksheet to populate a list of available (unscheduled) employees for an individual date when the user manually inputs a date of the month.

Here is some sample data:

worksheet 1:

worksheet 2:


I manually copied the data in purple. I would like it to populate through an Excel function.

Any help is appreciated.
 

More replies
Relevance 54.12%

How would I go about makeing a spreadsheet for this???

I need to make an excel spreadsheet to this extent

I have a list of 14 (15 really but you'll see why im doing this with 14 first) people.

Each person is going to be playing in an in house pool league sponsored by the amusement business I work for (my uncle owns it).

Each person will play 2 matches every week. Each match will be 1 on 1. In a 9 week period everyone has to play everyone, and their cant be extreme repeated matchups like player 1 and 4 having played each other 4 times more then the next most common matchup.

The 15th (and odd player... it would be easy if it were an even number of players playing an even number of matches) player makes it hard. Now 2 other people from the 1st 14 have to play this guy makeing 2 of the 15 play 3 matches per week instead of 2. Which is okay as long as everyone plays him atleast once, and no extreme repeated matchups here as well.

Randomness is a good thing, and would be very nice if people dont end up playing the same people too often.

Names arnt important, once I get the general idea I can assign names to the numbers from 1-15.
 

Answer:Help makeing spreadsheet in excel

Just rotate. If you use relative formulae, you can copy and paste and Excel will carry the rotation to the next week.
 

4 more replies
Relevance 54.12%

Just how secure is an Excel file protected by a 4 digit number? I store various passwords in one in the form of hints to them which only I would know the answer to e.g. name of first dog/camera/ girlfriend etc.So far so good but I'm not sure how easy it would be for someone to crack the access number. Anyone help?

Answer:Excel Spreadsheet Security

Depends who you are prtecting it from. A 4 digit number gives a possible 10,000 different combinations so would be quite safe from the average user.If someone is determined, they may 'research' you (birthdate, family birthdates etc) and try those numbers first but again depends on how likely this is to happen given your particular situation.Worth pointing out that no excel document is completely secure - any doc can be opened regardless of protection if the correct process, macros and software are used. Always worth laying in additional protection (place the doc in a secured area of your HD for example).

8 more replies
Relevance 54.12%

I am trying to add "r" letter to a cell # formula.
I want to add how many rushes "r" a football player has with the yards he gained.

(c15:az15) find rushes that correspond to a player's number in cell (h32)

can't figure it out. Please help !!!
 

Answer:Excel spreadsheet formulas

14 more replies
Relevance 54.12%

Dear Forum

I would like to learn how I can convert the memberlist table from this particular website: http://mr.di.dk/omos/medlemsoversigt/Pages/medlemsliste.aspx
into a excel spreadsheet with the following sorting headlines horizontally:

Company name Address Zipcode and City Phone E-mail Website
I really hope you can help me as it will take "forever" to do all the sorting manually:-(
 

Answer:Excel spreadsheet sorting it out

Try the attached. My HMTL to TXT conversion cocked up the email addresses and removed the @ signs but they should be easy to replace in notepad.
 

2 more replies
Relevance 54.12%

probably a simple question , but i cant find instructions in the help manuals for excel.

How do i import a comma seperated database into a new Excel spreadsheet , so that each comma seperated number goes into its own cell ???

thankyou kindly for any instructions.

(everybody has to start learning somewhere )
 

Answer:importing CSV spreadsheet /Excel

If they were exported they should also show the column headings that were in the original db as well. All you have to do is go to File > Open and under file type select txt, csv and then just open the file. A wizard should then come up where you can define how and what is imported into Excel
 

2 more replies
Relevance 54.12%

I have to admit that I am not proficient in the MS Excel program. I have to fill in a form for a potential employer but the cell is too small to contain all of the information--the information that I typed in goes "off the page" into neighboring cells that are not part of the form. I can't seem to figure out how to fix this.

Can someone give me a clue? Thanks for any and all advice!

Answer:Problem with Excel Spreadsheet

Hi technomann

There are easy two options:
Excel Column Width - Change Column Width in Excel - Column Width Change in Excel

or...

Wrap text in a cell - Excel - Office.com

Good luck with the job!

4 more replies
Relevance 54.12%

I have an Excel Workbook with 24 sheets in it. 12 of these sheets are charts. They were not created uniformally. I would like to change them all at once. Is there a way to group the charts together and make one formatting change (to the Chart size or color for example). I have tried the CTL key to group the sheet together but the formatting doesn't work?

Thanks for any help.
 

More replies
Relevance 54.12%

I am trying to create a specific calculation in the Excel spreadsheel application and try as I might I cannot get my head around it.

I have four adjacent cells containing different commodities that provide the sum function of a requirement.
I have an identical arrangement of cells containing the same commodities providing a total of available assets.
Finally I have a further identical arrangement of cells containing the same commodities to be used as a levelling factor.
The concept is to use the levelling factor cells combined with the assets to create the maximum requirement amount while maintaining the differentials between the individual cells in each calculation.

I have tried to put this problem into words and although it makes sense to me I can understand it may not be clear to anyone else.
I can provide a copy of the spreadsheet as a visual aid if that would help - it is not sensitive material.
 

Answer:Excel Spreadsheet Calculation

16 more replies
Relevance 54.12%

How do I transfer an Excel spreadsheet from my laptop to my Nokia Lumia 820?

Answer:Excel Spreadsheet Transfer

Connect your phone to the laptop using the normal cable, then copy the excel into the document folder of your phone. That's about it.

6 more replies
Relevance 54.12%

Hi There PeopleI have downloaded an Excel spreadsheet but the monetary values are in $ I need to change then to ?.Can anybody help pleaseI am using XP and it concerns Office 2010RegardsTonyP.S Mods sorry if this is in the wrong section,please feel free to move it to the right one.

Answer:Convert $ to in an Excel spreadsheet

This just inHello scubatony: Your question on Microsoft Answers has received a reply: Question Convert $ to ? in Excel Reply Highlight the range of cells you want to change. Right click and click on:-Format Cells . . . The Format Cells window should open. Click on the Number tab. In the:-Category: - box set it to:-Currency then click on the pound symbol (in the Symbol: box). Click OK. If my comments have helped please vote as helpful. Thanks.

4 more replies
Relevance 54.12%

Hello,
I have a question, I am hoping you can help me out on an Excel question.
On some of the spreadsheets that I do, when I key in a number that starts
with 0, it takes the 0 off and I have to use that mark ('), but on some I
don't have to. Do you know why one spreadsheet would differ from the other?

And one more thing about that, when I key in on a spreadsheet under a heading that says
"Inner/Case Pack" let's say 6/72 it reverts back to 72-Jun and on other spreadsheets it doesn't. The OS is Win2000 and MSOffice 97.
 

Answer:Excel spreadsheet problem

If you go Format\cells and under number tab, there are list of format you want to use for the specific cell you've highlited.
"0001" is considered text. If you want to display as it is, you have to format the cell(or area) to text.
Go check formatting of each cell on your spreadsheet, and you will see it.

TJ

Same thing with the date.

[This message has been edited by tjsudo (edited 11-30-2000).]
 

2 more replies
Relevance 54.12%

Hello,

I've been experiencing BSOD over the past month. Just ignored as it was random but i've now realised that it's usually happening when I'm using Excel.

I have attached the dump files following the instructions on the forum.

I've tried to use the debugging tool for Windows but it just won't work properly for me.

Is anyone able to help me find the cause please?

More replies
Relevance 54.12%

Every month for several years I have accessed my own spreadsheet offline from desktop icon.
To utter consternation and increasing frustration, today OPEN brought up the file BUT can do nothing with it.
Same results with backups on different drives.

Consequently told browse to find program from which can OPEN. Obvious choice MSN Excel. Result: "Cannot find any version ...to open file for edit".

Further on I installed msn xlviewer. In Open process came box, "Office Source Engine (Process ID: 2120) running. Need to Close". How/where to do so no idea. I am on Vista Ultimate with !E7; note not included in list for this item.

FYI, I only have Office 2002 (with Excel 2002), but cannot even remember last time I used it for anything. Also note many MSN references to Office 2003, but hardly ever 2002.
Point is, HOW CAN I GET BACK WHERE I WAS & NOT BE REFERRED TO NEED FOR A PROGRAM (EXCEL)?
Only secondarily (and reluctantly) interested in making Excel function to restore ability to use my spreadsheet.

I will be most grateful for help in this unexpected problem.
 

Answer:Solved: Spreadsheet with/without MSN Excel

16 more replies
Relevance 54.12%

I had an excel spread sheet on a flash drive that is connected to my computer via a usb port. I'm running Windows 7 and Office 2010. I accidently deleted the excel spread sheet while looking at it on my computer. It's not in the deleted "trash can" on the computer. Where else might it be or how can I get it back?
 
 

Answer:deleted an excel spreadsheet

You may be able to recover the file using a data recovery program such as Recuva.

2 more replies
Relevance 54.12%

Say i have 2 files.

Both are identical in format.

one is created on Monday, the other is created on Thursday.

Is there an option in Excel that will automatically compare the Monday spreadsheet with the Thursday spreadsheet and highlight changes?

Like, for example, Cell B15 on Monday gives a date of 01/04/04, and Cell B16 showes In Progress...

and on Thursday it shows Cells B15 as 1/08/04, and B16 as Complete...it will highlight those.
 

Answer:Excel spreadsheet comparison?

This might be what you want to do... (Direct from the Excel Help file) HTH.
------------------

Highlight cells that meet specific conditions
Select the cells you want to highlight.
On the Format menu, click Conditional Formatting.
Do one of the following:
To use values in the selected cells as the formatting criteria, click Cell Value Is, select the comparison phrase, and then type a value in the appropriate box. You can enter a constant value or a formula. If you enter a formula, you must start it with an equal sign (=).

To use a formula as the formatting criteria (to evaluate data or a condition other than the values in selected cells), click Formula Is in the box on the left, and then enter the formula in the box on the right. The formula must evaluate to a logical value of TRUE or FALSE.

Click Format.
Select the font style, font color, underlining, borders, shading, or patterns you want to apply.
Microsoft Excel applies the selected formats only if the cell value meets the condition or if the formula returns a value of TRUE.

To add another condition, click Add, and then repeat steps 3 through 5.
You can specify up to three conditions. If none of the specified conditions are true, the cells keep their existing formats. You can use the existing formats to identify a fourth condition.
 

2 more replies
Relevance 54.12%

Hi guys,I'm trying to save an excel form but i can't, everytime I try to saved it, I'll get this message...I do have Admin rights to change the settings of the folder..This is what I done so far...went to the folder ...right click ...properties...security tab...highlighted the usersand check the ALLOW FULL CONTROL. I also did a right click on the excel form went to properties and check the Attributes the read-only is uncheck...I don't know where esle to check  ...any Ideas???thank you all!!! 

Answer:Need help saving an excel spreadsheet.

Restart your computer to make the settings take effect.  If you need to save it as something so you don't have to do your work again then take the advice of the popup and use "save as" instead of "save".  Then reopen it and save it as the old name.  The restart should let any changes you made to the permissions take full effect.

5 more replies
Relevance 54.12%

Hello everybody.

I have an excel spreadsheet that when you try to open it, you get a file can not be read error. I googled an excel repair program but all i get is demo programs that say file is repairable, but you must purchase software.

Does anyone know of a free program that can repair corrupted excel files. Thanks in advance.

Answer:Corrupted Excel spreadsheet

Try this http://www.socrtwo.info/excel.htm

I don't know any free tools for recovering excel files that actually works..

2 more replies
Relevance 54.12%

I am trying to count text in specific cells, not in a range. How can I accomplish this? Specifically, I am trying to count the occurences of "UL" in only cells H3, K3 & O3. Please help, thank you.

Answer:Excel Spreadsheet Problem

you can use a nested if statement, look here :-http://www.microsoft.com/office/community/en-us/default.mspx?&lang=&cr=&guid=&sloc=en-us&dg=microsoft.public.excel.worksheet.functions&p=1&tid=9737BEA0-60A8-49E7-B96C-2B74A27333AE&mid=9737BEA0-60A8-49E7-B96C-2B74A27333AE

3 more replies
Relevance 54.12%

In doing a spreadsheet with long header titles and fairly narrow columns, I am turning the column titles to a 45* degree angle.

However, when wanting to print that same spreadsheet WITH the gridlines option, the pre-set gridlines don't turn to match the angle of the wording. Does anyone know how to angle and diagonally print those gridlines?

Thanks,

Hank
 

Answer:headings in an excel spreadsheet

Same thing happens to me if the width of the column headings is less wide than the column itself.

If I set borders on those cells, it works as I believe you want it to, and all other gridlines look good. You may want to choose Format-Cells, Borders, and choose the line style that looks like a gridline.
 

3 more replies
Relevance 54.12%

Shouldn't an Excel spreadsheet ( including the Visual Basic portion) that was produced with Excel 97 also work in Exel XP.When I try this, I get this error message -Run-time error 1004Calculate method of range class failedThe spreadsheet works fine in Excel 97 but, the Visual Basic part does not work in Excel XP.What is causing this?ThankyouEd

Answer:Compatibility of an Excel spreadsheet.

There was a big change between XP/2003 and 2007 versions so it isn't too surprising that something created in 2007 won't work in the XP/2003 version. There's unlikely to be a Microsoft workaround as it's not to their benefit to make everything backward compatible and they usually cite security issues being the reason. If the user does not want to upgrade to a newer version of Excel, have you tried opening it in one of the free Office suites like OpenOffice & see if it works?"I've always been mad, I know I've been mad, like the most of us..." Pink Floyd

3 more replies
Relevance 54.12%

I a little rusty but I'm trying to create an excel payroll spreadsheet and I'm running into formula issues at every turn. I'm trying to insert a formula that takes my gross income (L3) and calculates federal income tax withholding including deductions and to show the total in Fed W/H box (M3)
I also need to calculate Suta at .8% up to $7000

I know this is a lot. I am just getting back into the workforce after almost 10 years of stay at home mom, and my brain is trying to catch up. Thank you in advance.
 

More replies
Relevance 54.12%

In Excel, I hit the email button to send a spreadsheet to other people. When they receive it, the rows of the spreadsheet are kind of squished. How can I unsquish?

Answer:Sending Spreadsheet from Excel

How are you mailing it?File > send to > Mail recipient (as attachment).Noldi

10 more replies
Relevance 54.12%

Hello,

I've been experiencing BSOD over the past month. Just ignored as it was random but i've now realised that it's usually happening when I'm using Excel.

I have attached the dump files following the instructions on the forum.

I've tried to use the debugging tool for Windows but it just won't work properly for me.

Is anyone able to help me find the cause please?

Answer:BSOD Usually happens when using Excel spreadsheet.

Please remove all pirated programs and such from your system before we can start troubleshooting.
The Forum Rules is meant for everything regarding piracy
Discussing it,Asking for guidance,Asking for a crack,The use of it,Etc.





4) No piracy or discussion of piracy allowed at all. Such as software, music, videos and other intellectual property violations (e.g. downloading youtube videos locally etc).

1 more replies