labeled

  1. J

    E-Bay scrape of completed items sold for a specified search

    Hello, I'm having a heck of a time trying figure out how to extract the data I'm needing. I'm rather new to VBA and trying to read / watch many scraping videos and I'm not getting the output I'm looking for. Ultimately I would like to have a table pulled from a completed /sold search from...
  2. L

    Navigating to Worksheet

    Hello, I have my first sheet 'Switchboard' that has this formula in Cell E1: =WEEKNUM(TODAY(),2) This yields '28' for the 28th week of the year. My worksheets are labeled Week 1, Week 2, etc. Since this is the 28th week of the year is there a way to jump to that worksheet (Week 28) ...
  3. kelly mort

    Countifs not working how I want

    =Countifs(E3:E13, "M", I3:M13, "/") I know the problem is coming from I3:M13 Yet I don't know how to resolve it. I want to count all "/" from range "I3:M13" that are labeled "M" in column E.
  4. K

    VBA to print multiple sheets

    Hello, I have an excel file with hundreds of sheets, I need something that helps me simplify the print process of selecting each sheet that i need. All the sheets that I need to print are between sheet 10 and sheet 70, sheets are labeled e.i. sheet 10 reads USA, sheet 11 is Canada...sheet 70...
  5. J

    trying to make a checklist smarter

    I have 2 work sheets "Main" and "CheckList". The "Main" work sheet has selections in cells B14:B29 and in cells E14:E21 (by selections i mean i have made is so that when these cells are activated they auto fill with an X) I also have a button on the page labeled "Print" The "CheckList" page...
  6. D

    excel smartart labeled hierachy chart keep shapes inside leves

    Hello everyone, As I add levels using the text pane to my labeled hierarchy chart the shapes do not move or resize to remain in the labeled level. How do I keep them in the correct levels?
  7. J

    DLookup and calculate

    I have a packing table that I can have as many as 8 different materials used in packing a box. I have a table with the item listed and the charge associated with it. I have a column labeled as total material cost. How do I have the 8 different columns go look up the item and the cost...
  8. E

    Foruma to calc full and half

    Hi, Row A has 1-16. Row B1 is labeled Full/Half. Row C1 is labeled Done. Row D1 is labeled total. If in cell row b2 is typed full, it calculates 1 in total. If half is typed, it would calculate .5 to the total. If it could also only calculate if you type yes in cell c2-c16. Hope this makes...
  9. B

    Row Pattern & Summations

    All, I've tried to find someone post a similar question or find a similar use case to find the answer, but I'm not sure I have the right verbage to find my answer. I'm looking for some help with the data below. I have multiple locations going down which I've labeled "red" and "blue" in this...
  10. S

    type data in sheet 1 cells A125:E125, have iT all show up in sheet 2 A5:e5

    Please help, this is a income / expense sheet that I want to track all activity for 2018 on a 2nd sheet labeled 2018 summery
  11. J

    formula to sort and delete duplicates

    Hello, I am looking for a way to sort and delete duplicates. example below <tbody> number sorted and delete duplicates 1 1 2 2 3 3 1 4 2 4 4 4 2 </tbody> The column labeled number needs to be left the same. Thanks for any help!
  12. I

    Index/Match giving me fits again. Advice?

    retracted
  13. B

    Conditional format row designation to show mismatch with column designations

    Windows 10, Excel 2010; I have a table where the column headers match the row labels. i.e. columns beginning at B1, C1, D1 are labeled MPH001, MPH040, MPH051 etc. for 100 columns (with no pattern to the labels). The rows are labeled the same, i.e. rows A2, A3, A4 are labeled MPH001, MPH040...

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