The discussions
Excel - macro to create multiple sheets
SolvedHello, I have 16 sheets in excel. each of those represent a location (office) and they need to pull information from sheet1. This is for credit ...
Comparing columns and returning value
Solved/ClosedHello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: Column: A...
How do i calculate vat inclusive
Hello, how do i calculate VAT inclusiev? for example, TZS 849235 is vat inclusive, how do I take out the VAT? Taking VAT as 18% System Configur...
How can i get my cvs out of my old office
Hello, how can I get my cvs out of my old office System Configuration: Windows / Edge 14.14393
Change of date
Hello, I Want to change date format mm/dd/yyyy to dd-mm-yyyy in MS Excel 2003 Please solve my problem urgently System Configuration: Windows ...
Import .pdf ...?
SolvedHello everybody, Thanks so much for this thread, it has been extremely helpful! I have used the basic code suggested by Trowa, and it works for...
Highlight date range if cell containing date falls within that range
Good day! I have a list of static date ranges and would like to highlight a range if a date occuring in that range populates in a different cell....
Freezing column and row
Hello, how do you freeze first column and top row in excel?
Lotus sympony to word
FILE FROM LOTUS SYMPONY COULD NOT BE OPENED IN MICROSOFT WORD WHAT TO DO
Change a cell content according with the color of another cell
Hello, I´m using Excel and need to change the VALUE of a cell (need to appear "-") if the COLOR of another cell is PURPLE. After digging around wit...
Pasting and deleting macro
Hello, I need to create a macro that paste macro buttons from one spread sheet to another spread sheet, but when I try to do this and assign the mac...
Nestle fomula nightmare!!
Sorry - fixing mini typo Hello - any help!! Going bald ripping hair out trying to resolve! I want to return a value "Q1" if a date falls between...
Need help on excel macro
I need help to create a macro which helps me to get data from 'Sheet1' and paste that number of counts in 'Sheet2' for example, i have a table in s...
Edate in excel help
Hello... I have a training for log for a large number of staff for various different courses which have all been completed at various different dates ...
Excel for mac date formatting
Hello, I have two columns one for the month/day and one for the year. When I formatted the month/day column it automatically adds the year in whi...
Format excel data
Hello, i need to modify the data in my excel. Right now the data looks something like this: case A start 51 stop 55 ...
Copy rows from one tab to another - if specific criteria in col
Hello, In a file, I am trying to copy data from one row of a worksheet if specific criteria are met in one column to another worksheet. Ex: ...
Formula
SolvedI need some help with a formula, everything I try just doesn't work. I usually don't have this problem with Excel today is my day. I have a colum...
Help for time reminder in excel
Hello, I entered some date in excel and I need to be reminded one day before that expected date !! How do I code it so that I will get a reminder ...
Graduate number in a cell
Hello, I have this database on Excel that I want to create. One of the columns will have the date of birth (DOB) and another column will have the...
Software for finanicial
how can i get a software for account system tally ,quickbook
Countif coloring of cells that were used.
Hello, I would like to color cells (or a row) that were used for "countif" values. for example, at my work, i have to indicate private calls f...
I cant get rid of the false function
Hello, I don't know whats wrong with this formula =IF(C4="Single",K4*1, IF(C4="Twin",K4*2, IF(C4="Quad",K4*4))) It keeps saying false in the ce...
Microsoft word icon changed to unknown program
My Microsoft word (program) icon changed from the classic picture to the unknown programs icon. I am using windows 7 enterprise. Please help me how to...
Automatically copy contents from multiple shts to a summary sht.
Hello, I've an appointment sheet for each client of mine with their details. lets say like 50 sheets. I'd like to create a summary sheet from all ...
Excel codes
Hello, I would like to be able to set up a spread sheet so when I type March on sheet1 in column A it copies the entire row onto sheet 2
Vba code
Hello, sir , i am trying to copy data from one row and paste that data into column of another sheet. this process is continuous till all row no...
Cell color count with a condition
Hello, I need a help. I need to count cells in a range having a specific color (In one column) & cells in a range having a text (In another co...
Conditional formatting based on two cell values
SolvedHi There, I'm using Excel 2016 and am trying to apply a conditional format that searches cells in column A for the text "*DEMO*", and also has a c...
Copying cond. format for entire row based on 1 cell to other row
SolvedI have conditional formatting for an entire row based on the value of 1 cell. For example: cell value>$A$2 = red, cell value
Create separate worksheets/excel files
Hello, I need to create an excel file with the following I have a base file and a summary sheet I need to create separate sheets and rename them...
Macro to compare two excel file
Hi Team, I need excel macro to compare two excel file and highlight the difference in the respective cell with both the values in file 1 and 2 .
Drop down lists
SolvedHi All, i have a drop down list in excel and the data for the list in a sheet in the same workbook. If I copy the spreadsheet with the list to anot...
Excel combine worksheets into one
Newbie here, I have a question on how to do this in excel. I have lots of worksheets, 200+, each with different names, and I was wondering if its p...
Removing false value
SolvedHello, I would like to know how to remove the "False" Value when if function is nested. Here is an Example =IF(G23=0,P15/Sum(D11:F11,IF(G23>0...
Copy rows to other sheets based on value in column
SolvedAll, I have an Excel file with three sheets: Sheet1 contains all my data. Sheet2 named "MACH" and Sheet3 named "FAB" I am looking for a way with a...
Automatically save data to another excel sheet.
Hello, System Configuration: Windows / Chrome 57.0.2987.110 Please give me suggesstion & Advice to my query, Whenever I enter date in Ex...
Pdf file alwasy opening in word
SolvedHello, What to do to disable my attachment file in pdf to open in Word application?
How to calculate values using countif
I have 2 sheets sheet1 is a Summary sheet and sheet2 is data sheet sheet 2 has columns from A TO R, in that column G is Severity (heading) wit...
Trying to create a multi-column formula.
SolvedHello, I need help making a formula. I will do my best to describe. The letters (A-I) refer to separate columns. A-B=C to be divided by D the res...
Two excel sheets copy new data input on one sheet to new row on
Hello, I have an excel spreadsheet that I have to update periodically overwriting old data. I have another sheet where I need to update the same inf...
Need to extract data from a column to another worksheet.
Hello, I need code to extract all data containing a name from a column on sheet1 and copy it to Sheet2 and remove all blanks. The name is pulled fo...
Excel problem
SolvedHello, I want a formula in which, If I enter the number in cell, the name of that number should appear in adjacent cell. Ex: Emp No Name 1 ...
Recover user id of irctc
SolvedHello, recover irctc user id , i forgot it , so help me Configuration: Windows / Chrome 53.0.2785.101
Help with index match or vlookup
Hello, I have a worksheet with about 2000 rows. In column C and Column J i have a common Key. In Column K I have data that i want to write to Colu...
Password detail
how can i get the password of ms word installed in my system it keeps telling requesting for password dont know how to go about it can someone please ...
Excel find word in series of cells and add
SolvedHello, My colleague wants to has a spreadsheet with many columns and rows. The spreadsheet setup is something like this: Cells under column A ha...
Highlight one value in a dropdown menu of three responses
SolvedHello, I have a template where we are asking for responses with a drop down that includes Y, N, and N/A. We want to highlight all N answers in yell...
Create new excel files based on the data in a column
Hello, I've spent hours searching and trying different macros with no avail. I'm not new to excel, but new to macros and coding. I have a spreadshee...
Code to move rows into another sheet based on certain values
SolvedI'm having trouble figuring out how to do something! I have a sheet (Sheet1) with customer details on it (columns A-D will have data in). I want to be...
