The discussions

Excel vba to color row based on wbs level

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

1 reply Last reply on 21 Aug 2019 by
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

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

1 reply Last reply on 13 Aug 2019 by
TrowaD

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

1 reply Last reply on 9 Aug 2019 by
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...

1 reply Last reply on 8 Aug 2019 by
TrowaD

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

1 reply Last reply on 6 Aug 2019 by
TrowaD

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

1 reply Last reply on 6 Aug 2019 by
TrowaD

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
TrowaD

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

1 reply Last reply on 4 Aug 2019 by
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 ...

1 reply Last reply on 29 Jul 2019 by
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...

1 reply Last reply on 18 Jul 2019 by
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
TrowaD

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

54 replies 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

1 reply 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! ...

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

1 reply Last reply on 8 Jul 2019 by
TrowaD

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

41 replies Last reply on 8 Jul 2019 by
TrowaD

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

1 reply Last reply on 4 Jul 2019 by
TrowaD

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

1 reply Last reply on 4 Jul 2019 by
TrowaD

Rtf to pdf converter

How can i convert a rtf file to pdf ?

1 reply Last reply on 4 Jul 2019 by
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?

1 reply Last reply on 1 Jul 2019 by
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...

1 reply Last reply on 1 Jul 2019 by
TrowaD

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

1 reply Last reply on 27 Jun 2019 by
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...

6 replies Last reply on 27 Jun 2019 by
TrowaD

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

1 reply Last reply on 27 Jun 2019 by
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
TrowaD

Formula to create generations based on birthday

I need a formula in excel that will indicate generations based off of a birthdate. Generations: Traditionalists (Prior to 1943) Baby Boomers (194...

3 replies Last reply on 20 Jun 2019 by
TrowaD

Copy and paste selected cells a given number of times

Hello, I had a quick course on macro and I would like to write my first one, but I would need some help with it. Id like a macro which copies t...

1 reply Last reply on 19 Jun 2019 by
ac3mark

Send mail if today is the birthday.

 Solved

Hello, I have a Excel sheet containg profile of some employee like this: Name ID Date of Birth Rahul 335221 15...

11 replies Last reply on 19 Jun 2019 by
bkdroid13

Comparing two excel sheets and copying like data to third sheet

 Solved/Closed

Hi, I'm trying to compare two sheets in excel and have matching column data copy the entire row into a new third sheet. Ex: Compare Sheet 1 column...

11 replies Last reply on 18 Jun 2019 by
TrowaD

Getting multiple largest values with specified limits

Hello, a1 is 110,a2 is 236,a3 is 175,a4 is 352,a5 is 257,a6 is 175.In b1 find value is greater than or equal to 400.i need all answers numbers not re...

1 reply Last reply on 18 Jun 2019 by
TrowaD

Extract data from few xml file into excel.

Hello, i hope someone will be able to assist me, and i hope it is possible to do what i need. I need to extract specific data from a few XML files...

24 replies Last reply on 14 Jun 2019 by
ac3mark

Comparing 7 column

HI I WOULD LIKE TO KNOW HOW TO COMPARE 7 DIFFERENT COLUMNS AND FIND COMMON VALUE IN NEW COLUMN I'M ATTACHING ONE SAMPLE HERE PLEASE CHECK AND...

1 reply Last reply on 13 Jun 2019 by
TrowaD

Trying to insert multiple rows between rows in excel with copied data.

Hello, I have used the two listed vba macros but i am having no luck combining the two. First one to add 13 rows between current data: data is on ...

1 reply Last reply on 13 Jun 2019 by
TrowaD

Using a named field for autofill

 Solved

I am performing an Autofill using a macro. Is there a way to enter the ranges using a "Named Field" in the macro without having to hardcode them in t...

2 replies Last reply on 12 Jun 2019 by
excel987

Find and replace using vb; from a txt file, find all commas ","

I need to find all occurances of a comma "," in a txt file and replace it with a blank space and output a csv file. Is there an easy way to do this in...

1 reply Last reply on 12 Jun 2019 by
ac3mark
Results 401 - 450 out of a total of 12,258