'Populate column B, copies value in B2 of sheet declared down B 'For as many rows that are in columnG, then copy/paste special values Range("B2").Select With Sheets("Kentwood Order Entry Sheet") 'the sheet tab name in SALESORDERDOWNLOAD.XML .Range("B3:B" & .Cells(.Rows.Count, "G").End(xlUp).Row).Formula = "=(B2)" End With Range(Selection, Selection.End(xlDown)).Select Application.CutCopyMode = False Selection.Copy Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _ xlNone, SkipBlanks:=False, Transpose:=False
|How to have microsoft excel chart with slicer for this type of data||4||42|
|Looking for macro to do version saving of workbooks in Excel 2016.||6||36|
|macro for same location path||2||19|
|Office 2016 Excel Issue||4||25|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!