changing cells

Hi I have been trying to work through this macro based on other posts I have found but I am very new to this and couldn't make it work. It think this should be very easy but I just can not figure it out. I have to generate several hundred invoices by hand, and I have the fields that I need...

So I just had something pretty strange happen to me today. I was demonstrating adding a conditional formatting rule to the range D5:E10 and G5:H10 : Formula =D5>1.03 then format fill blue I clicked on OK and Excel converted D5 into A5. Of course when I went back to see why the rule wasn't...

Hi, I have a workbook with several sheets. They all contain similar data in a identical column sequence. There are however different amounts of rows in each column in each worksheet. I have been able to write a macro summarizing all the sheet names in one "summary" sheet, listing them...

Need your help. Currently this Macro is looking in A2 to Filter and create Tabs. How can i change this to look in Column U and do the same thing. Sub Tab_() Application.ScreenUpdating = False Dim ws1 As Worksheet Set ws1 = ActiveSheet Dim bottomA As Long bottomA =...

Hi All, First posting so take it easy on me :) I would like to change 100 cells within my spreadsheet with a formula. So the below will change from anthony@test.com to info@test.com So all these; test@test.com me@test.com blah@future.com excel@excel.com I want to take the characters before...