Hi guys,
Good day. I am trying a macro which i found online which finds the availability of a sheet, delete it if its found an can create the same sheet again.
Sub test_delete_add_sheet()
Application.DisplayAlerts = False
Dim sh As Worksheet, flg As Boolean
For Each sh In Worksheets
If sh.Name Like "Sheet1*" Then flg = True: Exit For
Next
If flg = True Then
Sheets("Sheet1").Delete
Else
Sheets.Add
ActiveSheet.Name = "Sheet1"
End If
End Sub
I wanted to do the same to find a chart and deleting it and creating it if an user specifies it in order to save space in my spreadsheet. Can anyone advice me on this?
I am trying to figure how I can create a chart in excel. I was recently informed that this was possible. I have a cell in excel that runs calculations from DDE links. Is there any way that I can have this cell make a line chart everytime it updates (Which happens about every half a second). The cell that I want to graph holds the price of a group of stocks and have a chart of it would be great. Is there anyway to do this?
Good afternoon, I am looking to create an org chart from an list of names in Excel?
Is there an easy way to do this?
Thanks.
Apologies if this has been asked before. I tried to search but didn't find anything that seemed to fit.
I have two columns:
Employee ID
Supervisor ID
I am trying to build a tree that goes from the various leaf nodes to a single root node.
At the top of the node is our CEO. from there I want to build the entire tree so that I can count how many people report into any given person. I don't want just the direct branches, I want a count of every branch at every level below the person of interest until I reach the final leaves.
Is there a way to do this in Excel? Access 2007 doesn't allow recursive SQL queries.
The rules I have come up with so far a
* each employee has a supervisor (except one, who is the root node)
* an employee who is not a supervisor is a leaf and thus the end of the recursion path
any assistance that can be provided would be most appreciated.
Dear all,
I want to create chart by excel COM interface in C# language, and the value and wanted chart is attached.
Thank you!
I would like to create a chart in Excel that allows positive and negative X and Y values. What I really would like to do is plot slopes in the form of y=mx+b and be able to input the values of slope(m) and offset constant (b) and have the chart update the graph on the fly. Is this possible? :idea:
Hi All,
I have a requirement to create a flow chart (with just rectangle boxes and one sided arrows). e.g.
Job A triggers Job B
Job B triggers Job C and Job D
Job C triggers Job E
I want to put this in a flow chart/org chart sort of thing. I am able to create one where a job is triggering only one job. Not very sure how branching can be done in VBA. Any help/pointers will be appreciated. Thanks in advance
Hello guys
I looking for a way to create a pie chart from a list.
The list is an overview of my expences an is done from a dropdown menu on each line (i.e. I buy some food and choose 'Food' from my dropdown menu. In the cell below I choose 'Office Supplies' for the stapler I just bought. And so on.)
My pie chart should automatically be updated when new posts in the list appear.
This way I can get a visual overview of my expences.
How do I do this?
I run Mac office 2007 - which means no VBA macros.. Can it be done without?
Thanks!
- Jesper
Data is in Column A (Quantity), Column B (Price) and Column C (Profit)
What I want is the graph to show price on Y-Axis, quanity on X-Axis and the line on the graph to plot the profit. Sounds simple?
But when I do the graph, it shows profit on Y-Axis, Quantity on X-Axis and no Price.
The profits are both positive and negative.
The lowdown:
2 week periods
Pay schedule starts on Sunday (but actually work monday - fri and sometimes sat)
Overtime starts AFTER 40 hrs/week, not after 8 hrs/day
Minimum pay = 17.25
Overtime pay = 25.875
I've got the concept of how to add up and convert my hours. My problem is with the overtime hrs and pay. The way my spreadsheet is working right now is that it's not correct until the last day that I clock out. Up until then the pay is incorrect and sometimes in the negatives which it should never be. I need some help with formulas for adding this up correctly. Thanx
