Office Software Forum

jinco wireless-n USB adapter Closed

Hello, sir & madam i will purchase for wireless-n USB Adapter so install from applacation

Yahoo account will not connect Closed

I try to add my yahoo account in outlook. I input the appropriate settings imap.mail.yahoo.com port 993 encryption method SSL/TLS smpt.mail...

VBA Coding Closed

I had a file with 2 sheets say 1,2. From 1st sheet I want to copy one by one cells of A column whose value is OK in C column and paste it in C1 of sh...

Arrow keys not working Closed

Hello, my arrow keys are not working. up down left right

How to automatically number the pages in a document Closed

How could the engineers who designed Open Office be so bloody stupid? I mean what is so complicated for a software engineer to design something to au...

Excel 2013 to extract text in one cell Closed

Hi, I want to extract in the right column, a part of the left column, for instance: see below 2 lines for each line at the right column I want to ext...

how to transfer data from sheet to sheet 2 Closed

Hello, I have created an excel file which I need to track progress of each order, in the first sheet I have created the list of things that needs ...

Dynamically Assign a Number in Data Set Closed

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

transfer data from userform to sheet with the same format of table Closed

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 Closed

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 Closed

get help Macro sheet Closed

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 Closed

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 Closed

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 Closed

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

how to reset my nokia 1202-2 pin code Closed

Hello, im forgot my nokia 1202-2 pin code

Are you still taking questions? Closed

Hello, Are you still taking questions?

create an ordering list for our consumables Closed

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 Closed

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 Closed

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 Closed

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 Closed

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 Closed

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 Closed

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

Search using variable Closed

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 Closed

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 Closed

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 Closed

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 Closed

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 Closed

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 Closed

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 Closed

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 Closed

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 Closed

How can i convert a rtf file to pdf ?