The discussions
Locate 7 digits after 'dell#' in one column and have it replicat
Hi I am trying to locate 7 digits after 'dell#' in one column and have it replicate those digits to another cell.
How to look up a value within only a subset of another column?
Hello, Thanks in advance for any help! This is my data: X 1 3 X 2 4 Y 1 5 Y 5 4 Y 3 2 And I want to know, does the value in C1 ('3') ...
Google sheets to keep up with high school football scores
Hello, Ok I am creating a google spreadsheet to keep up with High School Football Scores. I would like help with a formula that allows me to color...
Conditional formating - apply on more cells
Solved/ClosedHello, i'm not so familiar with conditional formatting, so I would like to ask something: I'm making a doc where Column A has number values, column ...
If and or functions using a date
Hello, I am trying to make a formula that says IF Cell is dateA then the answer is Blue If cell is dateB then answer is Green If A9=(2017,9,9)...
Automatically transfer data from multiple sheets to one sheet.
Hello, I have a price book in Excel with multiple sheets. Sheets are formatted differently except for first three columns (QTY,PartNo,Price). I ...
Date format
Hello, i downloaded one excel sheet containing dates in format December 13th, 2011 . i want to change its date format . i tried changing in form...
Change date format
How do i change the below date format into mm/dd/yyyy? 15-12-2015 22-07-2015 22-07-2015 your response is highly appreciated
How to change the date format in excel 2007
Solved/ClosedHello, i want to know that howcan I change the dateformat in excel 2007 worksheet if I want it like :- monday,1dec.2008 plz. answer me soon....
Macro to create new workbook and copy data at each change of x
Hello, I get large spreadsheets with thousands of lines with close to 200 patient names (one patient contains multiple lines for each different da...
How to compare column and spot the difference
Hi. I really need help to solve this problem. I have few hundred data in 4 columns as below. Is there's anyway I can use excel formula to find the ...
Convert date into month and year to use > <
Hello, I have two sets of dates that I need to compare using ,=. One of my dates is formatted mm/dd/yyyy. the other date is mm/yyyy. The goa...
Sentence peekaboo
In excel. I am typing a sentence and as soon as I click in another cell half of my sentence disappears. Only to reappear when I click back into the be...
How to make workbook autocreate new sheet every month with data
Hello, I am looking for some help, I am wanting my workbook to auto create a new sheet at the begging of every month and that when it makes the ne...
Copy names from one worksheet to another and copy
Hello, I have an issue at work that a macro, if it is possible, would be extremely useful. I have an excel file with a list of hundreds of first...
Excel help please!
Hello, I am in the process of creating an action tracker so it has all the actions that come out of different meetings. Each meeting has a seperate...
Excel macro
Hello, I'm also very new to macro, so I don't know what I'm supposed to be adjusting! My main sheet is titled "Project Timeline" and my other s...
Search for input criteria, return designated cells.
SolvedHey all, I am trying to write a VBA command/macro that essentially takes a criteria input from the destination worksheet, searches and matches the ...
Inserting and formating date with userform
Hello, I am trying to Insert a date with a Textbox in a Userform. It should have this format: Friday, 18.08.2017. This entered Date is used...
Copying dates to another worksheet.
SolvedHello, I found this script from vcoolio, thanks for that! Sub Advise() Dim x As Integer Dim lRow As LonglRow = Range("E" & Rows.Count...
How to convert numeric into words in excel
What is the formula to convert numeric in words?
Excel formula - add days to date based on drop down selection
SolvedI want to add days to a date based on options selected from a drop down list. For example, if cell C5 reflects "New Hire" or "Post New Hire", I want ...
Comparing two excel sheets and copying like data to third sheet
Hi, In your below coding, I can copy paste the alike data from sheet 1 only, I need to copy paste both from sheet 1 and sheet 2 line by line matchi...
Vba: cell range
Hello, I am a beginner with VBA and I have a question that might sounds stupid to some. I have created a function of IfElseIf and I want to run it...
Search for text , cut and paste into new work sheet
Hi , can anyone help me with the below vba code : Logic Find text If next row starts with number Then - cut 1 row above text and 3 rows below ...
Transfer data from one sheet to another
Hello, i have started an inventory sheet on excel what I want to do is take the list of inventory and when it is sold, have it transfer to the second ...
How to compare two excel sheets and combine matching data
Hello, I'm looking for a macro that will match data in column A from sheet 1 to the data in column A from sheet 2 and copy the corresponding rows f...
How to auto-populate values from certain cells into a new sheet
SolvedHello guys, Hope everyones doing okay. I've been working on a billing sheet for a company with multiple product codes and rates etc to be pulled f...
Copy and paste entire row if a specific cell agrees with if cond
Hello guys! I have been writing a vba code for a while and I cant find the mistake that I am making... I have a big table and I am comparing the va...
Date entered wrongly
Hello, I entered dates as 'Apr 24' wherein I meant 24th of April..Excel has taken it to be '01 April 2024'..how do I correct all such entries, if ...
How to highlight a row when i enter a date in column i
Hello, I am trying to highlight a row when I enter a date in column I. How is this achieved?
Copy specific number of rows and insert n time after 3 rows
Hello, Please help I want to Select & copy 35 rows data and after 3 rows I want to insert the copied rows n number of times. I need the Row widt...
Highlight only one column which has greater value
SolvedHello, i am inputting numbers in column A , B , C and D so i wanna highlight only one column which has greater value from others. is there any pos...
Date conversion in excel
Hello, how to convert birth date in word in MIcrosoft excel
Consolidate data from multiple sheets to one sheet.
Hello, I have a workbook containing customer data (name, contact #s, addresses, etc.). The workbook is broken down into sheets according to which ...
Auto update hyperlink on the other sheet
Hello guys =) Please help... I have a sheet with names and IDs which are in hyperlink and the same data i have also in the other sheet. If the I...
Excel if statement with multiple text values in a column
Hello, I am using excel 2017. I am trying to use this if statement to give me a value of 1 or 0. =IF((CQ2="Computer");1;0) The problem i...
Excel 2016 filters do not work
Hello, My filter stopped working in 2016. It is completely inactive - doesn't show any other option only the one it froze on. In the menu the filt...
Vba code to range of days
Hello, Please help guys... I have a code below: Sub Auto_Open() Dim r As Long For r = 2 To 53 If Range("I" & r).Value = Range("I...
Conditional formatting
Hello, If I have a value on one cell "D3"of let's say "2" and in cell F3 a value of let's say "1" then I want cell G3 to say a text, let's say "Good"...
Vba worksheet data transfer
hello, I haven't done anything with code for years and I am so lost in this, I have a table on sheet 1 which goes from A-J and 1-8221 and conta...
Run all vba at once after opening excel file
Hello, Please help me. I want to run the macros at once after opening the excel file. I have different codes in each sheet. Please i need yo...
Looking up 2 columns and displaying 3rd column on new sheet
I am trying to figure out how to display the color onto a second worksheet. If column a=1 AND column b=1, then I want the value of C2 displayed on...
Run a macro only for specific cells
Hello, can you please help me with one problem I am currently having with Excel Macro? I want to be able to run a macro only for specific cells .....
How to repair xlsx excel 2010 microsoft file?
ClosedHello, How to repair xlsx Excel 2010 Microsoft file? I see a file with non-zero size but cannot open it. System Configuration: Windows / Chrome...
Enter data into a master sheet to update subsequent sheets.
I'd like to be able to enter data into a master spreadsheet which will update other spreadsheets to prevent me from having to enter the same data seve...
Search and code
Hello, so I have this problem in excel where I need to compare the words that are in a certain cell and compare them to the separated word if it finds...
Macro code help - copy row based on criteria paste on one sheet
Hello, I have a spreadsheet that is tracking sales number from multiple sales people. Each person has their own tab & all the columns are the same...
Auto populating data
Hello, i have to daily update supplier name, part name , part number to my daily list . i want it to auto populate this to all my master-sheet , i ...
Formulas
I know the basic but I am trying to formulate cells that will automatically that when you enter a figure in the cell it will multiply that said number...
