Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.
'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
|modify formula same cell multiple times||15||29|
|how to transfer all external connections from one workbook another workbook?||6||22|
|Dropbox in Windows Server 2008||4||28|
|Left trim cells in column A Excel vba||2||28|