Previous Topic Next Topic

Excel - Macro to search & paste to new sheet

Closed
Theta Sigma - 5 Jul 2011 à 07:53
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 5 Jul 2011 à 09:48
Hello,

I am working on a log for items that have gone in a machine at work. Some of the items come out damaged and therefore are void. These are also entered in the log but tagged with 'VOID' in column O. I can not seem to find a Macro that will find all voided items and list them into another Spreadsheet! PLEASE HELP!!!!!!
The Macro needs to copy the row of any Voids but only from column K-P (IE: K29-P29 etc...)

THANK YOU!!



1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
5 Jul 2011 à 08:12
You can filter the data on "VOID" and copy the visible row to the other sheet. If you want a macro, you can use a macro recorder and record your action. That will give you a good template
Theta Sigma
5 Jul 2011 à 08:28
Thanks! However, I need to to do that in a Macro instead of having to copy all the data, moving it to a new sheet, pasting it, then un-sorting all the original data.
Theta Sigma
5 Jul 2011 à 08:46
Plus, I've tried that before and I just attempted again, I keep getting errors saying :Can not change part of a merged cell" so I unmerge any cells in the list and get literally hundreds of errors saying "No cells are found"
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
5 Jul 2011 à 09:48
You would need to post a sample book at some shared site with some sample data and paste the link to the file for one to see what is the issue.

Similar discussions

Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses
Can no longer paste text into insta
6hypnone -
Gordon -

7 responses
Ghost mail
WondrousCrocodile61 -
HelpiOS -

1 response