Office Software Forum

User form to search all result and edit selected

I'm newbie in VBA excel. I want to create usesform to add, search all result and edit selected. Any one have code like this? Thanks

How do i make my ranking

how do i make my ranking result be 1st, 2nd, 3rd instead of 1. 2. 3

Montlhy service

I have an increasing excel sheet where i keep the service records for customers per customer, per branch and per date (per year, month and exact servi...

If function?

I am trying to figure out a function, that will give me a result of Yes or No, if the dates are matching or not. This is the function I am using, ...

Inserting pictures

Hello, Please I need help, I want to insert pictures into a particular sheet remotely without opening the sheet. And the picture will be base in ...

I want to convert figure or digit to word but without rupees or dollar

Hello, i want to convert figure or digit to word but without rupees or dollar, i just need only at the end of words, please help

Populating multiple cells with information pasted on a main sheet

I am trying to paste data every week in the same cells (B2-B12) on my main page and have that data populate cells on 12 separate pages. All 12 pages w...

Help getting data from one worksheet to the next.

Hello, I am trying to set up a master job sheet for all of our field employees to have the information in the field. The links to the 2 sheets are...

Adding date depending on the day of the week

Hello, I want to automatically calculate a date when an invoice is due depending on the day of the week. For example: the service is provided o...

Transpose vba excel

Hi, I require a macro that performs a specific transpose action. Please see pre table example and desired post data set. I have searched for t...

Autocad 2010

Hello, I tried to install autocad 2010 but it keeps saying insert disc 1after when i install DirectX. So I opened acad.msi but it says install direct...

Help me to convert my file without spelling mistakes

Hello, I want to convert one PDF file to word file. My file was an tamil documenr. I tried many times but the spelling was not correct in converted ...

Updating other excel sheets automatically from master sheet.

Hi, I have been trying to sort this for a while. I have entered data in my master sheet and I have 4 other sheets. When I put new data into the mas...

If function with time

Hello, cell A = Time in, Cell B = Time out I need to round the duration in between as below if sum(B1-A1)= 0:00:00 the answer should be 0:...

Give a cell zero value depending on another cell's value

I have an interesting challenge I am a altra marathon runner busy creating a "log program" for my running Cell A1 = Distance Ran Cell B1 = Hours C...

Copy data and pasting multiple times using macro

Hello, So I am having trouble determining what code to use to past value. The situations is as follows: On Sheet1 I have a list of names in co...

Auto xfer specific data to a new wkst

Hello, I have a raw data file of sales opportunities and would like to automatically identify and copy the TOP 10 Optys onto a new Wkst. Further, ...

Excel vba- copying data from newest worksheet to a new workbook

Hi all, Newbie here. I've been fumbling around with VBA and managed to get some parts working, but now I'm stumped. I have an Excel workbook tha...

Repeat a set of rows in excel

Hello, I have some set of unique row in a1 to a10, and I want to repeat the whole set of row in same column eg."A" by some given no. Of time by a p...

Formatting a cell for multiple functions in excel

Hello, I would like to have my dates be highlighted red when expired and yellow highlighting the dates when 30 days prior to being expired. I alrea...

App android

Hello, App android

Split data into several rows of same data

Hello, I would like to split a row of data into several rows of same data in MS Excel. I will try to explain the situation. I need a macro that...

Send automatic emails using macros

If column F in any worksheet in entire workbook is changed to "Pending" send an email. Below is my macro so far. Sub Request() Dim OutApp As Ob...

Copy more than one cell in excel if a condition is met

Hi, I need to copy more than one cell if a condition is met. It’s about student degree. If the degree between specific range, then I need to copy m...

Pulling data from multiple sheets to master sheet

Hello, I am working on a project and I could definitely use some help. I have an excel file with four sheets: Master Sheet, Project A, Project...

Excel 2007 file excel found unreadable content in

I have a problem regarding how to automatically update data in other sheets.

Hello, I m looking to have few different sheets that automatically updated based on information that is added or changed in master sheet. One shee...

Automatically move an entire row of expired item from one sheet to another sheet

Hi, I have a problem with the code below. I am a store officer in the firm I am currently with, and monitory of expiring date of a product is par...

Free activation key for ms office 2016

Hi, I have MS Office 2016 but it isn't activated. I tried every key to activate it but none of them worked. So, can someone help me about this?

Copy worksheet from one workbook to another workbook in ms office excel

Hello, In the Move/ Copy dialogue box, the destination workbook is not visible to copy the worksheet from the source file.

I forgot my password

Hello, I forgot my password.

Copy data from first sheet to other in excel

I have a workbook for tracking service customers. I would like for some of the data entered in the first sheet (first name, last name, date & email ad...

Excel conditional formula

Hello, I need to fixed date (not change by everyday) when A1 CONTAIN certain text like (IR) B1=Fixed date