need help

I am currently using the macro illustrated below, which has been working perfectly fine for a long time. The only problem I'm currently encountering is whenever it is processing data that contains text within sentences and paragraphs, it always changes whatever the current dating format is to...

Hi all, I currently have no starting point so need someone to help me from scratch :-) I need a macro to do the following: - Open 'Insert picture dialog box' - After user has selected the pics they would like inserting, then for the macro to insert them into a particular section of cells and...

I was given a macro for this but it doesn't seem to work. Hopefully someone can help. column A will contain a list of telephone numbers entered in this format: (xxx) yyy-zzzz which is how it would appear in the formula bar if the cell were selected. I need a macro that would eliminate all...

I have a table that kind of looks like the one below. Over the top is departments and the rows are different items each department may need. The "X" indicates that department is in need of that items. Sales Marketing Finance Etc. Paper...

Dear All, There are two column mentioned below <tbody> Animal Name Animal Type </tbody> In the column named "Animal Name" there is data validation of all Animal like <tbody> Goat Cow Horse <tbody> Lion Tiger Fox </tbody> </tbody> There are two other column <tbody> Types...

Hi Guys, Can you please create a VBA Macro for me. I hope and believe that you can help me here. I am Jain with excel <acronym title="visual basic for applications">vba</acronym> programming and I am creating a break tracker program using excel with <acronym title="visual basic for...

Hi Guys, I hope and believe that you can help me here. I am Jain with excel vba programming and I am creating a break tracker program using excel with vba. My excel file contains the data for all employees. I have a Userform where the user will enter his employee ID which will pull up his data...

Hi All, I do not know which formula to use for what I am trying to acheive, so any help would be fab... I am tyring to put a formula in sheet 'sheet 4', cell A2, that says: if in sheet 1, "further Investigation" is in column D, and a figure greater than 0 is in column O,- then show me this...

Hi all! I am fairly new to the VBA portion of excel and could use some help with writing a macro! Any help is greatly appreciated. I am trying to write a macro that will: prompt the user for a date (any date) in mm/dd/yyyy format display the year, month, and day in separate MsgBox(es)...

Need help with this: I want to cap the first letter of every word within a cell, NOT just the first word. =proper(A) doesn't work for me because if a word has an 's at the end such as Physician's, it will also cap that s so it ends up as Physician'S. The following program works great...

Hoping someone can help me with this one. I've tried the COUNTIF and the IF methods I could think of and I can't figure how to make a simple formula I can put into the cells of a column that will do the following: Consider that Column E needs to contain a list of dates. 1. I need a formula...

have create one userform and want change format for text box like if i fill any data in this text box data should fill (MH -12 - GH -2014) first only allow 2 letter after that dash(-) after that 2 number dash(-)2 letter after that dash(-) and in the last only 4 number system should allow to put...

Hi i have a cell B2 which has a data which is live and keeps on changing continuously now on A2 i want to capture the lowest number that B2 has made though out the day. Like if B2 moves from 10 to 15 then A2 should keep showing me 10 until B2 comes below 10 then A2 should show me the lowest...

P In given below model according to sun & sat I can move formating however unable to move wo with sun or sat . When I changed date only formating will go with sun or sat. I want to move wo to p and p to wo according to change of day like sun & sat if you not getting what i want then i will sent...

I have shared drive mapped to directory "M:\\". I have lot of folders and and subfolders in it. I want to run a macro which would search the folder name (Column A) in the directory and find the availability of the "Part of the File Name"(Column C)) and return Available/Not Available in Column...

I have a shared drive mapped to directory "M:\\" I need to search a file from one of the folders in the directory. I'm able to list all the files from a folder in a excel sheet by specifying the path in the program. But I don't know how to search a individual file in the folder with two...

<TABLE style="WIDTH: 442pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=589><COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><COL style="WIDTH: 145pt; mso-width-source: userset...

<link rel="File-List" href="file:///C:%5CDOCUME%7E1%5CUser%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/>...

I am trying to combine the VLOOKUP and the IF functions in a different kind of way...I made this formula, and in theory it should work..buuuuut..in reality it doesn't. this is my formula...I want it so that if in the cell G2 there is a certain name of a company then the result will be just...