central

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...

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...

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...

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...

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...

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...

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...

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...

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"...

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...

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>...

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...

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...

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...

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...