Windows 10 - v 22H2 64-Bit
MS Excel & Word 2019
Hi Folks
I have been sent an Excel file, containing name, address, postcode of a number of people.
I want to print address labels from this data. However, there is one column, named 'Raffle', which has either a 'Y', 'N' entered, or left blank (to be considered as 'N', for this purpose)
My issue is how do I select only the data with 'Y' in 'Raffle' to print address labels, please? Is this complicated, or even possible, please? I will then need to print a separate 'pile' of address labels for those with the 'N' or Blank in the Raffle column, ie all that doesn't have 'Y'.
I'm able to do this, easily, from Access Db but have never done this from Excel. I'm wondering if it's going to be easier for me to just do this from Access, changing the query criteria to 'Y' or 'Not Y'. I will have to do this about 3 times a year so, if it's easier, and quicker, to do this in Excel, I'd like to learn. If easier procedure in Access, then I can Import the Excel worksheet, of course, and run the Query, which I can alter as required.
I'm hoping someone can advise me, please? Thanks very much for all your time, trouble, knowlege & experience![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
MS Excel & Word 2019
Hi Folks
I have been sent an Excel file, containing name, address, postcode of a number of people.
I want to print address labels from this data. However, there is one column, named 'Raffle', which has either a 'Y', 'N' entered, or left blank (to be considered as 'N', for this purpose)
My issue is how do I select only the data with 'Y' in 'Raffle' to print address labels, please? Is this complicated, or even possible, please? I will then need to print a separate 'pile' of address labels for those with the 'N' or Blank in the Raffle column, ie all that doesn't have 'Y'.
I'm able to do this, easily, from Access Db but have never done this from Excel. I'm wondering if it's going to be easier for me to just do this from Access, changing the query criteria to 'Y' or 'Not Y'. I will have to do this about 3 times a year so, if it's easier, and quicker, to do this in Excel, I'd like to learn. If easier procedure in Access, then I can Import the Excel worksheet, of course, and run the Query, which I can alter as required.
I'm hoping someone can advise me, please? Thanks very much for all your time, trouble, knowlege & experience