Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
87
Views
Topic starter
I want to ropy rows from PP Part 1 to SharePoint based on the following
On PP Part 1 if cell AJ1 < = 2 copy row 1 to SharePoint row 1
On PP Part 1 if cell AJ2 , = 2 copy row 2 to SharePoint row 2 ….if it is not then it would copy row 3 here IF AJ3 <= 2.
In other words I want to copy all rows where AJ# < = 2 but do not leave any blank rows on SharePoint.
PP Part 1 is 123 rows and depending upon how many rows copy to SharePoint will determine the row count.
Posted : 07/12/2018 4:06 pm
Hi Svea,
Is this the same question as this one: https://www.myonlinetraininghub.com/excel-forum/excel/copy-a-row-of-cells-from-tab1-to-tab2-if-a-condition-is-met
Mynda
Posted : 07/12/2018 10:40 pm
