When data changes in sheet1 delete row in s2
Closed
FromNC2PR
Posts
4
Registration date
Tuesday December 20, 2011
Status
Member
Last seen
December 22, 2011
-
Dec 21, 2011 at 12:18 PM
FromNC2PR Posts 4 Registration date Tuesday December 20, 2011 Status Member Last seen December 22, 2011 - Dec 22, 2011 at 07:30 AM
FromNC2PR Posts 4 Registration date Tuesday December 20, 2011 Status Member Last seen December 22, 2011 - Dec 22, 2011 at 07:30 AM
Related:
- When data changes in sheet1 delete row in s2
- How to delete a row in a table in word - Guide
- Saints row 2 cheats - Guide
- Delete my whatsapp account without app - Guide
- Tmobile data check - Guide
- How to delete history in facebook - Guide
1 response
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Dec 22, 2011 at 01:03 AM
Dec 22, 2011 at 01:03 AM
Use Macro Recorder it will help you to understand how to move on. or
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.
Note: your data need not be to be real data but a good representative of how data looks like
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.
Note: your data need not be to be real data but a good representative of how data looks like
Dec 22, 2011 at 07:30 AM
http://speedy.sh/9yPdW/Test-SX.xlsm
I have a macro to copy rows from worksheet 2011 SURGERIES to Worksheet Non Paid Surgeries, when range U2:U474 has "REVIEW". Now I want to create another Macro that will delete rows from Worksheet Non Paid Surgeries when worksheet 2011 SURGERIES has been updated with paid surgeries, can use range U2:U474 with no data in cells or if possible when i update 2011 SURGERIES it will automatically update Non Paid Surgeries either add row or delete row. Probably asking for too much.
I would greatly appreciate all the help i can get.
Thank You