Highline Excel Class 01: Back To Basics

Hi Guys,
I am putting together an invoice sheet for a good friend of mine, for his new company. I have done the layout and all is good, I just want to add some automation to a few things.
What I want to do is be able to search for the address of an existing customer and put it the right place on the sheet. This I am trying to do by having the various address in a column and then envokeing a copy/ paste routine.

This is the code I have at the moment, its nearly there but a bit buggy and I havnt added the paste routine yet while I try to iron out the bugs.
---------------------------------------------------------

Dim a As Variant
Dim address As String
address = Range("A1").Value

If address = "" Then GoTo ErrHandler


On Error GoTo ErrHandler:
Set a = Range("A1:A1000").Find(What:=address)
a.Activate

Range(ActiveCell.Offset(0, 0), ActiveCell.Offset(4, 0)).Select
Selection.Copy

GoTo finish:

ErrHandler:
MsgBox "Sorry - No match found", vbOKOnly, "Rewmersoft Software"

finish:
End Sub
---------------------------------------------------------------

I just wondered if anyone had any tips or suggestions ?
The annoying thing is , I have allready done this once when I had an office job about ten years ago I wrote some pretty cool code to do this that worked off the Worksheet_Change function, and used some cool userforms, but this was 10 years ago and it would seem I have forgotten all I learned then.....

Hi guys, im a complete novice when it comes to excel however i have been asked by my employer to produce a spead sheet to manage data about fines.

I currently have one tab holding Consumer data that i want to use as my main input screen.

I am trying to make the data appear on the next tab if it is nessecary to send them a fine.

this is the formula i have written but i am abviously not quite getting it rite.

=IF('Patient input'!B2=yes,("0"),('Patient input'!A2))


Basically i have a list of Names on sheet one with a yes or no box next to it.
On tab two i want a list of fines to be sent so if there is a yes in that box then do nothing, if there is a no in the box add the name of the consumer to the list of fines to be sent on page 2.

Help anyone?

I've got my records going into one workbook... There are 24 customers... I'm not that interested in a workbook per customer but I really need to sort them by customer... Apart from using 24 Advanced Filters which I can't get ONE to work properly anyway... How can I sort my data by customer?

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

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.

Hi folks, I have spreadsheets emailed to me that have multiple worksheets, made up of graphs and tables. When I ask the application to print back to back, on an HPLaserjet 1320tn it does do the tables back to back, but not the graphs. Is there a way to print the graphs back to back? Many thanks

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

Hi, I have an excel 2007 document that is made of multiple worksheets - graphs and spreadsheets.
When I ask it to be printed back to back on an HP LaserJet 1320tn, it can do the spreadsheets back to back, but not the graphs.
Any idea why?

Many thanks for your time!

I'm trying to populate a Word 2003 document with data from an Excel 2003 document -- I realize some use mail merge but this, for me, has been an excruciating pain in the neck, so I am trying to avoid it by going the Word bookmark route, which looks like it will fit the bill... if only I could figure it out!

I have done some searches on here and this is the code that seems to have set the precedent:

http://www.mrexcel.com/forum/showthread.php?t=478182

However, as a beginner, it's a bit overwhelming for me. While I'm learning a lot by looking at it and looking up the things I don't understand, it's taking a long time and I actually need to use something similar for my own project.

Specifically, I wanted to open a template letter; populate it from the active Excel row I'm working on; and then "Save As" so I can keep the template.

Is there some more generalized information out there that outlines this procedure? Otherwise, would someone be kind enough to separate the code and/or elaborate more on what the invididual lines/sections do?

Hope you can help!