Office Software Forum

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

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

Sumproduct based on wbs

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

Spreadsheet help moving data

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

Excel vba to color row based on wbs level

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

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

Are you still taking questions?

Hello, Are you still taking questions?

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

False value removal

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

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

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

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

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

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

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

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

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

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

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

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 ?

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?

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

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

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

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

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