Office Software Forum
- Excel (9,805)
- Open Office (113)
- Outlook (643)
- PDF (334)
- PowerPoint (179)
- Word (2,187)
-
how to save next data entry in next target range Closed
Hello, I am running a macro using a command button that saves data from A3:AB3 to a7:AB7. however when I change the data from A3:AB3 and click sav...
-
create a macro which monitors the cell "c1" to be changed to "a" Closed
Hello, I hope someone can assist with this In my workbook; I have two worksheets labeled "log" and "master" I want to create a macro which monitor...
-
auto add or subtract between two cells Closed
Hello, This is probably a very simple question. I am trying to auto add or subtract between two cells. example: if B1 is greater or less t...
-
EXCEL VBA: Application.FileSearch Error in Running Excel 2013 Solved/Closed
Hello everyone, I encountered error "Object doesn't support this action" when i run the macro program after upgrade of excel (from 2003 to 2007).Up...
-
Please help - Finding missing rows between 2 sheet Closed
Hello, I would really appreciate your help with putting together a simple script to compare 2 excel sheets. I basically just want to find missing ...
-
Percentage Closed
Hello, how do I figure out the mark up percentage when I have the cost and sell price. cost Q2 1.14 sell P2 8.04 what's the per...
-
How to stop rows underneath being affected by a filter Closed
Hello, I have a filter set up for a table which works fine and is filtered when a quantity is entered in column D. However under the table is more row...
-
simple multiplication gives wrong result Closed
Hello, I am raja, In my excel 2010 when i am trying to multiply two cells of values 743.91 & 0.87 , the result is as given 646.88. But the actual...
-
column with dates not sorting/formating Closed
Hello, a column with dates is not sorting nor formatting. I have tried to do the suggested answer on the forum but to no avail. This is driving me cra...
-
Copy paste special into last row of another worksheet Solved/Closed
Hello, Thank you for taking your time to read my questions. My question is the following any form of help will be greatly appreciated. I am ...
-
how to create student exams record and printout using ms excel Closed
I wish to design student exams records using MS Excel afterward, I should be able to pull records of student using Matric_No and then print out the st...
-
EXCEL ** Sent e-mail after cell changes ( Excel macro ) Closed
Hello, I am looking for a solution on excel where when coloumn e is changed then email me with a coloumn plus the new e coloumn. Thank you for ...
-
Letter writing and printing Closed
I downloaded this programme on the understanding it was a free version of Microsoft word but I don't see where to start a letter for printing ??
-
Multiple Query in once button in same sheet Closed
Hello all, I have created two separate queries in excel VBA. I have given two different buttons for both queries and both are running successfully...
-
Transfer names from general sheet to separate other sheets Closed
Hello, So i have 3 separate sheets, the first is a general info sheet with names and other information on it, names are in column A. Each name is ...
-
Help for creating a macro Closed
Hi all. I'm here to ask for ypur help. I want to create a macro, that opens a dialog box and leting you browse your computer and open a new excel file...
-
complex nested if formula help... Closed
Hi, I'm new to this excel lark, i rather like it but am stuck, please can you wise people help me... heres a pic of what I'm working on... s...
-
status of the certificates Closed
Hello, i am raja, i have no.of certificates with issue date ,expiry date, last annual survey & next annual range. i attached sample sheet below .I...
-
Show Calculation on the first of the month Closed
Hello, I have created a spreadsheet with various calculations. I have it divided as monthly items, however, I prefer that a certain calculation o...
-
account formulas Closed
Hello, i am raja, i am working on milk processing excel sheet(it contains parts annexure II to annexure X) to start new business. anyone can help m...
-
Autopopulating across tables Closed
Hello, Hoping for some help with the following Excel conditional query. Hoping to automate so that Table 1 can autopopulate Table 2 with the re...
-
IF statement that adds 1 for specific text Closed
Hello, I have a spreadsheet that I have a column (I2-I48) that contains text for different ticket types. I am trying to create a formula that give...
-
Copy cell value between sheets if it matches a criteria Closed
Hello, I am looking for assistance in getting a formula to copy cell values between sheets if it matches criteria. Scenario - sheet 2 will have...
-
Find the last blank cell Closed
Hello, I am looking for a formula/method of finding a last blank cell in a column example column A 1 2 3 4 blank cell 1 2 3 ...
-
Employee Scheduling using Excel Closed
Hello, I'm trying to create an excel sheet for employee scheduling. If I type the name of the person, is it possible to create a formula or condi...
-
Auto populate cells based on the number in another cell Closed
Hello, I was wondering if it's possible to "tell" excel to Auto fill in a row of cells with specific text, based on a value in another cell. For ...
-
If then formula for dates and days of the week Closed
i need an excel formula that will calculate days according to rules, so I have a list of dates and in the column next to it I need it to add 13 days t...
-
Merge data based on condition Closed
Hello, I have multiple sheets with different columns, the header is mentioned in row 3 and there are few headers which are common across all the s...
-
Need a macro to duplicate rows of text based upon a cell value Closed
Working on Mac vs. 15.17; I had a macro that use to work in a previous version of Excel. But I cannot get it to work now. I do not know VB or code. Ca...
-
Matching Names with two separate formats Closed
Hello, I am trying to create a table where in one column has the names from File1 in format Last, First ex. Gates, Bill without duplicates. The in...
-
How to extract Date Before a particular word in a cell Closed
Hello All, .I have a particular column in an excel worksheet that contain something like "AUXID9016700# 16/06/2016 8:54:25 AM call received fro...
-
Help needed for copying cells from one sheet to another Closed
Hello, Guys i'm new here, so pleace don't be hard on me :) I need your help for doing the following: There is one column A filled with names on ...
-
Oulook doesn't send emails, just receiving Closed
Hello, tried all of the options you have posted here but the test message always cannot be send, feeling a bit desperate now already... maybe some...
-
Excel Formula Closed
Hello everybody! That seems so simple but I can't do it :( I would like to know the formula for this: If any text is found in cells T23 U23 V2...
-
Names matching Closed
Hello, I have two columns A and B, in the both columns i have the names.i have to match the all the A columns names with the B column names and B ...
-
Copy all data from multiple sheets to one new sheet using VBA Closed
Hello, I have Multiple files in a folder.i wants to copy all Files data (i.e.all columns to new sheet) to one new sheet. E.g. file 1 Contains 5 colu...
-
A Macro to Copy Rows by Value Cho Closed
Hello, I would like to know if we can write a macro to copy a specific number of rows, which will be 24, 32 or 48. These values will be include...
-
insert all the photos I have in a "certain" folder. to excel Closed
Hello everyone, I wonder if anyone can help to create a macros. What I want is to insert all the photos I have in a "certain" folder. to excel. ...
-
Microsoft Outlook keeps sending the message Solved/Closed
Hello, I have Windows Vista with Office 2007. Microsoft Outlook has been working fine for 18 months but has suddenly developed a fault when sending e...
-
Roster Management Spread Sheet. Solved/Closed
Hello, Can anyone help with a spreadsheet to manage fatigue management. I have a work project where I need 20 people and for both day and night ...
-
Finalizing MACRO Closed
Hello, I've tired to work with this MACRO but I am trying to combine the content in order for it to work yet I keep getting bugs. The purpose of ...
-
If certain 'type' is in col. K have whole row copy to new sheet Solved/Closed
Hello, I am wondering if it is possible to have a whole row copy to a designated sheet based off of the value in a column. So for example if my ro...
-
Two-way relationship in PowerPivot Closed
Hello, I have begun using a PowerPivot with the Excel 2013 Data Model to see if it could satisfy some of my needs. Basically, in my first simple ...
-
Finding MAX value with criteria list Solved/Closed
Hello Chaps I don't often ask for help here but this one has stumped me. For a dashboard of sorts... I have a list of values in column S. E...
-
Change color of cells in Excel based on data in other cells Closed
Hello, I have a question for Excel 2010 Conditional Formatting. How can I change the color of a cell to red if the value in another cell is diffe...
-
Change color of a cell if value in other cell is not the same. Closed
Hello, I want to be able to change the color of a cell to red if the value in another cell is different. e.g if cell A1 is $0 and cell AF is $5 th...
-
Convert Single Column to Rows, into Matching Rows Solved/Closed
Hi, I would really appreciate any help with an issue I currently have. I have a file which downloads as ASCII (text), and when opened in excel give...
-
Help with formatting Closed
Hello, Hi everyone. I am looking to do some conditional formatting and I need some assistance. Can someone please help me to understand how I can ...
-
How to do conditional colour fill. Closed
Dear CCM team I want to have cell colour of cell AL3 to green if AK3 > or = D3 and the colour should be red if it do not meet this condition. Kindl...
-
Excel error Closed
Hello, I am working with MS Excel 2010. While inputting data in a four-sheet file, older data of one sheet keeps being replaced by newly added dat...