Search results

I have looked at that link by danielcurran it explains how to create a reminder email but not a appointment. http://www.2shared.com/file/0OkoOQsP/Works_Project_Schedule_Tester.html

I have a task that has to be done in Column C3:C600 I have dates Column D3:D600 if 1 month before the date in Column D, I need a reminder in Excel for the duration of all day event. The subject would be Column A, location would be Column B and the body of appointment would be Column E I have...

Is there another way to copy it seems to be picking if anything is in the cell regardless if it is a number or text it should only be copying if number is greater than zero.

I need help I have this macro and I would like it to find greater than zero at the moment it is value <> as I have large spreadsheet that has zero as well it is picking up those as well. Private Sub CommandButton1_ClickXXX() Dim SheetName As String SheetName = "Estimate1&#34...

If I use either of these macro can I change it and add that I would like BY and BZ columns joined togehter with a hypen - Or can I add a concatenate to the macro.

Going back to my original code is there a way to have a blank cell if I write another macro to start at 1 to 118 then 1 blank row then start again from 118 to 561 continously mycol 3 my row 25 then mycol 16 my row 25. I hope this makes sense??

Thankyou so much for that it worked great but I should have taken out the carry on MyCol 16 I dont want it to carry onto MyCol 16 but just tell me it ran out of room at MyRow 52 sorry for that. How would I fix this.

http://www.2shared.com/file/EziNjFPX/sample_workbook.html

I am trying to figure out when I run this macro if there is already text or value in it will skip to next blank row ie row 27, 28, 29 are filled then skip to row 30 and place text or value. Private Sub CommandButton1_Click() Dim SheetName As String SheetName = "Estimate1" SheetName =...

I need a formula to put in B91 If B88 is less than between 0-315 put the amount in B91 or if B89 is between 316-630 put the amount in B91 or if B90 is between 631 and 945 put the amount in B91 eg 200 metres is in B88 I need 200 to be placed in B91 or 453 metres is in B89 I need 453 to be...

How can I select different cells instead of just 1 cell LR = Sheets(SheetName).Range("CC" & Rows.Count).End(xlUp).Row MyCol = 21 MyRow = 39 For i = 121 To 121 If Sheets(SheetName).Range("CC" & i).Value > 1 Then Sheets("JJRobbins").Cells(MyRow, MyCol).Value =...

Thank you for all your help they worked perfect. Great work.

Can some help me? I need to write a formula that will find the text Travis in M45 and put a phone number 039123456 in M47 but if the test Andrew is found in M45 I need M47 to read 987654612 or if the text Peter is found in M45 then M47 is to read 0397846124

I figured it out thanks again for all your help much appreciated.

Ok I'm back already I had given you a test file but now have tried to use code in real workbook and have a problem I need the values to stop at row 39 as you will see on my download as it is a form that is getting filled out. http://www.2shared.com/file/CXPJc5eq/BLANK_WORKS_COST_-_SJ_03102012.html

You are my new best friend "Genius" thank you so much.

http://www.2shared.com/file/JgATMvhz/BLANK_WORKS_COST_-_SJ_11JUN_20.html

Ok we are getting somewhere what if C1:C17 is filled with value it doesnt seem to want to go up and start at M1 to continue it just tells me I have run out of room and not copied If I add to BY:CA and it has more than 17 values I need it to go up to M1 and start again or C1 to M1 then down a...

Thanks for everyone's help but I must not be explaining myself property I have Estimate1 which has 3 columns BY:CA which has values in it. I have a worksheet which i have attached called Cost which I would like to copy if Estimate1 has value in BY:CA copy into C1 (Cost) G1 (Cost) I1 (Cost)then...

Can anyone help with this??

Sorry I think Im confusing you. I need it to keep the row that Qty is in and add blank row above as Qty is a heading

I need it to insert the entire row above, it is only changing column f

i NEED A MACRO THAT WILL INSERT A ROW ABOVE IF THE WORD QTY IS FOUND IN COLUMN F.

http://www.2shared.com/file/Wo3xRgsQ/BLANK_WORKS_COST_-_SJ_11JUN_20.html If the macro works properly it should look like this. I have to sets of columns like a table. Thanks for any help greatly appreciated.

http://www.2shared.com/file/hztRN8wj/BLANK_WORKS_COST_-_SJ_11JUN_20.html