Office Software Forum
- Excel (9,749)
- Open Office (113)
- Outlook (639)
- PDF (334)
- PowerPoint (174)
- Word (2,185)
-
PROBLEM IN EXCL Closed
=IF(Y9="adgaon kh","channi",IF(Y9="ambasi","channi",IF(Y9="changefal","channi",IF(Y9="channi","channi",IF(Y9="charangaon","channi",IF(Y9="chatari","ch...
-
Converting Multiple Rows to One with Multiple Colums Closed
Hello everyone, Can anyone help me with converting the below example of data in Excel Many thanks in advance.
-
append row data from 1 sheet to the end of a matching cell row Closed
If columnA in sheet2 matches columnB in sheet1, append the data from the row in sheet2 to the end of the row in sheet1. Sheet1 may have multiple rows ...
-
help me to add particular cells Solved/Closed
Hello, i want to sum particular cells when a number consists in a cell eg:- =IF($B$81:$BH$81=7=TRUE,SUM($B$77:$BH$77),0) it calculates a...
-
download office 365 Closed
I would like to download office 365 how?
-
Macros From Rows to Excel Files Closed
Hello Fellas I have a workbook in which I have a list of Clients with details in the columns (name A, phone B, direction C, ZP D, etc) and I need t...
-
Conditional Formatting Closed
Hello, I'm trying to create a table for a field trip. Essentially, I want the students name highlighted based on their homeroom teacher. There are...
-
xlsx corrupt file, password protected Closed
I've created a *valuable* xlsx file that I've been storing on my USB drive. Everything was fine until I copied a multi-gigabyte folder to my USB driv...
-
Macro/command button help Solved/Closed
Hello, I am in need of some help here and would greatly appreciate it. Here is what I am trying to accomplish. I have a basic excel file with two s...
-
Copy info from one excel sheet to another sheet Solved/Closed
Hello, I am respectfully asking for assistance on an issue i am having trying to write a macro for a form that i am currently working on. I have ...
-
Avoiding excel cropping text when next cell contains formula Closed
Hello, If you have empty cells to the right, text from a cell will float over the columns following. However, if you have a formula placing "empty...
-
to check first letters of two columns are equal Closed
Hello, could you please tell me how to check whether first letters of two columns are equal
-
how to auto copy Closed
Hello, My workbook contains about 1000 sales entries on sheet 1 . Some customers paid in full, but some other don`t. I will put a * beside the cus...
-
What Type does it want? (VBA question) Solved/Closed
Hello, So I have a pull-down list in Excel 2003 that is an expanded version of this: 011 012 01T 111 If I type in the cell (rather than ...
-
comparing two columns Closed
I have two columns both of which contain list of names.i want to get the output as true if the names are somewhat similar eg dane john and dwayne john...
-
Auto Hide Rows & Columns Closed
Hello, i have a worksheet with many formulas in it. i use bellow code for auto hide rows and columns when a a cell in that column or row is 0 or e...
-
copy info from one excel sheet to another sheet Closed
I have sheet 1 that i call "FORM" that I enter information into. I would like to create a macro to copy the info that i put on the FORM onto sheet 2 "...
-
Excel Macro to Create a Workbook for Each Change in Column A Closed
Hello everyone. I love forums like this where the community helps one another and solve real life problems faced by real users. I would very much ...
-
fix the last date Closed
Hello, my target is 3900 but daily target is 50, how to fix last date for closing of my target. please define formula with examples Configurati...
-
Conditional formatting??? Closed
Hello, If I enter 1 in a particular cell, I want that cell and the next cell in the row changes to certain colour fill (ex. G5=1, then G5, H5)... ...
-
VBA programming, copy wks from one file to another Closed
Hi, I am struggling with the code to copy each sheet in workbook1 to workbook2) Dim NewWorkbook As Workbook Dim Wks As Worksheet Dim wb1 As Work...
-
How do you bring text from one cell down to another cell based o Closed
Hello, I need to make a cell auto-populate (bring content down from another cell range) based on the content result of any cell in an entire colum...
-
Conditional Formatting to hide 00:00 in column Solved/Closed
Hello, I would be very grateful if there is somebody who could help me find the solution to what is most likely a simple problem. I don't have a grea...
-
ames Closed
Hello, my password will not let me login in its saying invalid Configuration: Windows / Mozilla 11.0
-
coping & pasting data in first blank cell in same worksheet Closed
Hello, I would like the vba code for a macro ( using a form button) that copies data from cell:M1 to A13:A30 depending on which is the first blan...
-
Conditional Formatting based on Checkbox Closed
Hi, I've been trying to conditionally format a merged cell by what happens to a checkbox. If my checkbox is blank and the control cell in B16 is "...
-
help me on this formula to shorten Solved/Closed
Hello, i have 2 formulas tick mark automatically on worksheet.. please help me if further it can be shortened.. i want to know if J1 K1 L1 can sho...
-
conditional format problem Closed
I have 3 columns Column A start time (hh:mm) Column B finish time (hh:mm) Column C is total Time (hh:mm) where C is (24-A1)+B1 etc How can I hide the...
-
How to copy data from one spreadsheet to all others Closed
Please, does anyone have a macro to copy data from a specific range on a standard sheet (ideally with formatting) to all but one other sheet active in...
-
Copy data based upon cell value Closed
Hello, Need help on copying data from file1.xlsx into multiple .xlsx file based upon column G values. The file1.xlsx contains... Column F Column...
-
Macro to insert pictures using 2011 excell Closed
Hello, im trying to make a prototype for a POS that insert images into the invoicing system. for the most part i have this functional, but the boss ...
-
Excel Macro for copy row to another workbook. Closed
Hello, New-ish to excel and I'm helping improve systems at the work place. The issue is I want to be able to copy a row. e.g. | New | 12345...
-
Prefix 0 to all records in a column Solved/Closed
Hello, I want to prefix 0(zero) to all records in a particular column of an excel sheet.Please let me know how to do it. Thanks for your time, Mano...
-
Transpose Column to Row Closed
Hi All, I have list of data need to transpose as below. Anyone can help with the macro? Thank you. From Material Des ww1 ww2 A Q 1 4 B E 2 ...
-
Excel Picture Inserting Macro Help - Urgent Solved/Closed
Dear Rizvisa, please consider this little urgent and be kind to help me please I m trying to insert picture in excel column using macro which ta...
-
date formats Closed
Hello, friends... i have problem in the date formats i have an excel sheet with data i am trying to filter by date 01/12/1999 this is the dat...
-
Create a formula in excel to scan workbook and move to new one Closed
I want to know how to create a formula that scans all of column A only for duplicate data and if found than in a new worksheet copy the entire first r...
-
Change of password security notification Closed
I established an @ live.com email account for a non-profit for which I volunteered. I will no longer be addressing the correspondence from this email...
-
Conditional Formatting on Excel 2010 Closed
Hi, I am trying to figure out the correct method in which to apply a formula in conditional formatting. The first row contain the document names....
-
how autofill data from sheet1 to sheet2 in different order. Closed
When we type numbers in any sequence in sheet1 but they out come countinusely in sorting sequence in sheet2
-
Populating a column of data based on drop down selection Closed
Hello, I am trying to populate a column with data from a seperate sheet based on a selection from a drop-down list. The drop list and the desire...
-
Making a table based on cell value. hide row. conditional format Closed
Hello, This is for a machinery quotation, based on model type and specifications I have a sheet in which cell B2 has a drop down menu listing 4...
-
Multi percentage Calculation Closed
Hi all, Good day!! Need help in Excel formulas. I'm creating a workbook to counting a value in multi percentage and multi level. Here I attac...
-
If dates range Closed
Hello, I need help for a function. Lets say that we have the today date 4/12/2014. I need a formula to use in conditional formatting. If the da...
-
How to count different charecters Solved/Closed
Hello, Please help me to count different charecters like xpa, spa, spb xpb.. if any of this exist in the cell it should count. if xpa is in A1 spa...
-
Date if statments Closed
Hello, I have a if statement that I need help writing. I have a today date cell and I have closed date. I am trying to make the new cell check i...
-
pdf files into source safe seems to corrupt them Closed
I have about 40 pdf files, that are accessed and viewed by the application. I am having a problem. Basically adobe reader displays a blank document. ...
-
Check if input number is minimum and display a pop up dialogue Closed
Hi, I am novice VBA developer. I am trying to write a macro which does following. 1.When a user enter a particular value into cell 2.Check if ...
-
change date format Closed
Hello, Change date format dd.mm.yyyy to dd/mm/yyyy for excel 2007
-
for progress billing Closed
Hello, how can i automatically know the percentage area of a accomplished tiles by simply counting the tiles Configuration: Windows / Chrome 3...
