The discussions
Copy a data from one sheet to another
I have a Master list (Sheet 1) that contains house numbers and personnel assigned to them. I want to copy the entire row with the data assigned to eac...
How to calculate positions (1st,2nd,3rd...) in excel
SolvedHello, hi sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...i...
Formula to return text
I need to have a formula to return text from text. I will give example; If column A = 7am then I want column B to say Days If column A = 3pm then I...
Create christmas present schedule
Hello EXCEL GENIUSES OF THE WORLD! I am trying to save my entire family money and a feeling of obligation to buy a gift for EVERY DANG KID in our fam...
Formula to recognize fical year to reset paid days off
Hello, I am trying to make a formula that will choose certain rows from each month in a calendar year that have hours in them, subtract from a total ...
I can not control the transitions in powerpoint in my file,
SolvedHello, the slides of my PowerPoint moves before the first slide finishes, and sometimes it takes ages to move to another slide. I would like the sli...
"enter to add a blank slide" doesn't work anymore
SolvedHello, I used to be able to add a blank slide in PowerPoint by simply pressing the "Enter" key. For some reason, I found this function did not work a...
Compare 2 columns to find the 3rd value and return the 4th
Hello, Here in my example, if value in Column B (table 2) matches with the value in column A (table 1), then I need to check the first row corre...
Coloring cells in sheet 2 based on data sheet 1 excel vba
SolvedHi! I would like to ask a question about using VBA for colouring a cell in sheet 2 based on a value of a cell in sheet 1. I want to write a code in ...
Udf for attendance register
SolvedHello, I have used your UDF as shown below to report a date whenever an entry is made in a row of my excel sheet. Function LastAttendanceDate(mDate...
Formula to find last date of attendance
SolvedHello, I have an excel sheet that enters the time taken by each student on each day for the whole month. The student names are in the rows and d...
Excel filter some data from other two sheets and copy back
Hi, I have some query related to excel where i have to get some results as described below: Excel Sheet 1: Excel Sheet 2: Excel Sheet ...
Compressing pdf files
Hello, I have about 20 pdf forms i need to send in 1 email.............how on earth do i make them all small enough to attach please? C...
How sum the column value in excel via vba based on criteria?
SolvedHello All, I would like to sum up the column value based on the following criteria (TRUE or FALSE). I have a value in the "E" column and in the "F" c...
Basic copy/paste, multiple sheets and databases
Hello all! I’m not good with this, so I’m am reaching out to those who are. I can record and run basic macros, but this is above my skill level. I’ve...
How to barring outgoing call in lava keypad
Hello, How to barring outgoing call in lava keypad mobile?
Outlook 2003 suddenly emails are not sending
Running WindowsXP, Outlook 2003, RoadRunner ISP, AVG Security. Two days ago, my emails stopped being sent. I am able to receive okay. On my side it lo...
Unable to reply to emails
SolvedCan someone advise me how to conquer this sudden difficulty? Emails arrive, I can read them, but when I click "Reply" nothing happens. Why? Than...
I can receive email but cannot send from outlook 2007
Hi 2 days ago the outlook 2007 stopped sending emails and the following error was shown when I tested account settings: Send test e-mail message: ...
Office 365 product key
SolvedHello, Hello. How to activate Office 365 product key. I couldn't do it :)
Find text in multiple cells and return different text
Hello, I am a teacher trying to find an alternative to manually entering data for single children and a way of simply analysing it. I have created a...
Prn convert to pdf
Hello, how is convert prn format file System Configuration: Windows / Chrome 60.0.3112.113
How to convert the tamil word doc to tamil pdf?
Hello, How to convert the Tamil Word doc to Tamil PDF? Regards Jebasingh
Apply conditional formatting across several cells
SolvedHello, I want to change the color of a row if there is text in column A of that row. I have the following equation: "=AND(ISTEXT($A$2))" ... and I h...
Formula for outputting value from dropdown list
Hello, I need assistance with finding a way to output the value of cell based on the text it's associated with in a drop down list. Below is a scre...
How to add rows automatically based on cell value in excel?
SolvedHi All, I have a requirement to add the Rows Based On Cell Value In Excel. Below I have attached the snapshot of the requirement details. I have two...
Populate values in textbox based on combobox ,optionbutton
SolvedHello, I have the items in column B in sheet1,2,3 and the prices in columns F,G for sheet1,2 and the prices for columns F for sh...
Running a macro in different cells
SolvedHello, I have a question. I recorded a macro to average a series of columns, highlight the averages row in a bold color. I would now like to run the ...
How to extract text from column that got text
Hello, I would like help on how to extract text from column which has text. Some column might not have text or blank, want to know how to extract th...
How to convert excel to pdf in tamil font
Hello, how to convert excel to pdf in Tamil font
How to speedup formula processing
I have been using this formula which macthes the List of Cells to Raw String and if match found then write same value. This function is working fin...
Absolute reference from another sheet is not working
I have my First Sheet as an Index sheet with titles of topics and another neath each title i have my latest update which is pulled from another sheet ...
Generating invoice number automatic without repetition
SolvedHello, please I need help , I want VBA CODE to Generating invoice number automatic without repetition in my excel any time type in the next cell it...
Email sent undeliverable 550 error
I receive emails through Outlook with out problems but get undeliverable messages with 550 error when replying and/or sending
Office 365 error was deleted message without beaing read
hi I have office 365 when tracking the read receipt getting an error randomly not every time(was deleted without being read)
Pasting a column into alternating rows in new column
Hello, i have a column of ID numbers and a column of names next to it, I want to copy and past the names with their corresponding id in cell under the...
Macro to automatically update a master sheet from multiple sheets
SolvedHello, I have a file with a master sheet and 6 different individual sheets. Each sheet is considered a project. It includes person's information a...
Working with multiple worksheets in a workbook
SolvedHello, I am completely new to all of this so please bear with me. I am new to forums and how they work so I apologize in advance if this is a repeat ...
Compare 2 columns if it matches all columns must go tosheet2
Hello, Thank you for putting the time aside to help me. There are 2 sheets, Summary and Journal. Step 1: In the Summary sheet, I added Column E to ...
Master sheet to auto populate from multiple sheets
hello! could someone kindly assist me with a formula or a macro that will auto populate/update the master sheet using information from sheets A-E. t...
Move rows to another sheet based on values in column a
Hello, I am trying to have rows in sheet "KEY" automatically moved to sheet "INACTIVE DRIVERS" if the cell in column A is "Inactive". I have looked...
When i want a letter in capital ex: é, i got always éé
Hello, for exemple "É" (Alt + 0201) I got always the double ÉÉ, and the second letter replaces any bouton. Ex: "E-X-P-É-D-I-É", I use the normal...
How to lock in specific cells in a formula going down rows
SolvedHello, I am having an issue with easily repeating a formula I've made. the formula is =IF(AP2=Sheet2!K3,Sheet2!L3,IF(AP2=Sheet2!K4,Sheet2!L4,IF(...
Google sheets formula
I need to search column D for "Text 1", then if its true, any row that has it, take the data in column B(same row) and enter it into another cell. for...
Counting and stop counting in a cell
Hello, I need to create a formula for a cell involving number of days between dates. A2 - start date B2 - lead time C2 - end date D2 - showi...
Hello friends. please help ! countif formula ?
SolvedHello friends. Please help ! I want a formula ( maybe COUNTIF? ) to count how many "W" and "D" and "L" are found per each range: "B3:B12", "D3:D12"...
Highlight cell if another cell contains specific text
Hello, I have random text in cell C6 that I would like to highlight green if cell N6 has 'yes', red if cell N6 has 'no', and grey out if cell N6 h...
Change cell color of all cells in my formula
I often have huge spreadsheets where I have to add random cells together. In order to make sure I don't miss any cells, I want to change the color of ...
Excel formula to check if cell contains a date
Hello, Hi, I am trying to write a formula to check if there is DATE value in a particular cell. If there is a DATE value, need to say "DELETED...
