The discussions

If function: conditionally multiplying a value

 Solved

Ok so I am trying to create a formula that would use a different calculation based on an answer. So when I get the number 2 in a cell then the data us...

1 reply Last reply on 20 Dec 2021 by
TrowaD

If cell = date return yes or no.

 Solved

Hello, I need an excel formula that tells me if a a cell = a date to return yes or no. I tried =IF(I12=TRUE, Yes, No) and =IF(I12=DATE, Yes, No) ...

5 replies Last reply on 20 Dec 2021 by
ndwebb

Copy adjacent columns in excel if the id numbers same

 Solved

Dear all, I have ONE HELP in excel to copy two columns data( Qty & Amount ) from another sheet if the ID numbers are same.. I have created one...

1 reply Last reply on 13 Dec 2021 by
TrowaD

If cell contains multiple text how to add other cell value?

 Solved

Hello, I am struggeling with my excel sheet and need help. I will rather give it in an example. A1 and B1 contains a price, C1 contains three s...

1 reply Last reply on 13 Dec 2021 by
TrowaD

How to insert an image into an excel comment box (mac)

 Solved

Hi I'm on Mac with Excel 16.53 and I want to insert an image into a comment box. I read this : https://ccm.net/apps-sites/software/4079-how-to-i...

1 reply Last reply on 22 Nov 2021 by
TrowaD

Formula in excel to show amount in cell

 Solved

Hello, I need a formula that show the amount in another cell if some text is found in another cell. Like this; A2: 500 B2: Done C2: result t...

3 replies Last reply on 17 Nov 2021 by
vcoolio

How can i link optionbutton and textbox based on selected from combobox

 Solved

Hello, hi actually I got this codes from another web and mod some . it succeed and works , but my question how should link with the others tools ...

5 replies Last reply on 4 Nov 2021 by
TrowaD

Multiple if arguments

 Solved

Hello, I am trying to get Excel to look at data in two cells and depending on the combination it finds in those cells, record a different TRUE sta...

2 replies Last reply on 2 Nov 2021 by
Tim

Add missing data before total row after matching between two sheets

 Solved

Hello, I'm new begginer in vba and I hope some help I have data in two sheets . should match data beween them. the match depend in COL ...

5 replies Last reply on 18 Oct 2021 by
TrowaD

Code to move rows into another sheet based on certain values

 Solved

Hello, I've seen different variations on this question, but haven't seen any answers that specifically address moving rows based on multiple value...

3 replies Last reply on 8 Oct 2021 by
vcoolio

Cell value = sheetname to pull information from in excel formula

 Solved

I am trying to pull data from another sheet using the formula (located in B26) below, but I want to replace the sheetname ('9.60'! in this case) with ...

3 replies Last reply on 4 Oct 2021 by
TrowaD

Return seq values until blank value then return different set of seq values

 Solved

Hello, What is a formula to return a specific set of values in sequential cells until the reference sequence returns a blank value then start return...

1 reply Last reply on 30 Sep 2021 by
TrowaD

How deal with this complicated code and updating(subtraction between two sheets)

 Solved

Hello, I need help from experts to updating this complicated code . I know this way is very complicated to subtracting the item...

11 replies Last reply on 27 Sep 2021 by
TrowaD

I want to find date of joining

 Solved

Hello everyone i have a attandance sheet like this i want to find date of joining by formula. Mean on which date from 1 to 31 he started to work i w...

1 reply Last reply on 20 Sep 2021 by
TrowaD

Exporting action buttons into mp4

 Solved

Hello, I have created a powerpoint presentation with an action button to "click here to open a report". When I export the ppt to MP4 the butto...

1 reply Last reply on 19 Sep 2021 by
HelpiOS

How do i compare two worksheets where added value will copy to sheets3

 Solved

Hi, is it possible to get output as below where original in sheet1 and sheet2 will added 1 then in sheet3 it will sum the qty which previous qty is 2 ...

5 replies Last reply on 14 Sep 2021 by
TrowaD

How to rank the last top ten students

 Solved

Hello.. Am a teacher.am preparing results of 126 student.. So I need to find the last ten students among those 126.

2 replies Last reply on 9 Sep 2021 by
James07392

Vba code to copy worksheet multiple times and rename based on list

 Solved

Hello, New VBA user.. I have created code to copy a worksheet multiple times and rename based on a list in excel. However, I am receiving an e...

3 replies Last reply on 4 Sep 2021 by
rogerio

How can i change a cell daily

 Solved

Hello, I will try to explain the best I can, I have some cells 'A1, A2, A3, A4' that I fill up daily with numbers ex: -day1 I will input ...

7 replies Last reply on 30 Aug 2021 by
TrowaD

Shared content between 2 cells on 1 sheet and on 2 sheets

 Solved

Hello, I have cell 'A1' and cell 'B1' How cand I do a formula so I can tipe something in A1 and B1 is the same content, but I would like it bouth w...

3 replies Last reply on 30 Aug 2021 by
TrowaD

What will ms excel return when e2-f2 is entered in a cell?

 Solved

Hello, What will MS Excel return when E2-F2 is entered into a cell?

1 reply Last reply on 26 Aug 2021 by
TrowaD

Pop message into textbox on userform if number is exceeded

 Solved

hello I have userform contains multiple comboboxes and textboxes . the comboboxes1,2,3 should match with sheet data in COL B,C,D ...

13 replies Last reply on 24 Aug 2021 by
Hasson_6770

Merge data across multiple sheets in one sheet and calculate the values

 Solved

hi I have data in multiple sheets the same structure some sheets have duplicated data so it should merge and summing the value...

18 replies Last reply on 18 Aug 2021 by
kalilme

Grey out an entire row in excel 2010 depending on a cell's value

 Solved

Hi all, I am trying to grey out an entire row in excel 2010 depending on a cell's value. Each cell has a drop down list: Yes, No, Maybe etc ...

11 replies Last reply on 11 Aug 2021 by
T

Multiple mathmatical calculations for profit

 Solved

Hi, I'm trying figure out how to create a formula to calculate profit from a row with multiple options. column n*o=a column p=b column q=c co...

3 replies Last reply on 5 Aug 2021 by
TrowaD

Popup message when mandatory columns are not filled in a row in excel

 Solved

Hi All, Hope you are doing good! I want to popup an error message before saving. The requirements are for eg:- In this table, "Name & PhnNo" are ...

5 replies Last reply on 5 Aug 2021 by
TrowaD

If cell l2 has text in it return date in j2

 Solved

Hello, Can anyone help with this? I am designing a Task Tracker. The user wants a Date and Time to auotgenerate when Text is entered into a Ce...

3 replies Last reply on 3 Aug 2021 by
vcoolio

Copy automatically columns if the criteria is met

 Solved

Hello, I have simple workbook with 2 sheets. Sheet1 contains columns "Risk ID", "Risk" and "Response". Data would be for example ID1, "Cyber attac...

1 reply Last reply on 29 Jul 2021 by
TrowaD

Job boards?

 Solved

Hi, I am new here, just signed up today. There was an issue I was having with excel and found the solution. The solution was pasted exactly as ...

1 reply Last reply on 29 Jul 2021 by
TrowaD

Transfer data from one sheet to another based on an if/then condition.

 Solved

Hello there, I'm hoping to work with three lists (three sheets). First sheet, a master list, second sheet, a manager's list, third sheet, an emplo...

3 replies Last reply on 28 Jul 2021 by
vcoolio

Finding certain words in a cell and return a value based off the word found.

 Solved

Hello, I need to find a certain word in a cell in a column and return text based on the value. Example of this is if the word Apple is in a cell in...

1 reply Last reply on 26 Jul 2021 by
TrowaD

Letter changing

 Solved

Hello, how to Tamil pdf change to Word

1 reply Last reply on 26 Jul 2021 by
Elena Keracheva  

Excel macro/code help: creating sheet for each name in column of another sheet

 Solved

Hello! I am working on a project at my internship and ran into some issues finishing up some of the features I want to implement. The excel is a file...

21 replies Last reply on 22 Jul 2021 by
vcoolio

Conditional formatting (office 2016)

 Solved

Hi Guys I want Excel to highlight cells(in a column) based on the value(text) I select from a drop-down list in another column. So each time ...

7 replies Last reply on 22 Jul 2021 by
vcoolio

I have a '0' that need's to be gone

 Solved

Hello, I have a file with two sheets. In sheet2 I have cell A1 ='sheet1'!A1 (when I type something in cell A1 from sheet1 it's goes on A1 from shee...

3 replies Last reply on 21 Jul 2021 by
vcoolio

How can i make the 'false' statement remove if blank

 Solved

Hello, I have this simple formula =IF(J15"",J15-H15) I have that formula alocated to G8 and I want it to work only when I type something ins...

3 replies Last reply on 21 Jul 2021 by
Mazzaropi

Help with wps to docx files

 Solved

Hello, I tried to save a wps file from cloud that was sent to me. Now, I have a problem with downloading it as a docx file. Do I need to download it...

2 replies Last reply on 20 Jul 2021 by
Zimmermem

Excel if range of cell contain a text put a cell value in

 Solved

Hi All, How do I put a cell value into a cell when the range of cell contain a specfic text. For example, in the sample below, I want to put the ...

11 replies Last reply on 13 Jul 2021 by
TrowaD

Formula in excel for a date

 Solved

Hello, Hope you are well. Please assist me with the date calculation in Column E and Column F. The 2012/02/29 date should show (29) because for tax ...

3 replies Last reply on 13 Jul 2021 by
TrowaD

Change cell list values when another cell is changed

 Solved

Hello, My calculations would go a bit further, and i don't really know if my issue can be solved by excel. I have multiple lists for speaker box...

6 replies Last reply on 5 Jul 2021 by
Rolnaashch

Conditional formatting another cell based on text in a range

 Solved

Hi I have a spreadsheet where columns A,B,C contain text (a subject studied at school) e.g. Maths, Science, Geography. I have 170 rows of this data...

1 reply Last reply on 1 Jul 2021 by
TrowaD

Finding file names in a local folder

 Solved

Hello, I have a large list of file names in excel worksheet. I am trying to find which of those files are NOT in the folder on the local drive...

3 replies Last reply on 29 Jun 2021 by
TrowaD

Vba: use password to go to sheet

 Solved

Hi, I have a spreadsheet that is driven by VBA buttons that take you to different sheets, I need to password protect some of the sheets, but if an inc...

1 reply Last reply on 21 Jun 2021 by
TrowaD

Auto increase invoice number in this format "te/2021-22/102"

 Solved

Hello, please tell the vba code for increase invoice number to 103,leaving others same on opening worksheet

17 replies Last reply on 8 Jun 2021 by
TrowaD

Command button launches default browser via one line of vba code

 Solved

I have a userform that allows me to use a webbrowser within it, however sometimes due to compatibility issues I need to use microsoft edge and use it ...

1 reply Last reply on 3 Jun 2021 by
TrowaD

Macro to compare 2 columns and output list with singles and sheet reference

 Solved

Hello, I am trying to write a macro to compare two different columns on two different sheets. and I want to print only the values that are not on ...

1 reply Last reply on 1 Jun 2021 by
TrowaD

How to split the amount in excel formula or excel vba code?

 Solved

Dear All, Hope you are doing well!. I would like to copy the value in cell based on user input value. Below is the sample screenshot. The use...

1 reply Last reply on 31 May 2021 by
TrowaD

Conditionally formatting if another column contains a specific date

 Solved

Hello, I have a spreadsheet where I am tracking requests. I want Excel to highlight the row if the item due date (column B) is NEXT month or has P...

1 reply Last reply on 27 May 2021 by
TrowaD

Moving the data into previous cell by using excel formula or vba code

 Solved

hi all, I am working as Master data analyst. While working with data I got a problem, I have almost 10,000-row lines each having multiple col...

1 reply Last reply on 7 May 2021 by
vcoolio

How to copy cell value from one table to another table with criteria

 Solved

Hi, Please help me with the below request. I would like to Copy the data from table1 (sheet1) to table2 (sheet2) based on the criteria "Yes" aut...

4 replies Last reply on 5 May 2021 by
vcoolio
Results 51 - 100 out of a total of 2,603