sheetdata

  1. N

    Copy range to another sheet when match conditions

    Hi all Hi have sheet(data) and sheet(source) like belove Sheet(data): <tbody> A B C 1 A123 999 888 2 A124 456 789 3 A125 123 456 4 A126 741 852 5 A127 987 987 </tbody> And Sheet(source): <tbody> A B C D E 1 ... ... A121 123 456 2 ... ... A122 456 789 3 ... ... A123 789 789...
  2. J

    VBA: if any cell in range matches in another range?

    Hi, I have some data we input into range C2:C20 and on button press the rows are pasted to the bottom of Sheet("Data") What I'm wanting is if any of the values in C2:C20 are already in column C in the data sheet to display an error message Yes/No Appreciate any help
  3. B

    GOOGLE SHEETS: Help with my Query formula?

    =IF(A2="Work Instructions",QUERY(Data!A2:N,<wbr>"select D where E='"&C2&"' and F='"&E2&"'"),IF(A2="Standard Work",QUERY(Data!A2:N,"select D where H='"&C2&"' and I='"&E2&"')"))) I'm trying to build a query that can be manipulated a little bit. What I want is for it to query (sheet'Data') columns...

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