Hello All, have a macro that one of the admins here helped me with, but now I'd like to make an adjustment:
I would like to now also pick up G74 (or H74 or I74, depending on which line item it is) and paste it into the master data sheet...
Please Login or Register to view this content.
I tried just adjusting the array, but that doesn't work for reasons I'm sure are obvious to the experienced people but not to me... Thanks for any help you can provide.
If you could attach a sample workbook with data, that would be helpful.
Acts 4:12
Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.
filesformacro.zip
I included the scorecard which is the source; the other is the destination
Right now it functions great, I just need to add that extra field that I forgot to include initially;
Also, sometimes when initially "finalizing" the data comes over weird, if I delete it and click the button again it works...
In the above portion of the code, the 2nd dimension of your array is 40, and there are 40 cells in SrcWks.Range. If you change G73 to G73:G74, you'll need to change your array height to 41 to make room for it.Please Login or Register to view this content.
Ah perfect! Thank you so much!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks