Forum Discussion

pbromz's avatar
pbromz
Copper Contributor
Apr 01, 2023

Trying to search, find, copy and paste

Hi everyone, I'm analysing some qualitative data and I have 15 transcripts and about 250 codes. I need to move the data from the transcript tables into the master table, but with so many codes it's taking me ages. Does anyone have any solutions? I know I can use filters, but I can only do this individually which is what is taking me so long. 

 

Thanks

excel
Formulas and Functions
Macros and VBA
  • mathetes's avatar
    mathetes
    Silver Contributor
    Apr 01, 2023

    pbromz 

     

    Well, we certainly can't come up with a solution without knowing how your data are arrayed. You don't even hint at that.

     

    Unless the data are confidential--in which case a mockup could serve--would you be kind enough to post a copy of the workbook you have, along with a more complete explanation of the task? Post that copy on OneDrive or GoogleDrive, and paste a link here that grants edit access.

Resources