col

I need help :) If Col C cell contain 'Poster' OR 'Index' COPY TO Col E Cell to Col A Cell Than Delete Col E E the flow is *xxx refer to some text If Col C cell contain 'Poster' OR 'Index' <tbody> A B C D E xxx xxx Poster 13 62131 xxx xxx Index 16 62141 </tbody> COPY TO Col E Cell...

Hello, I seem unable to find a way to first copy n paste say Column B:B to sheet2 say A:A (I do this fine lol) Then I want to run a find and replace on Sheet1 col b:b without the find & replace doing the same thing to sheet2. As I want to then copy sheet2 a:a to sheet1 a:a to create my cross...

Desired end result: A pivot table that counts employees onboard by month. The spreadsheet that I have is massive. It has over 10,000 employees and all the charge objects they could charge to in a day. So 1 employee will have multiple rows. What formula can I use to only count an employee...

I have this code I want it to do a job for me but it's not finishing it properly. Dim eCell As Range For Each eCell In [E5:E18] eCell.Offset(eCell.Row-5, -1).Font.Color = eCell.Font.Color eCell.Offset(eCell.Row-5, -3).Font.Color = eCell.Font.Color Next eCell The aim is...

I am stuck trying to do a sumifs where a partial match = set criteria <tbody> Price Group Country Volume A <100 - 499 GB 1790 B 500 - 1000 GB 5232 C 1001 - 2000 DE 9958 C 1001 - 2000 GB 4556 </tbody> so If i want to sum the volume where price group >= 500 I'm thinking along the lines...

I want to copy data from Sheet1 to Sheet2 based on headers in two sheets. The following code works great when both sheets’ headers are in first row. My question is if header in Sheet2 is in row 8, then how would my code be? thank you. Sub CopyData() Dim sws As Worksheet, dws As Worksheet Dim...

Hello, I am trying to have a certain cell locked (B2) that only a certain date format can be entered but I keep getting an error with the code. Perhaps you can shed some light on what I am doing wrong? Still very new to this. Thank you Private Sub Worksheet_Change() Call ValidateDate(2)...

Afternoon Everyone, I hope someone can assist with a small problem. I want to get a formula which searches 2 criteria and return a answer. It's like a Vlookup but with an additional criteria. I've tried consolidating the cells but someone told me that using INDEX and MATCH are a better was to...

Hi, I have the following sheet <colgroup><col><col><col><col></colgroup><tbody> Col A Col B Col C Col D S.No. Name Attendence Hour 1 John P 5 2 Nick P 6 3 P 7 4 P 2 5 Raghu P 4 6 Ravi P 4 7 Rozi P 5 8 P 9 9 Matty P 8 10 P 5 11 Saurabh P 5 12 Hanery P 5...

Hi and Thanks in advance i have post earlier some problem and get the solution but that was in complete and also i have lost that post url. Problem is, i have following sheet <tbody> Col A Col B S.No. Student Work 1 2 2 3 3 6 4 8 5 4 6 2 7 3 8 6 </tbody> In the above...

Hi , I have the data set <colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody> COL A COL B COL C COL D COL E ROW1 DATA DATA DATA ROW2 DATA DATA DATA ROW3 DATA DATA DATA ROW4 DATA DATA...

Hi all I’ve been given the code below which seems to do almostexactly what I want it to do but I’d like to make a couple of changes which iswhere I’m stuck AsI understand it this code identifies if a cell has been changed then if thetotal in row 21 is higher than that of row 23 provides a...

Hi and thanks, Data set Col A Col B Col C Col D Col E Col F Col G Row 1 x x x x x x x <colgroup><col><col><col><col><col><col><col...

I have some data in A1 that looks like the following: PA1*COL 1*50*Snack 1 PA2*3*100*1*100 PA1*COL 2*100*Snack 2 PA2*52*100*0*0 PA1*COL 3*100*Snack 3 PA2*2*200*1*100 PA1*COL 4*50*Snack 4 PA2*7*50*0*0 PA1*COL 5*200*Snack 5 PA2*100*0*0*0 In A2 i need to be able to type a value, in this example i...

Hello i have to extract numbers from a string in Col G (varying rows) the data looks like this <colgroup><col></colgroup><tbody> <colgroup><col></colgroup><tbody> Width = 760, Depth = 350 Width = 1610, Height = 50, Depth = 16 Width = 1610, Depth = 350 my formula in col H </tbody>...

Hi guys Just as a simplified example I have the following data Column A Col B Col C Product May June Item1 5 2 Item 2 8 3 I would like to create new column names "Change" calculated...

Hi, I have data in a table that has a range of numbers in col A and various names in Col B. I'm trying to get a formula to check through a column of numbers find the numbers that are less than 5000 and return the name in the adjoining cell from the same row and create a list of the those names...

This code ' Option Explicit Dim MyRunTimer As Date col headers A = Date B = Time C = Message Sub MyMacro() MyRunTimer = Now + TimeValue("00:00:10") Dim i As Variant, t As Date, s As String If Range("D1") <> "" Then Exit Sub Else For i = 2 To [A65536].End(xlUp).Row If Cells(i...

Greetings, I have a macro to remove duplicate rows that I'm pretty sure used to run, but it isn't working now. I haven't used it in quite a while, but yesterday I needed it and it crashes with a run-time error 1004 at the "ActiveSheet" line. Can anyone tell me what is wrong with it? Sub...

Good Morning All I have inherited a huge spreadsheet of one worksheet (called ManningPlot) detailing the manpower situation across a number of departments across the business. This spreadsheet has one row per person and details a lot of info regarding that person and his/her position. There...