$$Excel-Macros$$ Re: Copying existing Address from column "B" to column "A" Using IF statement ( I think).

hi Mike , check this code. :) You have asked this type of question earlier but no issues. Run this code. Sub Test() With Application .ScreenUpdating = False .DisplayAlerts = False End With Dim lr As Long lr = ActiveSheet.Cells(Rows.Count, 2).End(xlUp).Row Set Rng = Range("b1:b" & lr) Debug.Pr

$$Excel-Macros$$ Copying existing Address from column "B" to column "A" Using IF statement ( I think).

I would like to copy this for each location and paste in front inventory numbers in Column "A"(some begin with letters) and also in front of the Establishment Totals: VC Count. Then I would like to Remove the Word "Establishment" in from of the Totals: VC Count. Then I would like to delete the

Re: $$Excel-Macros$$ Macro to Copy sheets and filter from on Workbook to multiple Workbook

Oops.. you SAID your file was Macro.xls, but you attached .xlsx which means you have Excel 2010 or greater.Sorry for the misstatement. still... what do you know about macros?  Paul- “Do all the good you can, By all the means you can, In all the ways you can

Re: $$Excel-Macros$$ Macro to Copy sheets and filter from on Workbook to multiple Workbook

Do you have any experience with macros? What version of Excel do you use? (I noticed your sample file is in Excel97 format, is this a requirement?)   Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can