Dynamically Populate data to one sheet from two other sheets, using VBA or Power Query?

apie5

New Member
Joined
Jun 27, 2018
Messages
6
[FONT=&quot]I am pretty novice at Excel, but I would really love to see if this group can help me solve this issue:[/FONT]
[FONT=&quot]My Workbook has three sheets: "Wire Sheet", "Paste Data" sheet and "Wire instructions"[/FONT]
[FONT=&quot]I need the "Wire sheet to dynamically populate with the data from the other two sheets.[/FONT]
[FONT=&quot]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=&quot]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=&quot]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=&quot]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=&quot]Thanks in advance.[/FONT]
[FONT=&quot]https://my.pcloud.com/publink/show?code=XZNzcB7ZpIigcTAabUz2vpPaXQ4nSVUfdc2X[/FONT]
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Forum statistics

Threads
1,223,909
Messages
6,175,315
Members
452,634
Latest member
cpostell

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top