Office Software Forum
- Excel (9,794)
- Open Office (113)
- Outlook (643)
- PDF (334)
- PowerPoint (179)
- Word (2,186)
-
Split data from one sheet into many sheets Closed
Hello, I have extracted data from our accounting database (account code, journal number, reference, date etc). Now I want to split the data so tha...
-
Calculation Add Up Closed
Hello, I'm trying to get the formula for the above calculation however I cant figure it out. I'm trying to add 20% only when the total amo...
-
Notifications on excel Solved/Closed
Hello, I would need your help to create a notification on excel. I've got a row of date's and when the date is 90 days prior to the expiry dat...
-
Excel cell search and enter value Closed
Hello, I need help constructing a formula in Excell 2007 that will do the following - search the spreadsheet for matching number - if it f...
-
Suma Closed
Hello, I have two columns in excel sheet. column1 , 2 1541671 A 1541672 A 1541673 A 1541674 A2 1541675 A 1541676 B 1541677 C 15416...
-
Macro for extracting particular data Closed
Hello, I request someone to help in solving my problem. I have two sheets one is "cashbook" and another sheet is "transaction". In "cashbook" shee...
-
Unhide Tab in Excel Solved/Closed
Hello, I have a cell in excel that is either true or false. Based on that then it is linked to a check box. When ever I type the word "True" it ...
-
Excel drop down list Closed
Hello, My question is regarding drop down list in excel. If i have data of all 12 month. and i have created a drop down list in excel of all 12 mo...
-
Office for Mac sort columns into new workbook Closed
Hello, I am new to VB and need some help. I have sorted a spreadsheet by user ID in column"D" and now I need to move the data in columns E and F in...
-
Excel - Conditional Formating Closed
Hello, I want to highlight a row with a certain colour. I have 4 rows. The first one is physical stock the second one is qty outstanding , third i...
-
function data from web in MS excel Closed
Hello, I would like to import data from one webpage to Excel using function Data - From Web. The problem is that this web page has at the end .jsp (...
-
copy specific data to a new sheet and save it Closed
Hello, I am looking for a macro that will copy data based on a specific cell(group name) and paste it to a new workbook. I am also looking for th...
-
Macro/UDF to auto Transpose cells Closed
Hello and greetings! I am stuck in a list of my team members more than 2000 where details for every individual is not recorded based on fields/column...
-
need help for sorting data Closed
Hello, i have column A with 8000 random number cells(rows) . i need to separate and add to 100 columns (from B) to and 800 rows. how can i do, p...
-
Columns Matching... Closed
Hi, I have a workbook in which there are 3 sets of 3 columns names (Narration, Debit, Credit) (Doc. No., Debit, Credit) (Diff, Debit, Cre...
-
Word - insert rows based on cell value Closed
Hello, I am a macro novice with several questions. Please help! 1. I created a Document Change form with tables in word. The user will input a...
-
email set grey can't add acct Closed
Hello, I want to add a second email account to outlook 2010, when I click on the + tab, the add account tab is grey. Can't add the new account. H...
-
how to split text into columns in MS Word Closed
Hello, I have the following text VENKATA RAMAN with a space in between I want to convert into a table with VENKATA in one column RAMAN in se...
-
Command button open a file(path is in CellA1) Closed
Hello, Can anyone tell me how to open a file (other than MS office file) from a command button and the file path is sitting in Sheet1 Cell A1 I hav...
-
conditional seaching and extrcting value<urg> Closed
Hi, I have a requirement to copy cells conditionally by seraching from another sheet. Below is the scenario explained in detail Sheet1 Sheet 2 ...
-
Macro for counting duplicates in raw Solved/Closed
Hello, I apologize in advance if even my search efforts have not found an answer to my question, believe me I've tried. Ok, I need ...
-
Working with time in a Rota Spreed Sheet Closed
Hello, I have a spreadsheet of a work rota, i have start and end time in seperate columns , i need to work out how many hours each persons shift...
-
Help with calendar Closed
Hello, Hello, I am trying to make a calendar that when you click on a certain day number it will bring up a sheet to input data. I also wa...
-
Match data from Excell Solved/Closed
Hello, I have information in different spreadshits which I would like to match by the name and year of a company. How can I do that? Example: ...
-
search range if two vaules are the same copy Closed
Hello, i'm a new in excel soo that's very hard for me to understand. i need a formula or a vba code for the following : i have two excel files...
-
Give results if a value in a column matches Closed
Hello, I would like Column L on sheet 1 to display the data in Column O on sheet 3 if the data in column A on sheet 1 matches the data in column c i...
-
sort data with same value Closed
Hello, QUESTION ONE I have alot of data that needs to be sorted by date column A and and column E and F have values entered. Now need to sort onl...
-
copy data from 1 excel sheet to another by cl Closed
Hello, i am trying to copy data from 1 excel sheet to another by clicking on button. my code is: Sub Button4_Click() Worksheets("ManHour").Ran...
-
IF formula help Closed
Hello, I am trying to create a spreadsheet using Excel 2010. All the data works fine... Except for this one formula. When entered into seperate...
-
locating excel files and copying using macro Closed
Hello, I want to copy certain data on rows and columns of different excel file from one tab with the date as the identifier and put it in a new...
-
Excel/VBA2010-Select cells between 2 keywords Solved/Closed
Hi guys, Here's a tricky one. I'm trying to write a macro that starts from the active cell - goes up the column selecting say 20 cells and searches...
-
Matching Columns from different worksheet Closed
Hello, I am trying to match project codes in different work sheets and display the date. Column E5 worksheet Contract award to match worksheet ...
-
Cells ending in '0' Closed
Hello, Is it possible to use conditional formatting to highlight the cells in a column of sequencial numbers ending in '0'? ie 10, 20, 30 etc to ...
-
Excel 2010 Lookup Options Closed
Hello, I'm trying to compare a field with TODAY() against a range a fields that are sequential dates, and when it matches, I need to return the values...
-
help with excel Solved/Closed
Hello, does anyone kno of a formula that will automatically input the next month. for example if I am starting with 10/28/2011 what is the formu...
-
multiple rows and columns in a single row Closed
Hello, I have some data in excel sheet. Here is the example. AAA 10 0 0 0 0 0 0 0 0 0 0 0 ...
-
If statements Solved/Closed
Hello, I'm trying to create an "if statement" that will allow for the following scenario: B5
-
Copy rows by column match condition Closed
Hello, I want to copy the rows from one sheet to other sheet based on column name matching. E.g, ================================== EN...
-
Macro/VBA needed to find, match, copy/paste Closed
Hello, Ok so i've searched and searched and still haven't found code to do exactly what I need. The macro needs to be able to search hundrends of ...
-
Help for the SKU001.CAB Solved/Closed
Hello, I got a message when i was open the Microsoft Excel i got SKU011.CAB error i want to know how i get this error solutions Thanks Sh...
-
key 25 Solved/Closed
Hello, i have a laptop hp pavilion g6, i am a student so i want to work on microsoft office, we ask me to enter a product key, so i don't how do i d...
-
splitting document file from a merged file Closed
Hello, here i had tried the coding for splitting the document file , guide me the coding to create a new document and to save the content from the ...
-
Excel (Mac) opens docs when started Closed
Hello, Recently my Excel (Office 07 for Mac) program tries to open ALL the documents in a particular file whenever I start it up. It choses to open...
-
I need this excel formula urgently Closed
Hello, I have the values 2,3, 2, 4, 5, 7,5,1. I want a formula that will select the first five lowest values and add them thanks
-
How to replace cell data based on criteria Closed
Hello, I'm trying to write a macro in excel that will utilize two spreadsheets. One sheet contains a large table of information while the other onl...
-
Matches using a list of keywords Closed
Hello, Can you guys help me with this one? I have a list of keywords and I want to find all the rows that contains any words from my list. Exampl...
-
Cant open Downloaded image in my email Closed
Hello, Hi i need somebody to help me with.., If i download a particular attached file in my email.., I could not open the attachment.. I am not a ...
-
Hello, I can't open my word document Closed
Hello, I can't open my word document for i think some unicode problem. one day i send one word document to my E-mail id after that process i can'...
-
Excel VBA Closed
Hello, Please, I face difficulties to come into solution on one issue about how to use vba & one cell of a sheet1 to enter data into cells on ano...
-
pdf downloads but doesnt open well?? Closed
Hello, can you help me open my PDF cause my cousin send me an email and it has an attached file and when i download it its fine but when i open it ...