[FONT="]I am pretty novice at Excel, but I would really love to see if this group can help me solve this issue:[/FONT]
[FONT="]My Workbook has three sheets: "Wire Sheet", "Paste Data" sheet and "Wire instructions"[/FONT]
[FONT="]I need the "Wire sheet to dynamically populate with the data from the other two sheets.[/FONT]
[FONT="]Currently: if you place a specific date in cell K2 on the wire sheet, the boxes (cells A18:O67) populate with the data from the other two sheets based on that specific date. Some data that is being populated in the boxes on the wire sheet, should not be.. here is an example:[/FONT]
[FONT="]For example: If you place the date 7/13/2018 in K2 cell, the cell B57 is populated with letters SCR, which shouldn't be the case, as if you go to the "paste data" sheet, this is a sell.[/FONT]
[FONT="]Then if you place the date 7/16/2018 in K2 Cell -- the cell B18 is doing the same thing, its populated with WQ when it shouldn't be, as it is a sell, on the "paste Data" sheet.[/FONT]
[FONT="]Is there a way to incorporate this condition, if "sell" on paste data" tab, move onto next row... in my current formulas? Or just a cleaner way to do this.. I imagine this shouldn't be to hard, but once again I am pretty novice at my excel abilities.[/FONT]
[FONT="]Thanks in advance.[/FONT]
[FONT="]https://my.pcloud.com/publink/show?code=XZNzcB7ZpIigcTAabUz2vpPaXQ4nSVUfdc2X[/FONT]
[FONT="]My Workbook has three sheets: "Wire Sheet", "Paste Data" sheet and "Wire instructions"[/FONT]
[FONT="]I need the "Wire sheet to dynamically populate with the data from the other two sheets.[/FONT]
[FONT="]Currently: if you place a specific date in cell K2 on the wire sheet, the boxes (cells A18:O67) populate with the data from the other two sheets based on that specific date. Some data that is being populated in the boxes on the wire sheet, should not be.. here is an example:[/FONT]
[FONT="]For example: If you place the date 7/13/2018 in K2 cell, the cell B57 is populated with letters SCR, which shouldn't be the case, as if you go to the "paste data" sheet, this is a sell.[/FONT]
[FONT="]Then if you place the date 7/16/2018 in K2 Cell -- the cell B18 is doing the same thing, its populated with WQ when it shouldn't be, as it is a sell, on the "paste Data" sheet.[/FONT]
[FONT="]Is there a way to incorporate this condition, if "sell" on paste data" tab, move onto next row... in my current formulas? Or just a cleaner way to do this.. I imagine this shouldn't be to hard, but once again I am pretty novice at my excel abilities.[/FONT]
[FONT="]Thanks in advance.[/FONT]
[FONT="]https://my.pcloud.com/publink/show?code=XZNzcB7ZpIigcTAabUz2vpPaXQ4nSVUfdc2X[/FONT]