Set Pie Chart Tags To Equal Value In Cell

Oct 14, 2011

I have a pie chart, and the value's are based off of a refreshable query. How can I set the pie chart tags to, for example, =C14 and then the next tag =C15?

I know you can go to source data, and select the cells that you want the pie chart to display, but the problem with that, is when the data is refreshed the data in the cells refresh, whereas the pie chart tags do no.

View 3 Replies


Removal Of HTML Tags From Contents Of Cell

Oct 17, 2013

Any way via VBA to remove HTML tags from a string that has been imported into a cell?

For example, if the cell contained(bearing in mind I can't actually use HTML tags in this post...

"LeftPointyBracket" B "RightPointyBracket" CatDog "LeftPointyBracket" I "RightPointyBracket" Elephant "LeftPointyBracket" B/ "RightPointyBracket"I would need CatDogElephant returning. So, any pointy brackets and anything between pairs of pointy brackets needs to be removed.

View 1 Replies View Related

Removing HTML Tags From Cell Formula

Jun 4, 2014

VBA method to remove HMML tags from the contents of a cell?

It needs to remove all occurrences of the "" characters, plus anything that is found between a "< >" pair.

View 1 Replies View Related

Count If A Cell Is Equal To Cell In Different Spreadsheet And Is Less Or Equal Zero

Apr 17, 2014

How to correct my formula because it does not work?

Here the formula: =COUNTIFS(Data!C2:C24005,A17,Data!M2:M11149,"<=0")

I need to insert the formula in column C (Findings tab) which counts the rows in Column M (tab named "Data") that equal A17 (Column A in "Findings" tab) and which are less or equal zero. In addition if I drag the formula down I want to only the values be entered in highlighted in blue cells in column C (SKUs With Zero Sales in "Findings" tab) and empty cells in not highlighted cells. I attached images of these two tabs: Data and Findings.

View 5 Replies View Related

Vertical Concatenation With Tags

Mar 28, 2013

I have attached an excel sheet with the input and output required.

It is basically concatenation vertically with certain tags.

Is there a method by which i can achieve this. MACRO OR FORMULA??


View 3 Replies View Related

Delete HTML Tags

Oct 30, 2007

I have lots of text with HTML tags attached, I would like to delete the tags and be left with only the text. Is there an easy way to do this?


View 14 Replies View Related

View Website Tags?

Dec 21, 2009

I am building an application through Excel to update specific internal website information. My question is, is there an easier way to identify and view the tags on a web page without having to right-click and "view source"?

View 2 Replies View Related

How To Import XML Identifying Certain Tags / Headers

Aug 17, 2010

I am about to re write my vba project as I can see that I need to make it more robust. One of the main issues I have is that the source XML file is not controlled by me. The quality and content is consistent but sometimes the order of the columns is different. At the moment that totally throws out my macro as it relies on certain columns for certain functions.

Trying to nut out the best way to import an XML file, keep only the specific columns I want - by content not location so then all follow on formula's will work and reference the correct data.

I have one theory that I can't get going. I thought if using defined names based on column headers this would allow me to keep and sort the columns I want. I can't find any examples to support this. I have been looking at the advanced filter but most examples reference exact cells which isn't flexible and leaves open to wrong data being pulled. Since I can't control the source doc what can I do?

View 1 Replies View Related

Sorting Bag Tags Based On Scores

Jun 2, 2014

Here is the data i'm working with.

Name of player
Score of round
bag tag the player came in with
bag tag the player is leaving with

Here is what I'm trying to accomplish. I usually just copy and paste (then sort the data) but I want a spreadsheet that I can enter raw data and just look at the results I will already have the players names in my sheet. Before the round I'll get everyone's tags it will not always be in order (EX: 1,3,15,22,34,66...etc) some tags will always be missing. After the round I'll enter the scores. What I can't figure out is how to leave my sheet in alphabetical order and have my spreadsheet populate the "leaving tag" column with the correct tag based on the players score....

name score tagin tagout
bob 22 2 2
carl 44 15 23
ed 33 23 15

Can't tell if that translated, couldn't use a table....

basically I would like to leave column A where it is the whole time add the data to column B and C The use the data from column B to sort the values from column C numerically to column D (basically copy and rank then display the numbers in order). To throw in a twist if the data in column B is the same for two or more people the formula would need to take the lower number from column C to determine who gets the lower tag in column D.

having to create some kind of database in access....

View 1 Replies View Related

Displaying Comments And Tags From Files With Excel VBA

Sep 24, 2013

Finding a way to tell excel to pull Comments and Tags from files. I pulled the following code from another source:


'Force the explicit delcaration of variables
Option Explicit
Sub ListFiles()

'Declare the variables
Dim objFSO As Scripting.FileSystemObject
Dim objTopFolder As Scripting.Folder

[Code] ....

I have been using it to get the Name, Size, Type, and relevant Dates associated with files in a folder. However, this doesn't seem to work with finding Comments, Tags, etc.

I have found functions that are used to pull Comments and Tags from files but haven't been able to incorporate them in to the code I already have.

View 7 Replies View Related

Adding Bold Tags To Parts Of A String?

Oct 21, 2011

I'm trying to figure out a macro that will add b and /b tags around bold text. Bolded text can appear multiple times within a cell. I need it to run on all cells within a sheet.

So I need it to:
1. Search for bold strings within cells
2. Identify the length of the bolded strings
3. Add b and /b at the beginning and end of those strings
4. Repeat for all active cells

The only macro I was able to work out adds tags to only the last bolded string, whereas I need the tags on several non-continuous strings.

View 9 Replies View Related

Bolds / Italics And Underlines To HTML Tags

May 3, 2013

I have multiple excel sheets wherein the content has bold, italic, underlined, normal text. I want to replace such texts with relevant html tags.Example is below

Identify the adjective in the following sentence. Can you please pass me the black pepper?

should change to

Identify the <b>adjective</b> in the following sentence. <i>Can you please pass me the black pepper?</i>

View 9 Replies View Related

How Like Operator Work With Brackets And Number Tags

Feb 26, 2014

How the like operator works with brackets and # tags etc...

View 9 Replies View Related

Macro To Label Folders With Tags And Filter As Required?

Jan 29, 2014

Basically I have a large database of folders of examples of projects/notes etc, each with essentially lots of potential topic "tags". I want to sort them to be able to tell the macro what topic I am looking for and it give me the folders that contain that info. I will need to tag each folder individually (which is no problem). I am looking for a piece of script (that either exists or that I can write) that will do the following:

- tag specific folders with numerous "tags". The folders will all be stored in a database. The tags will be user input.

- sort these folders based on specified tags and show filepath/location/name/file number or something unique based on the tags input.

View 14 Replies View Related

Write Data To HTML File With Custom Tags

Nov 14, 2006

I'm trying to take the contents of an excel speadsheet and write it to an html file with my own formatting. For example I would like the row:


to end up in the html file as:

<td class="align-right">32</td>
<td class="">28</td>

In theory it seemed fairly simple to loop through a sheet and write before and after each cell, but once I tried writing the code I realized I was in way over my head.

View 9 Replies View Related

Formatting Sheet- Can't Get Html Or The Image Tags To Work For Some Reason

May 4, 2007

This is going to be difficult to explain, but I'll try... I need to be able to format a sheet that has all data in column format. Column A contains a number and B an application. C contains the issue data. I need the issue data to be moved under column A and B as illustrated below. What formula can I do to accomplish this?



Can't get html or the image tags to work for some reason.

View 9 Replies View Related

Values Which Are Equal Not Treated Equal

Jul 5, 2007

I'm having trouble with a small vba macro. At the end of the macro I test to see if two variables are equal and then print out true or false. However, for some reason even though the variables are equal vba is not treating them that way. I have put the values that represent the variables on a spreadsheet and used the if(x1=x2) formula and it says it is true, also, when I debug the macro and watch the values when it comes to test the logical expression the numbers are the same. I don't understand why vba does not say that the two variables are equal. I have attached a screenshot of the breakpoint where I double check the values are equal.

View 2 Replies View Related

Macro To Make Bottom Cell In A Column Equal Top Cell

Feb 5, 2014

I am trying to write a macro that will make the bottom cell in a column equal to the top cell. The top cell will not always be in the same row and there won't always be the same number of cells.

View 1 Replies View Related

Delete Rows Where Cell Doesn't Equal Adjacent Cell

Aug 16, 2007

I have a sheet in Excel 2004 for Mac that is a patient list with over 2000 patients. I need a rule that will compare values (patient IDs and responsible party ID) in two adjacent cells, if the values are different, to delete the entire row. The goal is to get rid of patients (rows) that are not the responsible party (responsible party ID).

View 3 Replies View Related

Restrictions On Drop Down List If Cell Is 'a' Then Other Cell Must Equal 'b'

Jul 15, 2009

I have two cells, both of which have drop down lists for options 'a' & 'b'. When one equals 'a' the other should be restricted into only saying 'b' and vice versa. I would also like the user to be reminded that he can only select 'a' once from the two menus. Ideally I would like to do this in a formula rather than VBA?

View 2 Replies View Related

Excel Formula - Cell To Count Another Cell Is Equal To Certain Value

Dec 18, 2012

Simply need a cell to count another cell is equal to certain value.

For example if B3 has a value of 6 then I need J3 to equal 1 or if B3 is equal to 3 than I need G3 to equal one. I tried the the COUNTIF but I am sure i am using it incorrectly.

View 1 Replies View Related

VBA - Delete Column If Cell Value Of Range Is Equal To Another Cell

Nov 5, 2013

I would like to create a VBA code where it will delete the entire column if the cell value is equal to value in D2

For example:

Sub Delete_Columns()
Dim rng As Range, cell As Range, del As Range
Set rng = Intersect(Range("G2:S43"), ActiveSheet.UsedRange)

For Each cell In rng
If (cell.Value) = D2 _
If del Is Nothing Then
Set del = cell
Else: Set del = Union(del, cell)
End If
End If
Next cell
On Error Resume Next
End Sub


But I think this line is wrong but I am not sure how to fix it - If (cell.Value) = D2 _

View 5 Replies View Related

Making 1 Cell Equal Another Cell Including Its Comment?

May 18, 2014

I have a spreadsheet with some cells which return values using INDEX and MATCH to bring back the entire details of a person based on there membership number. However I require the comments to be attached with the returned values. The comments have there image in, rather than just text.

I have found some answers with vba, which do the process, however you had to manually enter the cell, from which the comment was to be copied from, into a pop up box. This involved finding the box myself to then select the box to take the comment from. In doing this I had found and read the comment, which is the is the process I'm trying to bypass.

View 8 Replies View Related

Last Occupied Cell To The Left And Equal To Or Above Current Cell

Nov 22, 2009

I've been pounding away at a project for two days trying to determine a way to identify a solution, to no avail.

Here is some experimental code. Under the assumption that in Column "A", every fifth line contains some text (a, b, c, etc) I want to place a function in column B that would identify the closest occupied cell above and to the left of the cell containing the function. The sub achieves this, but the function has a problem because of the Activecell line. Is there a way to identify the location of the cell containing the function to act as a reference point for the range?

Sub find_last_heading()
Application.ScreenUpdating = False
x = ActiveCell.Address
ActiveCell.Offset(0, -1).Select
last_heading = ActiveCell.Text
Do Until last_heading ""
ActiveCell.Offset(-1, 0).Select
last_heading = ActiveCell.Text
MsgBox last_heading
End Sub
Function cathead(Optional reference)

Dim cell

View 9 Replies View Related

Identify Rows Where A Given Cell Is Equal To The Contents Of The Cell Below

Apr 26, 2006

I need to identify rows where the contents of a given cell are equivalent to the cell below. I have managed to get this working based on iterating through the cells and selecting them both for cutting.

However it doesn't work effectively: It seems to be leaving blank lines in the original sheet and further fails after the first execution. I would be grateful for any suggestions on a good method to perform the following operations:
(1)to compare the cell with the cell below
I have used

If cell = cell.Offset(1, 0) Then

(2)to act on the rows for the two connected rows

Sub Test4()

' Loop through rows

Dim TheExtract As String
Dim cell As Range

'Application. ScreenUpdating = False
For Each cell In Worksheets("Sheet 1"). _
Range("A1", Worksheets("Sheet 1").Range("A65536").End(xlUp))
TheExtract = cell
If cell = cell.Offset(1, 0) Then
ActiveCell.Offset(3, 0).Rows("1:1").EntireRow.Select
Selection.Insert Shift:=xlDown
End If
Next cell
'Application.ScreenUpdating = True

End Sub

View 3 Replies View Related

Excel 2003 :: Expanding List To Use In Mail Merge Program To Produce Tags For Direct Mailing

Sep 25, 2012

I have an Excel 2003 list with four columns as shown below:





I want to "expand" this list to use in a Mail Merge program to produce tags for our direct mailing. Each bundle contains 50 letters, so in the first line on the above spreadsheet, there will be 13 bundles of 50 and 1 of 43. Currently, I can cut and paste to create the following table, but there has to be an easier way...



[Code] ........

So as I pull this into a mail merge I will get a tag that shows the zipcode, the crrt, the total pieces for that crrt, then number of the bundle for example " 1 of 14" and the quantity in that bundle, for example "50 of 693", then the next bundle tag will print, 3 to a page. I know that here has to be an easier way either in the mail merging process itself or with EXCEL? Am even open to build these with ACCESS to create the tags. The beginning database contains anywhere from 350 to 800 lines of original data, so as you can see the cut and paste is VERY time consuming.

View 6 Replies View Related

Input Box - Look At Cell To See Value Equal To Zero In It

Jul 24, 2014

I would like to program an Input Box that looks at the cell next to it to see if there is a value equal to zero in it. If there is a Zero in the cell an Input Box will popup and ask "what was the result". It would keep going down the column until there are no more values in column A.

In this example the Input Box would popup for the second line and the third line and then populate the values entered into C2 and C3 accordingly.

Col A Col B Col C
1 1 52
2 0
3 0

View 2 Replies View Related

To Have Cell Equal To Autofilter

Jan 18, 2008

I have 2 worksheets, and I was wondering if I can have a cell from Sheet2 equal to the subtotal of the Autofilter criteria of a column in Sheet1.

I do have something working with macros but it takes a long time. This would make things a lot easier.

View 9 Replies View Related

VBA To Hide Row If Cell Not Equal To Value

Oct 24, 2013

I am trying to write a macro which will hide and show row 15 based on the value which gets input into E9.

Part 1 here is working and when E9 = "DP Deliverable" row 15 does appear, but on the converse, when I input something besided DP Deliverable into E9, row 15 does not hude.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$E$9" Then
If Range("E9").Value = "DP Deliverable" Then
Call Show_DP

If Target.Address = "$E$9" Then
If Range("E9").Value "DP Deliverable" Then
Call Hide_DP
End If
End If
End Sub

View 4 Replies View Related

Number To Equal Cell Value?

Jan 23, 2014

I currently, manually create my production work orders using excel (in-house ERP system not good enough).
Rather than manually type in the names of products to be produced, I would like to have the number 1 = a production item and 2 = another and so on.....So basically when I type 1 in a cell it will automatically display a production item.

I imagine this to be a process where i would type all the names of my production items in individual cells, then create a formula to make 1 = a specific cell, 2, 3, 4, etc.....

View 5 Replies View Related

Copyrights 2005-15, All rights reserved