I am using this macro to transfer a row from one sheet to another based on the header value in that row:
On the last line, instead of transferring the entire value of Row 12, Sheet5, I would like to transfer only the cells with value to the same relative position on Sheet1. Some of the cells in Sheet1.Rows(row).Value may be populated, and I don't want them to be erased. Any help on this matter would be greatly appreciated.
Please Login or Register to view this content.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thank you! Works perfectly but runs for about 20 seconds before it finishes. It is searching about 260 columns, which doesn't seem like too many for 20 seconds. Any ideas on how to speed up the process?
EDIT: Figured it out with a little Googling. Thank you for your help!
Last edited by TechKnowledge; 06-29-2016 at 04:35 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks