Trying to automate from pulled data

Bubba49

New Member
Joined
Apr 1, 2020
Messages
9
Office Version
  1. 365
Platform
  1. Windows
Hi, I'm trying to automate my sheet as much as i can but I'm new with excel. I am trying to get a stat with xlookup from a different sheet when the pitchers name gets pulled into the sheet, it works if i just paste the name but wont if its pulled in, also i tired to do dependent dropdown for column D where it brings up the pitchers just for the team thats in column C but couldn't get it to work so i thought would be easier by pulling in data. Any help would be great or if you can direct me to a website that can help me learn would be great also. I posted pics dont know how to show the sheet, the starters have 2 names because data pulled from different sites .Thanks in advance 1pic.jpg2pic.jpg3pic.jpg
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Watch MrExcel Video

Forum statistics

Threads
1,129,577
Messages
5,637,198
Members
416,960
Latest member
Carbon1198

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
Top