central

  1. S

    Sort by cities

    Hi all, Is it possible with Excel VBA to sort data according to the text in record, in this case city, above Whitsett Ave (N. Hollywood) Victory Blvd (N. Hollywood) Kenneth Rd (Burbank) Alameda Ave (Burbank) Kenneth Rd (Burbank) Central Ave (Glendale) Central Ave (Glendale) To get: Alameda...
  2. F

    how to use a cell to reference a file?

    Hi all I have a 2 workbooks set up s parent and chid - and a formula to pull values into the parent from the child: =VLOOKUP($A2,'https://tsbcloud.sharepoint.com/sites/ChangeTestingTeam/UAT Testing Collateral/1. Releases Collateral/Release 17/14. Preparation and Execution Tracker/[Outside of...
  3. A

    How save/use Subs from central storage

    Hi, I want to save my different subroutines which I use in some tools at a central place, so when I update them I have to update only the subs in this workbook. I put them in a workbook and add this workbook in the VBA ****pit under references. No I have access to the scripts in this central...
  4. Y

    If names found on column, move row to another sheet

    Hi all, Could you please help me with a small macro, that should do as follows? - i have an excel file with 3 sheets: "Central", "Intern", "Extern" - on sheet 'Central", column A, i have some names (Steve, John, Michael, etc) - i need a macro that can look on sheet "Central", Column A, and if...
  5. T

    LOOK UP and Count or SUM

    Good Morning World, I am looking for a formula which will look up a range of different value - i.e. Business / Central etc and return the sum of another value in a range of cells relating to that column value.. For Example Look Up value "Business" in Column C - Range C1:C400 and then return...
  6. D

    Spreadsheet in two places

    Hi, Hopefully this hasn't been asked before and answered a million times before. And that I explain what I'm looking for well enough. So, i have spreadsheet that I want to share and normally we put this in a shared drive that is accessible from two locations. However when at the third location...
  7. S

    Searching for players in a particular position

    Hi, I have a list of players & their positions: <colgroup><col><col></colgroup><tbody> Alcock, Craig Full Back (Right) Alcock, Craig Central Defender Alcock, Craig Defensive Centre Back Alcock, Craig Full Back (Left) Anderson, Tom Central Defender Anderson, Tom Defensive Centre Back...
  8. M

    Slicers wont trigger all pivots when data spreadsheets are hidden

    I hope someone can help with this issue. Using excel 2013 and I have a macro that triggers / synchronises several slicers that select the data in many pivots (approx. 4 per slicer). The macro then goes on and renders and publishes the report in PDF format. I have hidden all sheets except the...
  9. M

    Slicers not triggering pivots when sheets are hidden

    I hope someone can help with this issue. Using excel 2013 and I have a macro that triggers / synchronises several slicers that select the data in many pivots. The macro then goes on and renders and publishes the report in PDF format. I have hidden all sheets except the "option selection page"...
  10. B

    Count Occurrence of a Specific Character in a cell

    Hi Thank you in Advance, I have a column of Address, and i would like to know the Number of times, a comma occurs in the cell. <tbody> Zillmere, QLD, 4304 Westfield Belconnen, Benjamin Way, Belconnen, ACT, 2617 Wanneroo Central Shopping Centre, Rocca Way, Wanneroo, WA, 6065 Unit 6...
  11. I

    Modify formula in Column E to exclude recurring customer names in column A.

    Hi Everone, I have following formula in E2 =COUNTIFS($A$2:$A2,A2,$B$2:$B2,B2,$D$2:$D2,D2,$C$2:$C2,C2) and its giving me following output. I need to count unique customers in given criteria. Right Most column is my desired output. <colgroup><col><col><col><col><col><col></colgroup><tbody>...
  12. K

    How to practically centralise/update from multiple workbooks and keeping historic info

    Guys, Just need some opinion on how to do something practically. There are multiple workbooks each including weekly sales plans, and every week a copy of these are created and plans are updated for the future weeks. What I like to do is 1. how should I centralize these inputs in a way that...
  13. B

    Rank with Criteria and 2 tie breaks

    HI I'm looking for some help with a rank issue I'm having. I need a formula that will rank based on a criteria (Area) and uses 2 tie breaks. So for example if the are 2 scores of that match in Central England then %1 would determine the highest rank, if the score and %1 match the %2 would...
  14. W

    Change all file paths in cells in sheet based on a single cell

    Hi, I have a spreadsheet (call it 'Central reporting') that I want to act as a kind of central store for the first sheet (call it 'progress report') of several of workbooks which are spread around various file locations. All the workbooks have an identical layout for the first sheet; however...
  15. A

    Excel file referencing a large central macro file?

    Hi there, I am working on 2 major excel dashboards that has many macros. I am thinking of consolidating all of the tools and macros into one VBA file, so that there will be one file of "common macros" which I can place onto sharepoint and have all of the spreadsheets I develop in the future...

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