Posts by Ingo_Ingo

Re: File copy from a folder

patel,

Goooood job!

Re: Print Number Of Copies Based On Cell Value

Quote from djtonton;701034

Is there a way to say if there is a 0 there to skip and not print the page. Right now if there is a 0 i get an error 400

Try

Sub PrintBasedonCell() 
     'Change Sheet1 & 2 CodeName to suit
If Sheet2.Range("A5")=0 OR Sheet2.Range("A5")="" Then Exit Sub
    Sheet1.UsedRange.PrintOut Copies:=Sheet2.Range("A5") 
End Sub

Re: Count Worked Hours?

Crosspost http://www.excelforum.com/exce…7-count-worked-hours.html

Re: Find manufacturer and product description from barcode number

Ochimus,

You understand that this is a site for those who need help in EXCEL. And do not think anyone has such a "list" with the meaning of the EAN number (I refer here to a list of manufacturers, country of origin, product code etc ...). But you can search on the net significance corresponding figures EAN 12 code that you use.

Re: Room Booking System

Cross post Booking System

Re: Excel VBA to enter hyperlink in email body from cell reference

snb,

Excellent. Thank you very much.

Re: Excel VBA to enter hyperlink in email body from cell reference

Quote from snb;687611

You are quite right:

Code

Private Sub ClosedButton1_Click() 
    c00 = "Dear " & Cells(15, 20) & replace(",~~Please note that I have applied for leave on my leave card.~" & TextBox6.Value & "~My Leave card can be found here:- <a href=""" & Range("T22") & """ >leave card</a>~~Awaiting your response.~~ " & Cells(3, 3),"~",vblf) 
     
    With CreateObject("Outlook.Application").CreateItem(0) 
        .To = Cells(16, 20) 
        .CC = Cells(17, 20) 
        .Subject = "Application for leave" 
        .HTMLBody = c00 
        .Send 
    End With 
    Unload Me 
End Sub

Display More

snb,

In your code it is possible to introduce vbCrLf or something so that the text will be on multiple lines?

Re: Copy and rename sheets

Bump

Re: Assign Numberpad key presses to Userform buttons? Is this possible?

snb, that's very nice.

Re: Copy and rename sheets

Quote from patel;685947

you started with 2 sheets, now please, explain better your problem

The problem is the same, from first post, but do not expect answers like this: "You CAN delete the existing sheet, THEN copy the new". A code to do what I asked in the first post would be perfect.

Re: Copy and rename sheets

How easy would it have been to be found quickly and have them removed. But I have over 150 sheets in the file. I would not have asked for help in this forum but so ...

Re: Copy and rename sheets

Hi,

Thanks for the reply but if you want to overwrite the sheet how do? I wrote that I want to create 2 sheets (actually more, but I hope I can change the code :wink:).

Hi,

How can I copy 2 sheets - named A and B - (in the same file) and rename them say AA and BB, but if sheets exist to show a message whether to overwrite or not. If answer is to overwrite then overwrite else exit sub.

Thank you.

Re: Producing Averages excluding Zero's

Hi,

Sorry I'm late but I can't acces the site with my phone...
Try this in U2 =AVERAGEIFS($B2:$S2;$B$1:$S$1; "=*%";$B2:S2;">4") and copy down.

Re: Producing Averages excluding Zero's

Hi,

What version of excel do you use?
Upload your excel file with dummy data.

Re: Populate multiple fields from a single drop down selection

Hi,

Something like that?
See in attach.

Re: Change sum and average if cell color change.

Thank you mikerikson

Unfortunately I can use only one helper column. Thanks for the solution time.

Re: Change sum and average if cell color change.

OK. Thank you for reply.

Re: Change sum and average if cell color change.

Thanks for replay.

I saw this things in an excel file, but I have not had access to that file and see the code. So anything is possible but I do not know if it's a UDF function or VBA code.

Hello,

In range (B2: F10) have numbers. In column G we mean the sum of the rows in G2 = SUM (A2: F2) in G3 = SUM (A3: F3), etc.
In B11 = AVERAGE (B2: B10) in C11 = AVERAGE (C2: C10) etc.
If C4 fill it with a color I would like the amount of G4 to decrease with cell value and vice versa if you get normal color in cell the sum of column G to modify with the cell value. The same for AVERAGE of the line 11.

For example say in C4=10 and sum in G4=100, if I change color of cell C4, sum in G4 will be 90, if I remove color of C4, G4 will be 100.
In same way for AVERAGE in row 11

Thanks.