<div>
When should the message box appear?<br><br>You say "U21-U30 [10 cells] copied and pasted into sheet called "CASH SHEET" in D18-D28 [11 cells]". Is that correct?<br><br>In both cases after answering Yes or No you have data going to the CASH SHEET. Is that correct?
</div>


<div>
Here is a workbook you can try. Click cell "B2".<br><a href="https://filedb.experts-exchange.com/incoming/2021/07_w29/1566776/29220511.xlsm" rel="ugc">29220511.xlsm</a>
</div>


29220511.xlsm

<div>
Yes this is what I need. Is it in macro format as need the button else where and also add data to sheet.&nbsp;
</div>


<div>
I'm not sure what you mean when you say "also add data to sheet.", but yes, it's a macro and here is a version with a button (near column V).<br><br><a href="https://filedb.experts-exchange.com/incoming/2021/07_w29/1566778/29220511a.xlsm" rel="ugc">29220511a.xlsm</a>
</div>


29220511a.xlsm

<div>
Sorry what I meant was I have to create a sheet with more data in. Can I copy and paste into my workbook the macro button&nbsp;
</div>


accountant

david remichi

<div>
I’m glad I was able to help. And that <i>you</i> for the testimonial.<br />
<br />
If you expand the “Full Biography&quot; section of <a href="https://www.experts-exchange.com/M_258447.html" rel="ugc">my profile</a> you’ll find links to some articles I’ve written that may interest you.<br />
<br />
Marty - Microsoft MVP 2009 to 2017<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Experts Exchange Most Valuable Expert (MVE) 2015, 2017<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Experts Exchange Distinguished Expert in Excel 2018<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Experts Exchange Top Expert Visual Basic Classic 2012 to 2020<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Experts Exchange Top Expert VBA 2018 to 2020
</div>


<div>
<div class="content wysiwyg-content fr-view">
I have a workbook and in the sheet called "shift sheet" I have data in cells U21- U31<br><br>What im trying to do is get a message box come up askingare you sending your coins in your 700 cash bag? &nbsp;If answer id YES than I need data from cells U21-U30 copied and pasted into sheet called "CASH SHEET" in D18-D28 <br>If answer is NO then I need data from shift sheet U21-24 copied and pasted in D18-21 in sheet called cash sheet. <br><br>Any Ideas?
</div>
</div>



I have a workbook and in the sheet called "shift sheet" I have data in cells U21- U31
What im trying to do is get a message box come up askingare you sending your coins in your 700 cash bag?  If answer id YES than I need data from cells U21-U30 copied and pasted into sheet called "CASH SHEET" in D18-D28
If answer is NO then I need data from shift sheet U21-24 copied and pasted in D18-21 in sheet called cash sheet.
Any Ideas?

How do get cells to print depending on what data in them.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.