How to add rows that meet specific conditions
Solved/Closed
SalinaSJames
Posts
1
Registration date
Sunday January 16, 2022
Status
Member
Last seen
January 27, 2022
-
Jan 27, 2022 at 11:31 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Jan 28, 2022 at 04:15 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Jan 28, 2022 at 04:15 AM
Related:
- How to add rows that meet specific conditions
- Google meet download for pc - Download - Video calls
- 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
- How to add @ in laptop - Guide
- How to add songs to sound picker - Guide
- How to add photo in word resume - Guide
1 response
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Jan 28, 2022 at 04:15 AM
Jan 28, 2022 at 04:15 AM
Hello Salina,
It would be best if you uploaded a sample workbook to a file sharing site such as WeTransfer or Drop Box then post the link to your file back here.
This will enable us to see exactly what you are trying to do otherwise we can only guess. It will allow us to test as well on a 'live' workbook.
Make sure that the sample workbook is an exact replica of your actual workbook and if your data is sensitive then please use dummy data.
As an insight as to how you may be able to do it, I've attached a sample file at the following link:-
https://wetransfer.com/downloads/b59d1477187c676fed32edca464dfd4b20220128090442/025dd8
The VBA code, which is in the Summary sheet module, is as follows:-
To access the code, right click on the Summary sheet tab and select "View Code" in the menu that appears. You'll see the code in the big white code field.
In the sample file, you'll see a Raw Data sheet and a Summary sheet. In cell A1 of the Summary sheet, you'll find a data validation drop down list with some job numbers from the Raw Data sheet listed. Select any job number and the relevant data from the Raw Data sheet will be instantly displayed in the Summary sheet.
I hope that this at least heads you in the right direction.
Cheerio,
vcoolio.
It would be best if you uploaded a sample workbook to a file sharing site such as WeTransfer or Drop Box then post the link to your file back here.
This will enable us to see exactly what you are trying to do otherwise we can only guess. It will allow us to test as well on a 'live' workbook.
Make sure that the sample workbook is an exact replica of your actual workbook and if your data is sensitive then please use dummy data.
As an insight as to how you may be able to do it, I've attached a sample file at the following link:-
https://wetransfer.com/downloads/b59d1477187c676fed32edca464dfd4b20220128090442/025dd8
The VBA code, which is in the Summary sheet module, is as follows:-
Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("A1")) Is Nothing Then Exit Sub If Target.Count > 1 Then Exit Sub If Target.Value = vbNullString Then Exit Sub Application.ScreenUpdating = False Application.EnableEvents = False With Sheets("Raw Data").[A1].CurrentRegion .AutoFilter 1, Target .Offset(1).EntireRow.Copy Me.Range("A" & Rows.Count).End(3)(2) .AutoFilter End With Application.EnableEvents = True Application.ScreenUpdating = True End Sub
To access the code, right click on the Summary sheet tab and select "View Code" in the menu that appears. You'll see the code in the big white code field.
In the sample file, you'll see a Raw Data sheet and a Summary sheet. In cell A1 of the Summary sheet, you'll find a data validation drop down list with some job numbers from the Raw Data sheet listed. Select any job number and the relevant data from the Raw Data sheet will be instantly displayed in the Summary sheet.
I hope that this at least heads you in the right direction.
Cheerio,
vcoolio.