The discussions
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...
I am facing problem after download the ms office 2010
hi ,, I am having a problem after download the ms office 2010.. it is not opening .. please tell me the solution .. ASAP
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...
Office 2007 files will not open
SolvedHi.. I am Dipu Michael from India. I am using the software office2007 in windows7.For the checking purpose I installed 0ffice 2003 in my system. Afte...
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 ...
Microsoft publisher 2010 ask product key,
ClosedI downloaded microsoft Publiser 2010 but now they ask product key, where can I find
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...
Replace 2007 office word
Hello, I have received an e-mail that my Office 2007 is being retired and I will need a new key. My computer is a Microsoft 10 system. Do you have a...
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...
Enter current time in a cell by clicking it
Solved/ClosedHello, I'm trying to minimize the effort to input data in a sheet I've built for recording time for dispatched workers I need to find a way to fil...
Powerpoint stop working
i have downloaded Microsoft office 2010 but unfortunately, power point is not working please help me
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...
Office 2013
Hello, i need office 2013 System Configuration: Windows / Chrome 60.0.3112.78
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...
Installing office 2010
ClosedHello, Downloaded Office 2010 for home and student but having problems installing. Please advise how to resolve the downloading problem. Tha...
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...
How to recover my important file of ms word
Hello, i was created one MS word document file in document folder, my windows was corrupted then i format disc c & install new win 7 but now...
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...
Automatically insert rows in associated spread sheets
Hello, I have created an accounting workbook of 15 sheets to produce accounts and associated information for a group of around 85 people. The names...
Formatting a cell containing text
I have a task tracker where once the task is completed and the 'hasten' cell is 'yes' then I want the entire row to be formatted so the text within th...
True or false value based on 3 difference cells' criteria
SolvedHello, I need a True or False (or Y/N) return if for example: A1>=30 AND B1>=80 AND C1>=80 but I have been unable to get IFS to work with t...
Copying rows with data from multiple sheets to one master sheet
Hi guys, I'm trying to figure out how to copy rows from multiple sheets with values in column Q to a master sheet. I have seen a set of codes a...
Saving input into 2nd worksheet while keeping the 1st empty
Hi there, Spoiler alert: Excel dummy I hope you can help me with this. I need to have a worksheet that would be used on daily basis and can be ...
Compare and separate data
Hi, I am obviously new to the forum here, but I came across a question kind of inline with my own on here and wanted to see if I could get some hel...
Acrobat reader gets the error
Hello! The problem is that: I downloaded a PDF fixe document, when read with Acrobat Reader gets the error: "an error Occurred while opening this docu...
Inventory master list help
Hello, So I have a workbook with an inventory master list that i would like to pull inventory numbers from all of the other sheets in my workbook....
Record scenario iteration results macro
Hello, I have a financial projection spreadsheet that will result in a residual value in a certain cell. I want to run 1000 iterations using a macro a...
Converting data in one column spanning three to four rows
dear sir i have an address book over 500 addresses in column A. i am not able to index the book alphabetically i need to shift the data in a2 of ...
