Seperate Into Different Tabs Depending On Cell Content

Jun 26, 2008

I have a list of sales enquiries 1600 rows long. Each has a brand recorded in cell J (from j4 above is headers)

I have 4 brands

A, B, C & D

I would like to copy the data from the master sheet into 4 tabs lables A, B, C & D depending on the brand recorded in J

View 9 Replies


ADVERTISEMENT

Seperate Cells Depending On Content

Jun 24, 2009

I have some workbooks that have some serials in A row and i need to seperate them depending on how many digits they have,

For example some have 13 digits,and some 8.I just want to seperate them into different rows.

Here is a sample

seperate sample.xls

View 5 Replies View Related

Way To Name A Sheet Depending On The Content Of A Cell

Jul 14, 2009

on sheet1 cell a1 is there a way to make sheet1,s name appear as the contents of cell a1

View 9 Replies View Related

Fill Color Depending On Content Of Other Cell

May 1, 2008

I have a template I have been asked to amend and I know I need to use Conditional Formatting I just can't crack the formula I need to use. Cell A2 will have either "CD" or "CW" or "IN" input into it

When user inputs either "CD" or "CW" into cell A2, I want cell G2 to have "Margin Movement" automatically displayed. When user inputs "IN" into cell A2, I want cell F2 to have "MV" automatically displayed, and I want cell G2 to be coloured in bright red fill. Then user is to go to cell G2 and input some text as a description, and I want the red fill to disappear once they have input something in there.

I thought I had it licked using IF statements for the "Margin Movement" and the "MV" cells, but I can't get the conditional formatting to work - I assume this is because the cells aren't technically "blank", as they have IF statements in them.

View 3 Replies View Related

Inserting Values In Cell Depending On Content In Adjacent Cell

Mar 20, 2014

I have the names of companies in one column, and the amount they owe in cells in the column beside them. I then have a second list of companies that is a subset of the first. Is there a formula that would place the amount they owe in teh corresponding cell adjacent to the compny in the second list? I've attached a sample workbook, Full Company List in column A, amount owing in B, trimmed down list in D and ideally I'd like the corresponding values in E.

View 3 Replies View Related

Changing Cell Colours Depending On Cell Content

Nov 19, 2008

What I need to do is have a cell that will be say yellow until there is information put into this cell. The information could be in the format of text or numbers. The information would not always be the same so it would need to be yellow when there is no information in the cell and another colour or white when there is information in the cell.

View 6 Replies View Related

Replace Cell Content- Depending On Other Cell Data

Mar 6, 2009

I have a file consisting of two columns, called, "bom ref" and "material"
I need to show the data as indicated in the file, headed required format required.

In effect where I have a 0, that is the material I need to show for every row with a bom ref. of 1,2 or 3, down as far as the next 0 but not including the 0, when I reach the next 0, the material is a new letter, and that letter needs to repeat down as far as the next 0, but not including the 0 and so on.

View 4 Replies View Related

Add (every 3rd Or 4th Depending On Content) Rows Into Columns

May 21, 2012

I have a set of data all in clumn A - I want to sort into into rows - "Name", "Manage" or "Send Message", "Job title/Company" and "Country", but some are missing "Country" (therefore, some entries have 3 rows and other have 4.

The differentiator is that every name is repeated within the cell, whereas no other row is repeated. Any macro to get all these into 4 columns?

Example:

Steve Wonder Steve Wonder
Manage General Manager in ZXY games United States Jake Gave Jake Gave
Send message VP Business Development in XYH Games
Russia Carter Jonas Carter Jonas Send message in 148G
Clement Galiay Clement Galiay

View 9 Replies View Related

Duplicating Rows Depending On Column Content?

Jul 18, 2013

Im replicating rows which have multiple items in Column1. Im aware that the ID Column has duplicates..my source data is like that for now so I wont complicate it just yet.

Once ive got this working I can proceed to the rest of the tasks

View 9 Replies View Related

Automatically Size Textbox Vertically Depending On Content

Sep 13, 2005

Is there a way to control the vertical size of a textbox, so that we could type in a List of Instructions to our operator, and the textbox would resize depending on the numbers of instructions in the box. Also the items in the cells beneath the textbox would need to move down, to allow for the resized textbox.

View 3 Replies View Related

Moving Data From Rows To Columns - Depending On Unique Content In A Field In Column

Jun 24, 2014

I have a worksheet which contains 2 columns which is needed to work my problem.

Unique Work ID and Description

The unique work ID are the same for each description, but there are up to 5 different description associated with each unique work id.

I'm looking for an automated process but where to start to convert the 5 rows in the unique row and 5 column for the descriptions

View 8 Replies View Related

Text To Columns: Split Data In Seperate Seperate Coloumn

Jul 23, 2009

Attached file where i m not able to split data in seperate seperate coloumn

View 3 Replies View Related

Read Cell Content & ADD Content + Font Properties *SOLVE

Sep 12, 2007

I use this to read cell content, add some text/characters (ie. [ and ]) and change the properties of the complete cell

Sub COMMENT()
Worksheets("DVD Lijssie").Activate
If ActiveCell.Value 0 Then ' Change all in to ... ... ...
ActiveCell.FormulaR1C1 = ActiveCell.Value & " " & "]" & " " & "["
With ActiveCell.Font
.Name = "Arial Narrow"
.Size = 8
.ColorIndex = 16
End With
End If
End Sub
HOW can I change this vba-code so it leave's the content of the cell like it is and add some content with the use of let's say TexBox1 and ONLY use different font properties for the newely added content?

View 9 Replies View Related

Change Content Of One Cell Based On Content Of Another

Apr 18, 2014

Formula/macro/etc that would enable me to have content of a cell changed based on the content of another cell in the same row.

Example: cell in column D says "PSA" - so I would need the cell in column H for that same row to read "Radio"

I would need an entire sheet scanned to review for these occurrences and make the appropriate changes. I also would need the formula to be inclusive enough to scan for variations in column D cell content (PSA 1, PSA 2, etc).

View 4 Replies View Related

Matrix - Identify Cell Content In Column For Row If Matrix Content True?

Mar 21, 2014

For a table like the one below produced for the sake of example (actual is much much bigger) I want to make it list rows that are true for a certain column for a certain variable in the matrix. So for say water terrain, which types of activity can I do i.e. swimming. Or for Offroad the activites which I can't do i.e. Run and Swim.

ActivityWaterRoadOffroad
Jog nym
Run nyn
Walk nyy
Swim ynn
y=yes
n=no
m=maybe

View 10 Replies View Related

Look Up Values Based On What I Put In A Seperate Cell

Oct 5, 2009

I want to be able to look up values based on what I put in a seperate cell. For instance, I want to be able to type in 11 in cell B1 and have A1 return the value for E11. Then if I change the value to 10 in B1, the value for E10 would be returned.

View 3 Replies View Related

A Formula To Seperate Digits In A Cell

Oct 27, 2009

During work this thing stuck me that i have a column A1 an amount like 12345663..now what i want in column B1 the same amount but except first 3 digits..for example instead of 12345663 i want only 45663 in column b..

View 4 Replies View Related

Lookup Closest Value Of A Cell Within A Seperate Column

Apr 21, 2009

I have a spreadsheet with two sheets, 'Sheet0' & 'Sheet1'. In 'Sheet0' I have a column named 'A_Sheet0' containing a list of numbers from Rows 2 - 50. In 'Sheet1' I have 3 columns, the first containing numbers 1 to 50, the second, 'B_Sheet1' containing a list of ascending numbers and the third is the column of interest. This column entitled 'Nearest Value' must read the corresponding value of Column 'B_Sheet1' then find the closest number to that from the numbers in 'Sheet0', column 'S_Sheet0'.

I have included a sample file with this thread, and in the 'Nearest Value' column I have manually input some of the nearest values for your information.

View 7 Replies View Related

Hyperlink From A Shape To A Cell On Seperate Worksheets

Feb 10, 2010

I had getting a hyperlink from a Shape to a Cell on seperate worksheets and the macro works fine:

View 4 Replies View Related

How To Seperate Data In A Cell And Create New Rows

Jun 23, 2013

I am somewhat new to excel and have a task I have a catalogue that I need to separate multiple printer models that all have the same part # into individual line items. This will save me weeks of work.

I have this:

Model
part
DCP-7020/HL-2030,2040,2070N/MFC-7220,7420,7820N
TN350

And want to end up with this:

Model
Part
DCP-7020
TN350
HL-2030
TN350
HL-2040
TN350

[Code]...

Or even this:

Series
Model
Part

DCP
7020
TN350
HL
2030
TN350

[Code]...

View 5 Replies View Related

Concatenate All Values In Row Into Cell & Seperate With Commas

Dec 10, 2007

I have a bunch of cells (could be varying amounts from 2 to about a 100). I need a macro which can find out how many rows in column A contain values and then i need to pick values from each cell in column A and put them in Cell B2 seperated by a comma.
eg.
Column A Column B
22 22,35,67,34,56
35
67
34
56
Column A could contain as many as 100 values.

View 5 Replies View Related

Do 3 Seperate Calculations In A Single Cell And Desplay Those Results

Nov 2, 2009

Is it posible to do 3 seperate calculations in a single cell and desplay those results? For example in a single cell: A1+A2 | A3+A4 | A5+A6|

Where:
A1 = 1
A2 = 2
A3 = 3
A4 = 4
A5 = 5
A6 = 6

Results Display: 3,7,11.

View 3 Replies View Related

Seperate Date From Time In Cell Macro Code

May 20, 2008

I have cells in a column that record time in date. Unformatted it would appear as 19789.51407 but formatted to show time and date it would as appear as 3/6/54 12:20 PM. I am making graphs with the data and I want the title of my x axis to read "GMT Time (mm/dd/yyyy - mm/dd/yyyy)" or "GMT Time (mm/dd/yyyy)" depending on if the event spans more then one day. Using the following code, it almost accomplishes this.

Dim strDate As String
Range("CO3").Value = Range("A3").Value
Range("CP3").Value = Range("A" & Drag).Value
Range("CO3:CP3").NumberFormat = "m/d/yyyy"
If Range("CO3").Value = Range("CP3").Value Then
strDate = "GMT Time (" & Range("CO3") & ")"
Else
If Range("CO3").Value < Range("CP3").Value Then
strDate = "GMT Time (" & Range("CO3") & " - " & Range("CP3") & ")"
End If
End If

Where "Drag" is a variable that signifies the total number of cells in the column; ie the first and last dates. It compares the values and saves the results as a string. The problem is that when the string is saved it saves the date in mm/dd/yyyy hh/mm/ss. How can i separate the date from the time so I can have the title of my x axis appear as i need them?

View 3 Replies View Related

Copy Cell Reference From Seperate Sheet To Increment Correctly

Oct 28, 2009

I have two sheets in my workbook, and I am trying to reference one chart's value into the other. (attached)

I have referenced successfully by manually typing in the reference on row 2 for all values on Sheet 1:
Sheet 1 - C2 needs to reference Sheet 2 - B2. (Sheet2!B2) - no problem all the way across to F2. All those values are correct b/c I manually typed in the reference.

The problem comes when I just want to drag over that same formula to increment for the other cells. It's not incrementing the formula like I need it to.

So, Sheet 1, Row 2 shows how the correct values I need to pull over but was done in a manual way. Sheet 1, Row 5 shows how it increments incorrectly when I try to just drag/copy the formula over. What I need is for Sheet 1 - D5 to reference Sheet 2 - C3, but instead if I try and drag to copy the formula instead of manually typing it in, it increments when I drag reference D2 instead of C3.

View 2 Replies View Related

VBA / Word Picture Content Control Causing Unreadable Content?

Jan 15, 2013

I am using VBA to create a word document (.docx). This word document contains plain text content controls as well as picture content controls. I then use VBA to automatically select a picture based on the code below

Code:
Set oCC = Word.ActiveDocument.SelectContentControlsByTitle("TabPic").Item(1)
On Error GoTo TabErrorHandler
oCC.Range.InlineShapes.AddPicture Filename:="X:XFERANDREW-TDCD " & LblVL &

[Code].....

After the document has been closed down I try to open it again and I am told "The file cannot be opened because there are problems with the contents."

When I click details it says "Unspecified error" and "Location: Part: /word/document.xml, Line: 2, Column: 0"

If I click ok it says "Word found unreadable content in "". Do you want to recover the contents of this document? If you turst the source of this document, click Yes.

Clicking Yes opens the document with all the contents and it is now renamed to Document 1. If I click no it does not open.

View 9 Replies View Related

Merge The Content Of 2 Cells Into 1 (with A Comma Separating The Content)

Jan 29, 2007

how to combine the content of 2 cells into one cell and have the information separated by a comma.

For example:

CELL 1:
Software 1

CELL 2:
Spreadsheet Software

The desired results is:

CELL 3:
Software 1, Spreadsheet Software

View 3 Replies View Related

Insert Formula Depending On Cells Depending Of Variables?

Jan 27, 2014

In a macro I want to automatically insert a formula in several cells. The formula depends on other cells, and I want to be able to manipulate these cells with variables. Here is my code:

[Code] .....

All my variables are declared:

Sheets("DATOS YTD 2014").Cells(I, Semana + 1) is the cell I want to be able to chose due to the variables
Sheets("DATOS YTD 2014").Cells(I, 3) is the reference cell for the VLOOKUP formula, that will vary with I
SheetMonth.Range("B3:W172") is a range in the sheet SheetMonth which is fixed

The error message I receive is the following: "Run-time error 13, Type mismatch"

I precise that the next step is to make the ",6," part in the vlookup formula also variable... but I guess once my current issue is solved this one will be a piece of cake.

View 3 Replies View Related

Excel 2007 :: Change Colour Of Tabs To Match Other Tabs In Workbook

Sep 22, 2012

I have been trying to get Excel (2007) to change the colour of tabs to match other tabs in the workbook

Using this code I get the colour code of the current tab

Code:
x = ActiveSheet.Tab.ColorIndex

But when I use this value in a procedure like this:

Code:
ActiveSheet.Tab.ColorIndex = x

The tab is a different colour!

View 3 Replies View Related

Use The Names Of The Tabs In The Summary Page And Create It Into A Formula To Lookup Fixed Cells Within The Various Tabs

Oct 12, 2009

I have a summary page that includes the titles for each tab within the excel 2003 workbook. I want to use the names of the tabs in the summary page and create it into a formula to lookup fixed cells within the various tabs. Sorry for not uploading an excel doc but I was at work earlier and the thread did not load for some reason, so I am reposting it.

View 3 Replies View Related

Add Cell Content Into Formula Command In Another Cell For Multiple Files Search

Apr 12, 2014

How to determine the correct formula for this requirement?

Assuming I have 2 individual excel files and an index excel file (in reality, there are more than hundreds of file). For index excel, once the user enter part number (eg. 1 or 2), the excel will look for the part number excel file and determine vlookup function.

The only problem I have here is I can not make the index file automatically add the part number shown on most left column into the required formula (replace the part number file section).

I tried use the indirect function but this require each file to be opened, which is not possible for actual use. I am looking for a function that can work in closed worksheet.

Attached files :
index.xlsx‎
1.xlsx‎
2.xlsx‎

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved