Thanks Hui
The only snag is that there would be in the region of 50-60 requisitions being raised every day, thus I only want a notification or alert sent, rather than the worksheet attached if that makes sense.
The workbook is saved to a central location..
Hi, this is a cross post http://www.ozgrid.com/forum/showthread.php?t=150920 as I am getting desparate for some help...
I have a requisition template which currently has a button which saves a copy of the workbook to a specific location with the requisition number as the file name.
On file...
Hullo
I need to send a worksheet by email ie SendEmail, but it needs to be as pdf.
Any ideas? I need to keep the original xlxs format, but I will not need the pdf once its been emailled.
Hope it makes sense, appreciateit if anyone has any sample code to sort.
cheers
Dear All
I have a spreadsheet which consists of the following columns:-
Column G: Date of Enquiry
Column K: Quote Return Deadline
Column L: Quote Value
Column M: Order Probability (Percentage)
Column S: Estimated Order Win Date
Basically from these I need to create a few charts.
Chart...
Hi
I have the following code:
'Sub RequisitionCompleteMsgBox()
MyVar = MsgBox(Prompt:="Thank you. You have saved your Requisition successfully. You can now close this workbook without saving further.", _
Buttons:=vbInformation, Title:="Requisition Submitted!")
MsgBox MyVar
End Sub...
I am still learning the very beginning of VBA and enjoying some of the results I am coming out with.
However I am stuck with a problem where I want a multi-field input box that when you enter the info, the information is pasted into the last row (i.e. not overwriting). How do I write the VBA...
Hi
I have a worksheet template (a type of form to be filled out).
I would like to SaveAs a worksheet named after one particular cell (this cell is different with every form that is filled out), perhaps with a macro or similar.
Anyone have any ideas how to do this?
Many thanks
Hello
I have a workbook wich contains a Quotes Register. I have uploaded this file here:- https://www.yousendit.com/download/RIRwSXQwQXBtMEt4dnc9PQ
Ideally, what I wish to do is to fill out the relevant details and then hit a Submit button; this should then open up Quotation Form Template...
I have saved a workbook as a template in a shared folder. The problem I have is that other users are using the template and then Saving As a template again - rather defeating the object!
The template in query is actually just a simple form for technicians to fill out their reports on -...
@hui
Okey, thanks... but if say C4 was "Yes", how can I make that format row 4? Do I enter the formula in a separate cell or how do I do it?
Thanks very much.. :)
@chandoo, @dan_l
Thanks for that. Basically I want to have a text cell to be formated a certain colour based on whether the text entered is "Yes" or "no" etc.
Bearing in mind that although I am working in 2007, I need it to be compatable with 2003...
Thanks for the great tips and keep up the...
Say the table column had values such as "Eggs", "Corn", "Beef" etc, I need to be able to get the table to show just "Corn" and to hide the "Eggs" and "Beef"
Hope that makes sense!