Log In
Register
Home
December 4, 2021
Offline
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
See Answer
November 8, 2013
Offline
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?
December 4, 2021
Offline
@Catalin Bombea,
By "defined Tables, do you mean this? And then how would I achieve my goal?
November 8, 2013
Offline
Here is a resource that explains what are defined tables:
https://www.myonlinetraininghu.....cel-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.
December 4, 2021
Offline
@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.
1 Guest(s)
