Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-18-2015, 09:38 PM
Brian Reilly Brian Reilly is offline copy second row from multiple sheets Windows 8 copy second row from multiple sheets Office 2013
Novice
copy second row from multiple sheets
 
Join Date: Jan 2014
Posts: 3
Brian Reilly is on a distinguished road
Default copy second row from multiple sheets

Option Explicit


Sub Copy2ndRow()
Dim ws As Worksheet, nr As Long
For Each ws In ThisWorkbook.Worksheets
If ws.Name <> "MTD" Then
nr = Sheets("MTD").Range("A" & Rows.Count).End(xlUp).Offset(1).Row
ws.Rows(2).Copy Sheets("MTD").Rows(nr)
End If
Next ws
End Sub

Hello -
My goal is to copy A2:P2 from 31 daily sheets to MTD sheet and sum all columns.... the code above does everything I need except formatting - I would like to paste values only but keep getting an error when I try to add the code below

.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False

also would like to have this run whenever the workbook is closed

Thank you in advance

Brian
Reply With Quote
  #2  
Old 03-30-2015, 01:21 PM
charlesdh charlesdh is offline copy second row from multiple sheets Windows 7 32bit copy second row from multiple sheets Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default

HI,

Did you ever receive help on this?
Also you mentioned an "Error" what was the "Error"?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy second row from multiple sheets Fetching more than one result with VLookup on multiple sheets lilvillaf Excel 2 06-12-2014 05:39 PM
copy second row from multiple sheets SUMIF/SUMPRODUCT across multiple sheets/Criterias lukeyb_11 Excel 1 02-14-2014 10:30 AM
If two geographical data match in two sheets, copy unique id/code found in one sheet alliage Excel 1 09-01-2011 05:23 AM
copy second row from multiple sheets form a database from multiple sheets udea Excel 1 04-25-2011 02:34 AM
Print Multiple Sheets Double-Sided flambe99 Excel 1 03-12-2010 01:15 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:05 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft