## The discussions

### If statement

Solved

Hello, I am really struggling to get the correct formula for below situation: example: Cell A2 is a "due date" Cell B2 is a "completion date" ...

4 replies Last reply on 30 Aug 2019 by
ac3mark

### Dynamically assign a number in data set

Hello, I have a large data set and need to assign a number to each row if the status changes. Is there a short cut / dynamic way that I can assign...

3 replies Last reply on 29 Aug 2019 by

### Transfer data from userform to sheet with the same format of table

hi, experts i have userform contains 3 textbox and sheet1 contains table i designed from 3 columns i would every time when fill data in userform ...

7 replies Last reply on 28 Aug 2019 by
ac3mark

### How to find the latest time per name in a table with names and times

Solved

Hello; I have a sheet with a list of "use name" and "time" (which is a login date). I need to find for each user the latest date . But users have sev...

11 replies Last reply on 27 Aug 2019 by

### Need to create linked sheets

Hello, I have an excel sheet this is for a list of unavailable items however I need to create another sheet for 1 specific team. So my sheet is lik...

8 replies Last reply on 26 Aug 2019 by

### Sumproduct based on wbs

7 replies Last reply on 26 Aug 2019 by
ac3mark

### Interest on term loan and working capital

Solved/Closed

Dear CCM, I dont know "interest on term loan and working capital, profit before taxes and profit after taxes""..etc anybody can help me to solve...

Last reply on 24 Aug 2019 by
ac3mark

### Get help macro sheet

Hello, My name is vivekanandan i am try to create macro sheet like compare two different excel file and get the output in new excel file but i am ...

ac3mark

So I'm trying to make a macro that moves data from an input sheet to the appropriate sheet based on information in a given cell that is being entered....

4 replies Last reply on 22 Aug 2019 by
ac3mark

### Excel vba to color row based on wbs level

Hello I need a macro to change row color based on "Level" column. Thanks Ebti

ac3mark

### Copy from one cell and paste to another sheet based on length of another column

Hi I am using the code below to copy and paste from one column to another based on cells containing data in column A, what I need to do it copy data f...

3 replies Last reply on 21 Aug 2019 by
ac3mark

### Summarise hours incurred by month based on multiple criteria

Solved

Hi, I want to summarise hours incurred mthly (from the time_converted column) based on the grade and agency but can't seem to get the below formula...

4 replies Last reply on 19 Aug 2019 by
Micwhsct

### Open office page numbering - start numbering on page 3

Solved

I would like to know how to start the page numbering on page 3 instead of 1.

3 replies Last reply on 14 Aug 2019 by
HelpiOS

### How to reset my nokia 1202-2 pin code

Closed

Hello, im forgot my nokia 1202-2 pin code

Last reply on 13 Aug 2019 by
ac3mark

### Are you still taking questions?

Hello, Are you still taking questions?

5 replies Last reply on 13 Aug 2019 by
Somnonaut

### Message to appear when 5 cells uncolored cells contain values.

Solved

Hello, A macro using excel that can return a message when 5 uncolored cells that are in a range of colored and uncolored cells contain values. The ...

### Code to move rows into another sheet based on certain values

Solved

Hello, I'm having trouble figuring out how to do something! I have a sheet (Design) with work order details on it (columns A-J will have data in). ...

6 replies Last reply on 13 Aug 2019 by
vcoolio

### Create an ordering list for our consumables

Hello all, New user here! I am new to coding in Excel (pretty much Excel itself) and do not have access to Access. I would like to create an orde...

17 replies Last reply on 12 Aug 2019 by
ac3mark

### False value removal

Hello, How to remove false value if I use below formula =IF(\$K4="Urban",IF(N4>0,1,0))

ac3mark

### Checking the values in sheet1 with multiple entries in sheet2, write the output

Hello Experts I am having 3 different sheets: In sheet 1, I have columns A- K & Sheet 2, I have columns A-G. I need to find column H values from Sh...

### Inserting an image without the white background

Solved

Hello, I have an image that I have vectorized... or so I think I have.... and I when I try to insert it into a document this white square appears ...

20 replies Last reply on 8 Aug 2019 by
Pratik

### Creating a data input sheet with excel

Hi, So I am attempting to create a dashboard whereby data can be inputted in different categories and then once the data is submitted it is sent t...

### Count cells containing text per row

Hello, I am trying to figure out and if statement to add 1 if there is text in a row so that at the end of the row I will get a total for each time ...

### Excel formula to identify similar text

Good day, I am looking for help with an excel formula to identify similar text within two columns. In column A there will be a specific word wit...

5 replies Last reply on 6 Aug 2019 by

### Update open office failed

I did as you directed for updating Open Office but "update failed" several times what should I do next? thank you

HelpiOS

### Search using variable

Hello, I am trying to enter a value (name or partial name) and perform a search in the specified column. I can easily put a specific string in the ...

ac3mark

### Auto-populate a sheet with data from different other sheets

Solved

Hello, I have been having problems with having a general data sheet in my workbook. My problem is as follows: I have 3 different sheets, all of w...

59 replies Last reply on 29 Jul 2019 by
ac3mark

### Copy rows to other sheets based on value in column

Solved

Hello, I have copy and pasted the code used to solve the problem for the question which began this thread. I have 6 tabs into which I want to...

16 replies Last reply on 26 Jul 2019 by
vcoolio

### Transfer data from sheet1 to sheet2

Hello, i have data in sheet1 from range a1: f91 when i fill data and transfer to sheet2 it also transfer the empty rows here i wanna delet...

7 replies Last reply on 26 Jul 2019 by
ac3mark

### Macro code vba exel sum dublicate data and delete

hi, everybody i need help code vba exel i have data in sheet1 begening from cells a2:g100 many data are dublicateed i would the sum dublicate ...

24 replies Last reply on 19 Jul 2019 by
ac3mark

### Copy template, rename based on a reference list from a different spreadsheet

Hello: I am trying to make copies of a template in a worksheet, and rename those worksheets from a list on a separate worksheet. Currently my templa...

vcoolio

### Replace 'sheet' reference in a formula (not copy data, but get averages)

Solved

Hello, I'm working with a precipitation data base of multiple sheets. Each sheet is a year of measurements. The thing is that I'm trying to ge...

5 replies Last reply on 13 Jul 2019 by
vcoolio

### Copying excel data from one sheet to another based upon contents of a cell

Hi, I have a spreadsheet containing two sheets. Sheet 1 contains the following: Col A - username Col B - Full Name Col C - Email address Col ...

3 replies Last reply on 11 Jul 2019 by

### Ms word not displaying page numbers, images

Solved/Closed

Hello, So far MS word worked fine. But now it is not showing up images. Also not even page numbers. Instead showing up {Page}. Please let me know...

Last reply on 10 Jul 2019 by
soroush

### Am not too good on percentage calculation

Solved/Closed

Hello please what is the 10 percent of,7200000000

Last reply on 10 Jul 2019 by
kieferschild

### How to duplicate rows x number of times

Does anybody know how I can repeat rows in a spreadsheet by n number of times specified in cell B in that row ie from this table: Column A, Col...

4 replies Last reply on 9 Jul 2019 by
ac3mark

### Why do my pdf documents open in word?

Solved/Closed

Hello, I can't figure out why my PDFs always get open in Word but not the Adobe program? Does anyone have a quick answer? Thank you so much! ...

Last reply on 8 Jul 2019 by
tinman

### Follow up q to how to add a certain number of days to a date in excel

Hello, Thank you for your article with the handy tip. What way would one make use of to fill the contents of a single row (or column, depending ...

### Macro to copy/paste down x times (where x is the number of rows)

Solved/Closed

Hello, I could sure use some help on a Macro. I need to copy the value in E1 and paste down to all cells in column E (E2 to E??) The issue ...

Last reply on 8 Jul 2019 by

### Compare sheets macro

Can you please help me with the code for comparing two spreadsheets and giving the result in a separate sheet. The range may be different for the two ...

### Which macro (of many) changes the data in my workbook

I am working with an old macro enabled spreadsheet that has many tabs and many macros. On one tab I have a column that reports "yes" or "no" when the...

### Rtf to pdf converter

How can i convert a rtf file to pdf ?

HelpiOS

### Formula to subtract one cell value from another.

Hello, I am trying to do a formula that would subtract cell a2 from a1 if cell a3 has "Closed" in it. Is this possible?

vcoolio

### Auto transfer questioner with right answer to another sheet

Hello, I have questioner list (yes or no) about 60question. I want to make it automatically transfer (all the row) to another sheet if answer is ‘N...

### Vba code for insert picture

Looking for VBA code to help me install different pictures from a drop down icon menu on my excel ribbon. The excel ribbon was created by me with an ...

ac3mark

### Inserting day of week along with date

Solved/Closed

Hello, I am currently working on a spreadsheet and trying to set the cell format so that it displays the day of te week alongside the date eg Wed 1...

Last reply on 27 Jun 2019 by

### Insert picture in ms excell

Hello Friends, Please help me out, how I can insert the picture in front of the name automatically. Means I just select the images these pictures auto...

ac3mark

### Not able to send mail from the gmail outlook

Solved

Hello, I had configured Gmail in Outlook 2007. I am able to recieve all the mails. But the problem is not able to send mail from outlook. I had giv...

41 replies Last reply on 22 Jun 2019 by
Chetan

### Partial matches in lists of 6-digit numbers

Hello! I have a list of ~500 6-digit numbers. They were all hand entered, and we want to proof the list and see if any of them were duplicated by typi...

3 replies Last reply on 20 Jun 2019 by