VBA Code: Copying rows from multiple sheets
Closed
NcTukek
Posts
2
Registration date
Wednesday October 10, 2012
Status
Member
Last seen
October 11, 2012
-
Oct 10, 2012 at 01:11 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 11, 2012 at 11:16 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 11, 2012 at 11:16 AM
Related:
- VBA Code: Copying rows from multiple sheets
- Battery reset code - Guide
- Samsung volume increase code - Guide
- Cs 1.6 code - Guide
- Vba case like - Guide
- How to get whatsapp verification code online - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Oct 10, 2012 at 07:33 PM
Oct 10, 2012 at 07:33 PM
it seems to me you want to loop thru each sheet
yet in code you have
but then I = april and k = may
so while u are looking at rows of sheet i, u still are refering to sheet may and yet you seem to say that i want to loop thru each sheet.
yet in code you have
If i.Range("I" & j) = "Yes" Then d = d + 1 e.Rows(d).Value = i.Rows(j).Value If k.Range("I" & j) = "Yes" Then a = a + 1 e.Rows(a).Value = k.Rows(j).Value End If End If
but then I = april and k = may
so while u are looking at rows of sheet i, u still are refering to sheet may and yet you seem to say that i want to loop thru each sheet.
Oct 11, 2012 at 06:49 AM
Oct 11, 2012 at 11:16 AM
Loop thru each sheet
Loop thru each row
if value in J column is "YES", copy the row to summary sheet.
Are you sure you want to copy the row, as I dont know what if row 1 in two sheets has yes, where the data goes. It seems to me that there is only certain column you want to copy from each sheet to summary if the value of cell in sheet being looked at is yes.