Forum

Copy Row Range to N...
 
Notifications
Clear all

Copy Row Range to Next Row if Two Criteria met

7 Posts
2 Users
0 Reactions
82 Views
(@webbers)
Posts: 148
Reputable Member
Topic starter
 

I am back (again), and thanks in advance!  I am creating a workbook (sample attached).  I need to have the row copied/pasted (as values) into the row below if TWO criteria are met.  I have completed data entry for this first record.  And since there is a YES in column L and a number greater than 0, that should trigger a change even to copy the data in columns B-O to the next row.  Obviously this process must function anywhere on the sheet based on row 3 as the beginning of the data.  And just in case, let me know where to change the data beginning at row 2, as the stakeholder may prefer that, despite they said they wanted this!  LOL

Column L (Multiple Requests) - Yes

Column Q (#) - greater than 0

Note:  The Blue cells in Columns A & Q contain formulas

 
Posted : 02/06/2022 11:52 am
(@catalinb)
Posts: 1937
Member Admin
 

Hi Sherry,

The layout is not the most inspired one, it will cause problems in finding the last row because of the formulas and colors.

Why not using defined tables, can you use them?

 
Posted : 04/06/2022 6:53 am
(@webbers)
Posts: 148
Reputable Member
Topic starter
 

@Catalin Bombea,

 

By "defined Tables, do you mean this?  And then how would I achieve my goal?

 
Posted : 07/06/2022 3:37 pm
(@catalinb)
Posts: 1937
Member Admin
 

Here is a resource that explains what are defined tables:
https://www.myonlinetraininghub.com/excel-tables

They are special objects that can be easily manipulated from visual basic, the code will refer to the table object directly, not to the sheet ranges, so it can be placed anywhere in sheet, gives you more flexibility.

 
Posted : 07/06/2022 11:54 pm
(@webbers)
Posts: 148
Reputable Member
Topic starter
 

@Catalin Bombea,

 

I was confused by the term "defined Tables".  I use tables on a regular basis (especially since I love Power Query), just never referred to them as "defined tables".  The format was given to me by the stakeholders, and is simply a working draft.  Before I put any effefort into a redesign, I wanted to know if their request was possible.

 
Posted : 10/06/2022 10:08 am
(@catalinb)
Posts: 1937
Member Admin
 

Yes, it is possible

 
Posted : 10/06/2022 2:53 pm
(@webbers)
Posts: 148
Reputable Member
Topic starter
 

@Catalin Bombea,

Thanks!!!

 
Posted : 11/06/2022 11:30 am
Share: