The discussions

Adding last week position to a weekly record survey

Hello, I am compiling weekly record charts of the most popular records. How do I add the last week position to each song on each new record list in E...

1 reply Last reply on 16 Jan 2023 by
TrowaD

How to pull data from column based on multiple criteria?

Hi Expert, I'd like to combine a column value in Mainsheet, where the column values are pulled from Sheets 1 and 2 of the same Excel file using VBA c...

3 replies Last reply on 16 Jan 2023 by
TrowaD

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...

3 replies Last reply on 27 Dec 2022 by
TrowaD

How to calculate positions (1st,2nd,3rd...) in excel

 Solved

Hello, 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...

6 replies Last reply on 12 Dec 2022 by
TrowaD

How to convert the tamil pdf file to tamil word file

 Solved

plz give the solution

12 replies Last reply on 10 Dec 2022 by
karthik

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...

2 replies Last reply on 21 Nov 2022 by
TrowaD

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...

1 reply Last reply on 21 Nov 2022 by
TrowaD

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 ...

1 reply Last reply on 21 Nov 2022 by
TrowaD

I can not control the transitions in powerpoint in my file,

 Solved

Hello, 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...

2 replies Last reply on 9 Nov 2022 by
Pablo453

"enter to add a blank slide" doesn't work anymore

 Solved

Hello, 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...

1 reply Last reply on 8 Nov 2022 by
TrowaD

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...

4 replies Last reply on 8 Nov 2022 by
TrowaD

Coloring cells in sheet 2 based on data sheet 1 excel vba

 Solved

Hi!  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 ...

4 replies Last reply on 4 Nov 2022 by
Sue-Ellen1994

Udf for attendance register

 Solved

Hello, 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...

2 replies Last reply on 3 Nov 2022 by
Slinger42

Formula to find last date of attendance

 Solved

Hello, 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...

3 replies Last reply on 3 Nov 2022 by
TrowaD

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 ...

1 reply Last reply on 1 Nov 2022 by
TrowaD

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...

4 replies Last reply on 19 Oct 2022 by
starctony

How sum the column value in excel via vba based on criteria?

 Solved

Hello 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...

2 replies Last reply on 10 Oct 2022 by
TrowaD

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...

14 replies Last reply on 29 Sep 2022 by
Eagleeyes011

How to barring outgoing call in lava keypad

Hello, How to barring outgoing call in lava keypad mobile? 

1 reply Last reply on 29 Sep 2022 by
Agavery89

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...

18 replies Last reply on 23 Sep 2022 by
Peter

Unable to reply to emails

 Solved

Can someone advise me how to conquer this sudden difficulty? Emails arrive, I can read them, but when I click "Reply" nothing happens. Why? Than...

2 replies Last reply on 23 Sep 2022 by
Peter

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: ...

6 replies Last reply on 23 Sep 2022 by
Peter

Office 365 product key

 Solved

Hello, Hello. How to activate Office 365 product key. I couldn't do it :)

1 reply Last reply on 21 Sep 2022 by
HelpiOS

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...

5 replies Last reply on 18 Sep 2022 by
MLloyd81

Prn convert to pdf

Hello, how is convert prn format file System Configuration: Windows / Chrome 60.0.3112.113

2 replies Last reply on 13 Sep 2022 by
Peter

How to convert the tamil word doc to tamil pdf?

Hello, How to convert the Tamil Word doc to Tamil PDF? Regards Jebasingh

3 replies Last reply on 13 Sep 2022 by
Peter

Apply conditional formatting across several cells

 Solved

Hello, 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...

2 replies Last reply on 12 Sep 2022 by
rdavis

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...

1 reply Last reply on 12 Sep 2022 by
TrowaD

How to add rows automatically based on cell value in excel?

 Solved

Hi 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...

7 replies Last reply on 12 Sep 2022 by
TrowaD

Populate values in textbox based on combobox ,optionbutton

 Solved

Hello, 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...

6 replies Last reply on 9 Sep 2022 by
Mussa_8911

Running a macro in different cells

 Solved

Hello, 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 ...

4 replies Last reply on 5 Sep 2022 by
Helmy

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...

2 replies Last reply on 27 Aug 2022 by
Jameswalter2050

How to convert excel to pdf in tamil font

Hello, how to convert excel to pdf in Tamil font

1 reply Last reply on 27 Aug 2022 by
Jameswalter2050

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...

2 replies Last reply on 27 Aug 2022 by
Jameswalter2050

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 ...

1 reply Last reply on 25 Aug 2022 by
TrowaD

Generating invoice number automatic without repetition

 Solved

Hello, 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...

3 replies Last reply on 25 Aug 2022 by
TrowaD

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

2 replies Last reply on 18 Aug 2022 by
Peter

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)

1 reply Last reply on 18 Aug 2022 by
Peter

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...

1 reply Last reply on 16 Aug 2022 by
TrowaD

Macro to automatically update a master sheet from multiple sheets

 Solved

Hello, 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...

17 replies Last reply on 16 Aug 2022 by
TrowaD

Working with multiple worksheets in a workbook

 Solved

Hello, 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 ...

7 replies Last reply on 11 Aug 2022 by
vcoolio

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 ...

1 reply Last reply on 23 Jul 2022 by
abdelfatah_0230

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...

3 replies Last reply on 19 Jul 2022 by
vcoolio

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...

1 reply Last reply on 14 Jul 2022 by
vcoolio

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...

1 reply Last reply on 13 Jul 2022 by
HelpiOS

How to lock in specific cells in a formula going down rows

 Solved

Hello, 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(...

2 replies Last reply on 27 Jun 2022 by
JoshL

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...

1 reply Last reply on 27 Jun 2022 by
TrowaD

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...

1 reply Last reply on 21 Jun 2022 by
TrowaD

Hello friends. please help ! countif formula ?

 Solved

Hello 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"...

3 replies Last reply on 13 Jun 2022 by
TrowaD

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...

1 reply Last reply on 10 Jun 2022 by
vcoolio
Results 51 - 100 out of a total of 12,267