The discussions

Create and populate sheets based on values in master list

I have seen a few similar forms but cannot seem to achieve the functionality I'm hoping for. My workbook will have a master spreadsheet that is per...

3 replies Last reply on 6 May 2022 by
vcoolio

Formula to compare 2 columns and count missing values

Hello, I have an Excel spreadsheet where I want to compare values between two columns A and b and to see if any values are missing in column b. ...

2 replies Last reply on 5 May 2022 by
rizvisa1

Email notification when cells in a column are changed

Hello, I am trying to set up a macro to send an email when a cell changes in a certain column in excel. I used a conversation in this forum that g...

1 reply Last reply on 5 May 2022 by
rizvisa1

Conditional format b1 based on a specific word in a1 & calc

Hello, I would like to check how to use the conditional formatting to get a colored cell in B1 containing numbers (based on a "INC VAL" in Cell A1...

4 replies Last reply on 3 May 2022 by
Sorrow81

Summing values based on matching column across sheets

 Solved

Hello, Hello, I would match data across sheets based on matching columns B then should add & summing the values to sheet summary under heade...

6 replies Last reply on 26 Apr 2022 by
leapout

How to copy data after at a fixed cell

 Solved

Hello, I have the following data for which it needed to be copied on another sheet after a gap of 7 cells for each entry in Sr No. column. Li...

2 replies Last reply on 13 Apr 2022 by
skprma

Keep track of customers service visits

Hi All, I need help in keeping track in excel of the customers service visits. I have customers that are visited weekly, some twice a month, most of...

1 reply Last reply on 11 Apr 2022 by
TrowaD

Comp. value in 2 columns against a list and disp. text in 3r

Hello, I need some help as I cant figure out how to construct this. I have been using a combination of IFS, AND, & VLOOKUP functions but I cant se...

1 reply Last reply on 11 Apr 2022 by
TrowaD

Excel formula for filling another cell

I have four columns in excel. Column A is named "Date" while Column B is named "Day". Column B depends on the value in Column B and I got the Formula...

1 reply Last reply on 7 Apr 2022 by
TrowaD

How to calculate aggregate of student's marks

In creating an excel app to calculate the aggregate for students in their exams as used by WAEC to determine the student aggregate in BECE . The Excel...

2 replies Last reply on 23 Mar 2022 by
Wofanat

Conditional formatting in sheets rows based on text in cell

Hello, I have looked through some past answers and have not found a solution yet; I am trying to apply conditional formatting to a sheet where if te...

1 reply Last reply on 7 Mar 2022 by
Mazzaropi

Code to move rows into another sheet based on certain values

I found this lovely little script on this forum. It has worked flawlessly. I have a spreadsheet with multiple pages and I would like this code to work...

6 replies Last reply on 5 Mar 2022 by
vcoolio

Macro: change cell color based on value in another cell

Hello, I'm am trying to fix a spread sheet at work but what i need is a macro that i can run to do the following if the word Traffic appears in...

1 reply Last reply on 3 Mar 2022 by
TrowaD

Autogenerate alphanumeric id numbers in excel?

 Solved

Hiya! Let me start off by saying I am NOT a tech person so I don't even know if this is possible. I am trying to create an excel sheet where I can ...

3 replies Last reply on 2 Mar 2022 by
vcoolio

Search across all open workbooks for user defined criteria

 Solved

Here is my problem - we store info into files that use an index number (changes with each file created) plus 2 criteria to keep track as we produce ma...

5 replies Last reply on 1 Mar 2022 by
TrowaD

Auto-fill items repeatedly for two sheets based on another

 Solved

Hello, I have two sheets(FIL1,FIL2) should auto fill some items into column A repeatedly . it depends on sheet REP after matching based on colum...

3 replies Last reply on 24 Feb 2022 by
TrowaD

Copying a row based on a integer in a cell

 Solved

Hello, I am needing help making a macro that will allow me to do a number of things, that may or may not be able to be done with one single macro. (...

5 replies Last reply on 24 Feb 2022 by
TrowaD

Automatically creating code like otp

Hello, I want to make some automatically code or number against once I enter data in cell. I mean it's like OTP number . It's not necessary that it'...

1 reply Last reply on 17 Feb 2022 by
TrowaD

How split column into multiple columns for multiples sheets

 Solved

Hello, I need macro to split column C for sheets REP1,PROC1 into columns C,D,E based on matching column B with column B into sheet RP ...

6 replies Last reply on 15 Feb 2022 by
Hasson_6770

Userform vba excel. saving data depending on the parameters

Hello, I created a UserForm through Excel VBA with the data text input which contains dates (ex. 2015,2016 etc.) I need this data to be put into d...

1 reply Last reply on 8 Feb 2022 by
TrowaD

Reference and tranpose cell information

Hello, I am trying to get get the formula in SHEET 2 ROW 3 to copy the data from SHEET 1 COLUMN D. I tried to just copy and paste or copy and dra...

1 reply Last reply on 8 Feb 2022 by
TrowaD

Match & add missed items between two sheets

 Solved

Hello, I have two sheets contain the same structure of data . the result should show in column B,C into sheet2 based on matching with sheet1 . ...

12 replies Last reply on 8 Feb 2022 by
TrowaD

Copy row and insert based on value in column

I have never used macros before! I have a spreadsheet where I need to duplicate rows based upon a quantity in a column. For example, Row 1 has a value...

1 reply Last reply on 7 Feb 2022 by
TrowaD

Unable to send/receive emails in outlook 2016 after setting up outlook 365 ?

Any suggestion?

2 replies Last reply on 3 Feb 2022 by
petergroft

Best way to open archive pst files

Anyone........

2 replies Last reply on 3 Feb 2022 by
petergroft

How to add rows that meet specific conditions

 Solved/Closed

Hi Every week at work we get data about new jobs that have been completed at our company, and I add that data to a raw data tab. In the summary tab...

Last reply on 28 Jan 2022 by
vcoolio

Export office 365 mailbox to pst

Hello, Anyone can provide manual methods to export my Office 365 mailbox to Outlook PST? Else, do I have to do it by using third-party software...

1 reply Last reply on 27 Jan 2022 by
petergroft

If then excel

Hello, If AA cell says not recorded, I need AB, AC, and AD to be shaded in red. I’ve read multiple forums and unable to find help for this. ...

1 reply Last reply on 23 Jan 2022 by
vcoolio

Changing values in one cell depending on drop down

 Solved

Hello, I created a drop-down list of scores (ie. 10, 20, 30 to 100) in cell A1. In cell B1 I want it to show a specific number value based on which...

3 replies Last reply on 21 Jan 2022 by
vcoolio

30 days prior date popup notification

Hello, I've currently done condition formatting on the expiry date column to turn RED 30 days prior to expiry using formula =AND($H2>TODAY(),$H2-TOD...

5 replies Last reply on 19 Jan 2022 by
vcoolio

Start and stop counting at the zero value

Hello, How to insert a COUNTIF function to count values once it reaches to the first zero value to stop. And count again the cells between the first...

5 replies Last reply on 13 Jan 2022 by
TrowaD

Excel macro: compare 2 sheets and create result sheet

Hello, I have two excel spreadsheets, spreadsheet 1 a sheet that list device names, spreadsheet 2 has device/machine name and custodian. Need to ...

1 reply Last reply on 11 Jan 2022 by
TrowaD

How? transfer columnar totals only from 1 sheet to another?

Sheet 1: several columns of #s, each column totaled. I want to transfer the columnar TOTALS ONLY that were the result of formulae to Sheet 2. How do ...

1 reply Last reply on 10 Jan 2022 by
vcoolio

Trying to build a weekly sales comparison

Hello, I built a workbook that has as 8 weeks of of sales data. Each week contains the items that were sold with the quantity and and how much re...

1 reply Last reply on 10 Jan 2022 by
TrowaD

Conditional formatting: change fontcolor based on another cell

 Solved

Hello, I have "text" in cell B1. However, I want the font color to change based on the numerical value in cell B8; so if the number in cell B8 ran...

18 replies Last reply on 3 Jan 2022 by
Ravi

Excel formula with changing rows going in order

 Solved

I am mapping one cell to another spreadsheet and I trying to figure out how to change the row without having to manually change each line. For example...

1 reply Last reply on 3 Jan 2022 by
TrowaD

How do i fix outlook error 0x800ccc0f?

 Closed

Hello, I am facing the Outlook Error 0x800ccc0f issue while incoming or outgoing MS Outlook messages. Please help me to resolve this error.

Last reply on 28 Dec 2022 by
Somit0

Macro to copy row based on condition

Hello, I need to set-up a macro to copy rows from Sheet 1 to Sheet 6 based on data in column 'AS' (If data ="Yes" the row is copied over) I nee...

1 reply Last reply on 23 Dec 2021 by
TrowaD

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

Excel formula if

Hello, Can someone help me? I want a formula to show OK if the cell beside it have some value. Example: A1: to be filled with D.O number (will o...

1 reply Last reply on 16 Dec 2021 by
TrowaD

Use count and find number of certain item

Hello, Use Count and Find number of certain items within a field range

1 reply Last reply on 13 Dec 2021 by
TrowaD

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

Pdf editor for desktop like xodo pdf but with keyboard shortcuts for editing?

Hi! I am looking for: -A FREE PDF editor -For Desktop (Windows 10) -I use Xodo pdf and it is really good but it does not have shortcuts for ed...

5 replies Last reply on 10 Dec 2021 by
Ankit07

Generating new file with multiple sheet template

Hello, I have a file that is currently generating new files based on a template file + a list of names. The problem is that the file is generat...

1 reply Last reply on 28 Nov 2021 by
vcoolio

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

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

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

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

Microsoft word scroll bar issue

The vertical scroll bar disappeared in word. I now have a horizontal scroll bar at the bottom and it turns document pages. The wheel on the mouse is a...

1 reply Last reply on 9 Nov 2021 by
TrowaD
Results 101 - 150 out of a total of 12,264