Hi guys,
I am working on a new Excel AddIn to simplify the charting of Excel data over Google Earth. The idea is that you can add Google Earth as a charting tool for you Excel work.
Is in early stage so be ready to see problems. Head over www.cctindustrial.com/kmlxl if you want to try it. Read the tutorial or you will not understand anything!
Remy Paternoster
rmpaternoster@gmail.com
Is there sample files used for this book? If so how can download from this site?
Good day,
I am a novice user of Excel, and have 0 programming experience, in any language. I just wanted to be clear, I understand I don't really belong here, but it seems the best resource for my needs. I lurk here quite a bit, and think I've learned a fair amount, but my boss has asked for a change to a spreadsheet that I cannot seem to work out the new formula for.
I'll see if I can explain, unfortunately I can't download extra programs to my work computer so I could post examples of the spreadsheet I'm working on... anyway
In short, I need to figure the time elapsed, in hours:minutes, between to date/time events. I have been doing this with a simple =max-min as the date/time events were in one field each:
Field 1: 1st event date/time
Field 2: 2nd event date/time
Field 3: Elapsed
But now I've been asked to change the format to:
Feild 1: 1st event date
Field 2: 1st event time
Field 3: 2nd event date
Field 4: 2nd event time
Field 5: Elapsed
(I don't know if it matters, but I enter the data across, not down, so the fields are a1, b1, c1, as opposed to a1, a2, a3)
And I don't know what the most efficent way of getting that math to work. Should I be looking at a way to put the info into one worksheet and have it display in a different one?
I appreciate any advise ya'll would be willing to extend.
Thanks in advance
Alex
Would it be possible to use the =NOW() function to use a timesheet that when you open it, it automatically puts the time in for you rounded to the nearest 5 mins ?
Im just confused to how to do this if it is poss as if i add =NOW() to every cell it will obviously add NOWS time to all the cells and that wouldnt be very clever ?
Hi,
If anyone got dashboard reports templates or dashboard creator add-ins please help me.
So here is my story, I am trying to do a mass update of 950 rows worth of objects in Excel 2007. I have column B (middle column in images posted) which contains the old sentence structure for a requirement. Column C has the format for what the new sentences should look like. Look at the two examples below...
BEFORE
AFTER
Note that in column C in the AFTER picture, document number replaced and document title replaced . How do I perform this operation en masse via a macro? Thank you!
DISCLAIMER: I am a complete n00b to macros.
Matt
Please can anyone help me answer any of these questions:
How would you add the contents of the cells from A1 to A10. Give 2 ways
to do this. (hint: Look up "Examples of common formulas" in Excel
help
How do you format a cell to have dollar signs next to the numbers?
How do you add the contents of cells A1 through A10 on sheet 1 and make
the answer show up on sheet 2?
How do you rename a sheet?
Can I delete the sheets that I don't need? If so how?
How do I freeze rows or columns of the sheet so that they don't'
move when you scroll up or down? Example: My name is in Column A, when
I scroll right my mane stays on the screen and column B moves behind A
How do you add up all the contents of column D and make the answer show
up in column C?
Thanks in advance!
abi
I have a spreadsheet that shows a date, because of shipping I need to enter a
date and then calculate three months back and enter that date, For example
Cell A1 March, 2004 and I have to enter into cell B1 January 2004, how do I
get Excel to do this automatically.
I went to the website cpearson.com and got the information for the syntax and the formula to sum numbers in different colors on a worksheet
now my problem is where do i put the visual basic part of the works so the formula can call on it
can you tell i have no idea but great hopes!!!
thanks everyone
Hy I have a ldata base with the next fields: tv, fridges and computers with their pices. All that information is bringed in the front page by data validation. I make the sum of the prices. Until this all its ok. But if I want to buy only a fridge and a computer and not a tv the sum will look #N/A
How can I resolve this problem: to have the sum even I didn't selected all the parameters?
Thank you very much.
