dteToday = InputBox("Enter todays date:") Set objPreviousSheet = ActiveSheet objPreviousSheet.Copy , ActiveWorkbook.Sheets(ActiveWorkbook.Sheets.Count) Set objNewSheet = ActiveWorkbook.Sheets(ActiveWorkbook.Sheets.Count) objNewSheet.Name = dteToday objPreviousSheet.Range("F11:F16,H11:H16,J11:J16,L11:L16,N11:N16,P11:P16,R11:R16").Copy objNewSheet.Range("AA11:AG16") objPreviousSheet.Range ("E11:E16,G11:G16,I11:I16,K11:K16,M11:M16,O11:O16,Q11:Q16").ClarContent
|How to Calculate Stainless Steel U-Bolt Dimension||15||67|
|How to change the following 2nd comma in each line to a tilde (~) in Excel 2016?||6||44|
|increment numbers by 10||11||30|
|remove upper case characters in excel||4||15|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
14 Experts available now in Live!