Automatically Transfer rows from 1 sheet to another using a Comm
Closed
Amanda08
Posts
1
Registration date
Monday March 6, 2017
Status
Member
Last seen
March 6, 2017
-
Mar 6, 2017 at 05:48 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Mar 7, 2017 at 01:00 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Mar 7, 2017 at 01:00 AM
Related:
- Automatically Transfer rows from 1 sheet to another using a Comm
- Fnaf 1 download pc - Download - Horror
- Tentacle locker 1 - Download - Adult games
- Free fire transfer - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Fnia 1 - Download - Adult games
1 response
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Mar 7, 2017 at 01:00 AM
Mar 7, 2017 at 01:00 AM
Hello Amanda,
There are a number of ways of doing what you would like but just so that we are all on the same page, could you please upload a sample of your work book to a free file sharing site such as Sendspace, ge.tt or DropBox and then post the link to your file back here. Please use dummy data.
In the meantime, following is the link to a sample file I supplied to another Poster some time ago.
https://www.dropbox.com/s/t5bg1ry6v25ksv5/Chiswickbridge%28Transfer%20from%20sht1%20to%20sht2%2C%20autofilter%29%20-%20Copy.xlsm?dl=0
His query was similar to yours. You'll see in the sample that any row of data that has the criteria "Yes" in Column F will be transferred to Sheet 2 once the "RUN" button is clicked on. The "used" data in Sheet 1 is then deleted. I assume that you would want to use a criterion such as "Completed" perhaps?
Let us know your thoughts.
Cheerio,
vcoolio.
There are a number of ways of doing what you would like but just so that we are all on the same page, could you please upload a sample of your work book to a free file sharing site such as Sendspace, ge.tt or DropBox and then post the link to your file back here. Please use dummy data.
In the meantime, following is the link to a sample file I supplied to another Poster some time ago.
https://www.dropbox.com/s/t5bg1ry6v25ksv5/Chiswickbridge%28Transfer%20from%20sht1%20to%20sht2%2C%20autofilter%29%20-%20Copy.xlsm?dl=0
His query was similar to yours. You'll see in the sample that any row of data that has the criteria "Yes" in Column F will be transferred to Sheet 2 once the "RUN" button is clicked on. The "used" data in Sheet 1 is then deleted. I assume that you would want to use a criterion such as "Completed" perhaps?
Let us know your thoughts.
Cheerio,
vcoolio.
