Got Stuck In Middle To Display Hierarchy Of Employee In Organization
Aug 5, 2014
I am supposed assign macro to track all employees hierarchy in an organisation.
In Sheet1 I have Employee ID's in D Column and Supervisor ID's in N Column.
And In Sheet2 I assigned macro...
What exactly I need is when I give number and click the button I need all the employee id's in his hierarchy
Concept:
The number which you give should search in N Column and Display D Column Values...and those D column values should search in N column and display D column values....so on.....
So far, it is showing 1 level hierarchy...but I need till end...
View 14 Replies
ADVERTISEMENT
Feb 10, 2014
I have a bar graph in excel 2010 and the vertical access is stuck in the middle of the graph. When I right click on the axis and select "format axis" I have an option to set where the horizontal axis crosses but never the vertical.
View 1 Replies
View Related
Aug 18, 2009
On sheet1 I have this:
employee ID Date hours item1 item2 item3 item4
So it's 8 columns and the row count can vary.
This list on sheet 1 has the persons employee id and various bits of info. There will be multiple rows with the same employee id. This data is not sorted in any particular order, but I'd rather leave this sheet untouched.
On another sheet, I would like the user to simply type in a number for the employee id (I don't want to use msg box, just a cell is fine, maybe a button form to click search to run the macro) and it lists all their hits, however many rows that may be. Again I can't sort the original list so the employee might have hits scattered throughout the main list.
So they would enter the employee id and below that they would get all the rows with all the above data where they get a hit. One concern I have is say the first search for employee 123456 turns up 18 results. Then they search for employee 123444 and it only returns 8 results. I don't want the last 10 rows of employee 123456 to be still present. Basically a search that searches another sheet and returns any hits, and it clears the list of previous search results so for each search you only see the results of that search and not old data.
View 9 Replies
View Related
Apr 3, 2014
How do you use the numbering convention for each line??
Private Sub btnShowAllRows_Click() Dim iRow As Integer
125 For iRow = 7 To 30
130 ActiveSheet.Rows(iRow).Hidden = False
135 Next
140 btnShowAllRows.Visible = False
145 btnShowVolChanges.Visible = True
End Sub
View 8 Replies
View Related
Mar 14, 2014
How to get the outlook contacts for the organization using excel macro vba.
View 14 Replies
View Related
Nov 20, 2012
I am aware of the Visio capabilities of importing data into the org chart wizard to create an organization chart. Is there a similar capability in Excel only? I know there are smart art org diagrams, but if I have a spreadsheet of several hundred people, is there a way to import it into a chart (again, similar to the Visio process).
View 3 Replies
View Related
Jul 9, 2014
I have a list of data that includes employee ID number in column A and a certain document that they have on file (onboarding docs such as I-9, W-4, copy of Social Security card, etc.) in column B. If one employee has 10 documents, they are listed with the same ID number 10 times in A1:A10 and the different document names are listed in B1:B10.
I want to clearly see which employee has which document by having the ID numbers going vertically in column A and then an X or check mark of some sort going across the rows.
The set up of what I would like filled in is in the sheet called "status" and the list of documents on file is in the sheet called "docs."check file.xlsx
I tried a combination of an IF and VLOOKUP with a MATCH function but I wasn't getting what I wanted.
View 2 Replies
View Related
Jan 19, 2014
I am using the following array formula "=SUM($I$35:$I$1000*($G$35:$G$1000=$B$10))" which works fine but if there is nothing to sum it returns "0", but I would prefer a blank cell if there is nothing to sum.
View 3 Replies
View Related
Aug 26, 2013
I have a client that enters a lot of data into various spreadsheets, we recently upgraded her computer and along with it upgraded Office to 2013. Since that has happened she has experienced some issues with navigating cells in Excel. What will happen is she will be typing than tabbing or using the arrow keys and all of a sudden the active cell will get stuck on one of them. Arrow keys do not move the cursor to the next cell and the only way for her to fix it is to alt tab to another spreadsheet and then back to the one she was working on. Once that is done it is working fine.
There seems to be no rhyme or reason to when this happens to her. I have re-installed (used the big one that re-downloads from the web), it has no add-ins on either that are conflicting and I know it is not the keyboard since when I log in through TeamViewer while it is happening I am also unable to move with the arrow keys.
View 10 Replies
View Related
Apr 29, 2008
For some strange reason the workbook I have been using on a daily basis has suddenly decided to go into design mode and stay there. No matter how many times I click the design mode button in and out it always stays in and I can't use my buttons.....it just selects them?
View 9 Replies
View Related
Mar 23, 2014
I am currently stuck with a drop down list problem. I am trying to make a benchmarking solution for a group of 20 stores. All stores sell products uniformly and their sales are displayed in percentages of the cumulative total. Currently there is a benchmarking page where all stores sales per product is displayed, however I would like the ability to select specific stores data from a drop down list. I have pictures displaying the basic concept of what I want to achieve.
stores.PNG
On the left a list of products and the quantities sold in percentages per store for benchmarking purposes.
What I would like to achieve relates to the drop down list on sheet 2.
store 1.PNG
Here store 1 can see its sales in percentages, and has a drop down list to compare to different stores. If store 3 is selected I would like the data to be pulled into that column from the benchmarking sheet and the same goes for the other stores of course.
View 7 Replies
View Related
Aug 2, 2014
I'm getting a 'Run Time Error 91' saying that 'Object Variable or With Block not set'.
Error lies here:
Code:
Me.lstCategpry.Column = CustRec.GetRows(Fields:=Array("name"))
Userform Initialize:
Code:
Private Sub UserForm_Initialize()
[Code].....
View 4 Replies
View Related
Aug 2, 2009
I seem to be stuck in "Full Screen" mode. When I go to the View menu, both "Full Screen" and "Normal" are highlighted. I can't seem to get out of Full Screen.
I am using Excel 2003, XP SP3 installed. This just started this am. I did download and install Microsoft patches this am. ???
I am able to save and use Excel but without normal view my formating buttons etc. are not available.
View 9 Replies
View Related
Nov 2, 2011
I have following data on spreadsheet, which I need to import into other place but I would need to reorganise rows and columns first.
Product1-Sep2-Sep3-Sep4-Sep
SKU1112345
SKU22212131415
SKU3339876
SKU4444444
Basically I would like to have this data in 3 columns like this:
DateSKUOrders
1-SepSKU1112
1-SepSKU22212
1-SepSKU3339
1-SepSKU4444
2-SepSKU1113
2-SepSKU22213
2-SepSKU3338
2-SepSKU4444
3-SepSKU1114
3-SepSKU22214
3-SepSKU3337
3-SepSKU4444
4-SepSKU1115
4-SepSKU22215
4-SepSKU3336
4-SepSKU4444
I tried transpose etc. and not able to figure it out. Is this something that can only be accomplished with VBA?
View 2 Replies
View Related
May 26, 2007
I have the following code that gets stuck in the Loop and will not stop unless I press the Esc key:
Sub WIP()
Dim ws1 As Worksheet, ws2 As Worksheet
Dim lastrow As Long
Dim newRow As Long
Set ws1 = Sheets("PAYCALC")
Set ws2 = Sheets("WIP")
Application.ScreenUpdating = False
With ws2
.Range("A2:C" & .Range("A2:C2").End(xlDown).Row).Clear
End With
x = 10
lastrow = ws1.Range("C5").End(xlUp)
Do
newRow = ws2.Cells(65536, 1).End(xlUp).Offset(1, 0).Row
ws2.Cells(newRow, 1) = ws1.Cells(x, 2).Offset(-2, 0).Value
ws2.Cells(newRow, 2) = ws1.Cells(x, 2).Value
ws2.Cells(newRow, 3) = ws1.Cells(x, 2).Offset(3, 0).Value
x = x + 21
Loop Until x >= lastrow
There's a twist to this. I have the same identiclecode in a different module. The only difference is ws2 is different and there are 7 newRow's. Other then that the two are the same.
That one works just fine without getting stuck. It will go through 200+ sets of records and stop when it reaches the last one.
The one above will not stop even though I just put in three records on ws1 for testing.
View 9 Replies
View Related
Jul 2, 2013
I have created a hierarchy chart using smartart. Is there a way to hyperlink the texts in each box to other sheets in the workbook?
[URL]
View 3 Replies
View Related
Jan 28, 2009
I need to create a table of non numerical data that I can refer to in a formula, which will compare two pieces of data (both also inside this table), and based upon which is "higher up in the hierarchy" - the cell will display a certain result.
Basically it will be an IF function using non numerical data that has a numerical value / "rank" attached.
Specifically - I need to allocate values to this list in cells A1:A5...
EUR
GBP
AUD
NZD
USD
....where EUR is highest ranked and USD lowest.
Then in column B and C will be listed each of these values but in various combinations. In column D I will build simple IF functions to show the highest ranked in each combination. eg B1=EUR C1=GBP D1=IF(B1>C1,B1,C1)
View 3 Replies
View Related
Apr 28, 2009
My question is about creating a hierarchy of Data Types.
I need to code 3 Data Types:
1.) MealPlan
2.) Meal
3.) MealItem
MealPlan represents a daily meal plan. It should have a certain number of meals. An example of MealPlan would be "Healthy" and have a total of 3 meals. Meal represents a single meal. It should have a certain number of meal items. An example of Meal would be "Meal 1" and have a total of 3 meal items. MealItem represents a single meal item. It should have a certain number of protein calories, fat calories, carb calories. An example of MealItem would be "Broccoli" and have protein calories of .2, carb calories of .8, fat calories of .1.
By using Data Types, I hope to create meal plans, which are made up of meals, which are made of meal items. The following code creates a Data Type hierarchy for two Data Types. I've examined it closely but i'm still having a hard time recreating it for my needs as stated above.
View 3 Replies
View Related
Apr 30, 2009
I did all the search for multiple drop box or list box that can connect to other list boxes but no luck.
It's the same as when you surf with Internet Explorer, you can click "Views" in menu bar, list box appear and then choose "Encoding", another drop box appear, then when you choose "More", then another box appear.
Is it possible to have this sort of hierarchy list box in excel where drop box connect to another drop box?
View 6 Replies
View Related
Dec 4, 2011
I have case where i need to roll up data based on the hierarchy. I have hierarchy of 4 level as follow:
Level1 Level2 Level3 Level4 Country Region1 Dept1
Unit 1 Country Region1 Dept1
Unit 2 Country Region1 Dept1
Unit 3 Country Region1 Dept1
Unit 4 Country Region1 Dept1
[Code] ........
The data in all sheets is identical...so I created a macro to create template based on the rage. The problem is that the template is good for level 4 but not good for other level.
View 2 Replies
View Related
Jun 6, 2007
How do I use VBA to rearrange the data from the hierarchy format of Table 1 into the flat format of Table 2. See attached file >Data_Belinda_June-5-07.xls
Table 1: Each record has information arranged in a hierarchy format.
Level 1 information is indented by one space on one line; Level 2 information is indented by 2 spaces on the next line, etc.
Table 2: Data from Table 1 have been rearranged into 7 columns. Another column has been added to create a field for the Reference ID.
Reference ID: Two types: i) Created by prefixing with the letters BI , adding the first four letters from column 4 and the first four letters from column 5; ii) As in (i) with the addition of the entire word from column 6.
The report I have may have more than one hundred records and there may be more than ten people within each section.
View 9 Replies
View Related
Aug 1, 2013
=IF(M7="","",IF(K8=J8,K8&$J$3&I8,IF(K8=I8,K8&$J$3&H8,IF(K8=H8,K8&$J$3&G8,IF(K8=G8,K8&$J$3&F8,K8&$J$3&J8)))))
I have tried several options, ISERROR(FIND(.................also EXACT(........ and they all seem to get stuck, after the second expression.
Basically, I have a ROW of Cells, with numbers inside them, like so:-
F8.....G8....H8....I8...J8....K8
27.....33....10.....4....4.....4
And looking from right to left, I am asking this question:-
If K8=J8, then I will have K8 & I8 as my result.
If K8=I8, then I will have K8 & H8 as my result.
If K8=H8, then I will have K8 & G8 as my result.
If K8=G8, then I will have K8 & F8 as my final result, Else its K8&J8 as my FALSE.
(the $J$3 = a comma, for number separation, and further LEN string capture.)
Every time I have made this formula, with other types of Logic, it only ever finds the second tier depth as the result,
and I wonder why, since they are several nested IF statements in line!!
The incomplete Excel sheet is attached : S 1_2 tracker Forum.xlsx
The result of the above formula should be 4,10
But instead I get 4,4
View 2 Replies
View Related
May 25, 2014
I have been trying to think of a way to get a hierarchy chart automatically with given data through macros
In the attached excel sheet
Org. Charts (hierarchy) question.xlsm
Would it be possible to get the chart to do by itself if say I were to add items or remove items? Is there any way to do it for data automatically?
I extract the data from primavera as attached and I want to make the chart in excel automatically.
View 3 Replies
View Related
Dec 29, 2011
The below formula was provided by PGC, and works great:
=INDEX($E$15:$E$18,MAX(IF($A$2:$A$8=A15,MATCH($E$2:$E$8,$E$15:$E$18,0))))
In post:
Complex Array(?) Search
Now, I would like to add the ability to perform this same action/concept, but using two different criteria.
So I want to keep the hierarchical listing of importance, but lookup/match within using more than one criteria.
Example:
I have an order of superseding to apply to results of a search for Fruit.
Great
Good
Fair
Poor
(so Good supersedes, Great; Fair supersedes, Good; etc.)
Column A____Column B____Column E
Apple_______Red_________Fair
Apple_______Red_________Poor
Apple_______Green_______Great
Pear________Red_________Great
Pear________Yellow_______Great
Pear________Red_________Good
Pear________Red_________Fair
I want my verification to return all the worst Red fruit:
For Apple Red: Poor
For Pear Red: Fair
View 1 Replies
View Related
Sep 19, 2007
The accounts listed on this report change on a monthly basis. I am attempting to create a macro or write a formula that can but used each month to fill in this list automatically. On Sheet 1 is a short example of what the report looks like when exported into excel. The numbers on the left are the numerical hierarchy. The long set of numbers are the account numbers and the others are the categories that each are located under.
Sheet 2 is what I need the end result to look like. One of the problems I am running into is how to handle the fact that the hierarchy re-uses numbers. The hierarchy always runs vertical, therefore "5" always falls under the "4" that is directly above but when there is another "4" it should be ignored and continue on up the chart until it finds the first "3" and place that in the cell to the right then find the first "2" and so on.
View 2 Replies
View Related
Feb 7, 2008
I have an excel file (see sample attached) with a hierarchy with parents and children spread across different columns and rows. However, I am trying to condense it into one column with parents and one column with children. The only way I've been able to do this is by copying and pasting parents onto children rows, which is both a manual and time-consuming process (when you have a lot of rows). I feel like there must be a way to use VBA or a formula or something to get it to work. I have attached a sample, so you can see what I am trying to do (current data and desired data).
View 6 Replies
View Related
Nov 25, 2013
I have two slicers that are in a hierarchy. These are attached to a Pivot table whose data source is an OLAP cube. Every Partner Parent is part of a Partner Group:
Partner Parents Slicers.png
My problem is that when I click SI Alliance in Partner Group, the Partner Parent slicer does not re-sort in any way. The corresponding selected Partner Parents are scattered throughout the alphabetical list. However, in a different document, I have slicers in a similar situation, except their Pivot table’s data source is a SQL Server database. When I click on a member of the higher up group (Accenture Global Client) the lower level group (Microsoft Account Name) sorts to show only the selected values at the top of the list:
This is with all selected - Accenture Slicers All.png
This is with just one Accenture Global Client selected. Note how the selected Microsoft Account Names have moved to the top of the list - Accenture Slicers Selected.png
How I can configure my Partner Parent/Partner Group slicers to behave like these Accenture/Microsoft slicers? Is there something that I can change in Excel or in the OLAP cube to make this happen? I have already tried right-clicking the slicer and going to Slicer Settings. The settings on the Parent/Partner Group slicers mimic those of the Accenture/Microsoft slicers exactly.
View 4 Replies
View Related
May 7, 2008
i am use dir to put into an array all the folders in a folder then enter the first folder and repeat. the problem i am having is when it encounters a file it also puts it into the array and then errors once it trys to enter that "folder" (which is a file)
right now the code doesnt do anything but the plan is then to call another subroutine that lists all the files im looking for in a folder (that sub does work)
what am i doing wrong? all the things i can find on google show it the way i am doing it.
Sub GetDirList(topfolder As String)
Dim FolderArray() As Variant
Dim FolderCount As Integer
Dim FolderName As String
FolderCount = 0
FolderName = Dir(topfolder, vbDirectory)
' Loop until no more folders are found
Do While FolderName <> ""
If Not FolderName = "." Then
If Not FolderName = ".." Then
FolderCount = FolderCount + 1
Redim Preserve FolderArray(1 To FolderCount)
FolderArray(FolderCount) = FolderName
End If
End If
View 3 Replies
View Related
Oct 9, 2012
Trying to convert an Excel 2003 macro to work in Excel 2007.
The problem line is
Dim MyDataObject As DataObject
I suspect the problem is a Missing Reference, but I cannot figure out which one. I have the same ones (in 2007) as 2003 except for one which is not showing
Microsoft Forms 2.0 Object Library
Is this the one it needs? It is called something else in 2007?
The ones I do have ticked are
Visual Basic For Applications
Microsoft Excel 12.0 Object Library
OLE Automation
Microsoft Office 12.0 Object Library
Microsoft ADO Ext. 2.8 for DDL and Security
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.8 Library
Microsoft Scripting Runtime
Microsoft XML v2.6
View 8 Replies
View Related
Jul 6, 2007
how can I do this?
Mike A Johnson
Tomas P. Carbone
Samuel L Jackson
Peter B. Lacrone
some have the period some dont.
im thinking I could just get rid of the periods first with a simple find/replace
so getting rid of just the middle initial ?
View 9 Replies
View Related
