Changing values in one cell depending on drop down list values in another cell

I'm new to all of this and I'm stumbling through as best as I can so forgive me if I don't explain this very well.

I have a workbook that has over 180 worksheets in it.

I store ongoing data on each worksheet in cells a6:i6 through a2506:i2506.

At the start of the new year I only need to keep "Active" data.

I want to be able to compare cell b6 through b2506 individually and make sure it doesn't match ANY cell in the range k8:k508 collectively and then clear contents of range a:i for each row b6:b2506 that doesn't match.

I can't use a simple compare b to k because column k is a consolidated (removing duplicates) list of...

Hello,
I have an excell spreadsheet that contains a table. I want a macro of vb to insert a row into the table when the values in a particular column change.
column A
1
1
1
2
2
3
3
3

would convert to
1
1
1

2
2

3
3
3
Any suggestions welcome. I have limited experience in using macros and almost none with vb

Hello,

New VBA user..

I have created code to copy a worksheet multiple times and rename based on a list in excel. However, I am receiving an error on the ActiveSheet.Name=Sheets.... line. Please help. This is my code.

Sub CopySheet() Dim i As Long, LastRow As Long, ws As Worksheet Sheets("Master").Activate LastRow = Cells(Rows.Count, 1).End(xlUp).Row For i = 1 To LastRow Sheets("Master").Copy After:=Sheets(i) ActiveSheet.Name = Sheets("Dates").Cells(i, 1) Next i End Sub

Hi All,

How do I put a cell value into a cell when the range of cell contain a specfic text.
For example, in the sample below, I want to put the cell value (13/2/2014) into B3 when a range of cell (A) contain Sam.




A1 Tom
A2 13/2/2014
A3 Sam
A4 15/6/2014

B1
B2
B3 13/2/2014
B4


Is it possible as well that I can copy the cell value (13/2/2014) to all fields in column B till it reaches TOM (A1) for example?

Please enlighten me.
Thanks

I hope someone can help me with this...I've done this before but can't remember how.

I have a list of names (for an attendees list) and I need to show an extended total for each
person and the number of guests they will bring. Here's the layout...

B2 is the person's name
C2 is the number of guests they will bring
D2 is the total for that person (including them)

I need a formula that says: If B2 has any text, then add a value of "1" to C2 and enter the total in D2.

Hope that makes sense. Thank you in advance for helping.

Does anybody know how I can repeat rows in a spreadsheet by n number of times specified in cell B in that row

ie from this table:

Column A, Column B, Columns C-Z have other data that needs to be duplicated to each row too
Jack, 2, Data, Data, Data, etc...
Mary, 4, Data, Data, Data, etc...
Henry, 20, Data, Data, Data, etc...
Ross, 3, Data, Data, Data, etc...

I need it to look like this:

Column A, Column B, Columns C-Z
Jack, 2, Data, Data, Data, etc...
Jack, 2, Data, Data, Data, etc...
Mary, 4, Data, Data, Data, etc...
Mary, 4, Data, Data, Data, etc...
Mary, 4, Data, Data...