Search results

Sorry am I missing something or did you create a new workbook and I need to upload it somehow?

I have had no luck getting this to work could you please show me on my uploaded file. Thanks

Ok lets try again from the start. I have a Workbook (called Cost Schedule.xlsm) with a Worksheet (called Work Schedule) I need many conditional formatting rules and I update this sheet on a daily basis. I thought running a macro on open or exit to see if the criteria is meet and it would...

Can anybody help with this I have tried to look at all sites but with no luck

I would like it to run when a name lets say Peter is added into Column M and the word 'special' is in Column A so maybe and if statement.

What do you mean by Are you open to help-Columns The rows wouldn't ever go pass 1000.

I am using Excel 2007 and Outlook If Sheet1 Column A has the word Special within that cell could be "Special Date" or "Special Item" (only need to find the word Special) and a user puts a persons name in Column M an email will be sent to that person telling him he needs to order Column A and...

Sorry I had the wrong part of the macro selected I need it to find text in Column A1:A770 copy that row right up to Column P and then paste it into Worksheet "Costings: Sub MoveEstimate_to_Costings() Dim SHEETNAME As String SHEETNAME = "Estimate1" SHEETNAME = InputBox("enter the name of a...

I need a macro that will copy A11:P770 if text is found in Column A I need it to find the Sheet that users are working on see Macro Example and copy to another worksheet that will always be called Costings Sub MoveEstimate_to_Costings() Dim SHEETNAME As String SHEETNAME = "Estimate1" SHEETNAME...

This is the code I'm using to copy and paste rows into Cost Schedule but when I paste the rows it does have any conditional formattting maybe this code needs to be changed. Sub copyCount() Const FILEPATH = "C:\Users\Arcon Welding-PC\Documents\" Const FILENAME = "CostSchedule.xlsx"...

I thought a macro would be better suited as I am copying and pasting from another worksheet on a daily basis so each time I open up the worksheet it maybe delete all fill conditions and starts again with new conditions from the macro, I don't know of any other way. Also the rows are moved...

I have a worksheet with Columns A:M it needs to find if a multiple condition is met and colour B:M, First search is if Column B has the words "Dial before you Dig" and if Column J has a date (any date) I then need it to automatically change B:M and colour lets say red. I then need it to look in...

I have uploaded a jpg that shows what I get.

I will need to copy formatting and also formulas/values

I hope these files are self explanatory.

1. C:\Users\Sue Loh\Documents 2. Workbook to be saved but the Works Schedule worksheet could be deleted after it is copied to Cost Schedule I only using the Work Schedule worksheet to compile all my data be it is transferred to Cost Schedule. 3. All the data from Work Schedule Worksheet to be...

This is why I'm asking for help I dont know how to fix it, I have looked on this site and others and am trying to make it to suit my macro I copied it from another post.

Ok I will try again to explain. The code I was trying to use to transfer data is this one which I had put in Worksheet Estimate1 this is a seperate macro to run after all the text had been copied and filtered. I prefer if this could be added to the original CODE as the last thing that it does...

I need the copied cells that appear in Worksheet (Works) to copy to Cost Schedule Workbook. So open Cost Schedule Workbook when macro runs and copy cells to next blank row

I'm new to this so here goes I have a macro that finds text in a Workbook (named Tester) with a Worksheet (named Estimate1) and copies to another worksheet (named Works) which I would rather save to another workbook (Cost Schedule.xlsm) but can only get it to send to a worksheet as when I try...

Can someone help me I have a table that has dates starting from A6 which is a whole month say 01/2/2013 to 28/02/2013 like a gantt template. I need help if the word "Ordered" is in B5 I need X (crosses) in the date cells starting from B6 to end of month until someone changes B5 to Delivered...

http://www.2shared.com/file/GjwXW6AR/Case_Excel.html

I have a worksheet named ActiveCase starting A2. I need it to look at the batch date E2 then add a appointment with the start = E2 subject = A2 location = B2 duration = all day I also need it to stop if cells are blank. Thanks in advance...

Sorry SirJB7 Have you read my original post regarding excel macro for outlook reminders

Can someone help with this I only need an appointment in outlook not an email reminder