Office Software Forum
- Excel (9,851)
- Open Office (117)
- Outlook (652)
- PDF (334)
- PowerPoint (185)
- Word (2,189)
-
Max value Closed
Hello, What formula can I use in Excel to find the max value for POR, BAR and DAR? see below.. Thanks A B 1 POR 2 2 BAR 3 ...
-
How to name excel sheets on values in columns Solved/Closed
Hello, I have a list of people names in a column in one sheet with additional cells in each row for adding data. I want to create separate excel s...
-
Pasword Recovery for memory card Solved/Closed
Hello, i have noika 5233 and i had put a password for the memory card and now i have fought the password so if u can help me ...... Plz
-
MS Office 2010/2007 to 2003 Closed
Hello, I have some documents at MS word 2010. I could not open these files to MS Word 2003 in my office PC where installed the MS word 2003 only. I...
-
IF Formula currencies Closed
Hello, I am trying to use if formula for a table where i have 4 currencies and if one of the currencies matches the one that i have on top to div...
-
Count distinct values where condition satisfy Closed
Hello, I a trying to count distinct values of Column B for a given value of Column A. For example, if a number 000759BY5 (column A) had two diff...
-
Delete Row with Red Font Closed
Hello, I need to delete any rows that have a cell with red font in it. Can you please help me make a simple macro? Thanks! Configuration...
-
repeat 'x' value in nth column for y times Closed
Hi frds, i am doin a project in excel. in that i hav columns headin product, capacity, qty,customer, delivery date etc. i need to asign work to the...
-
PDF's Opening In Photoshop 4.0 & not Adobe! Closed
Hello, I recently installed Photoshop 4.0 and ever since I did, every time I try to open a PDF it no longer uses my Adobe 7.0, it now defaults to the...
-
Multi ranges to Auto filter in one worksheet Closed
Hello, Is it possible in Excel 2003 to use Auto Filter more than once (twice) on ONE worksheet? I have a worksheet containing two ranges of informat...
-
Conditional Formatting (> 3 conditions) Solved/Closed
Hello, I am creating a grade book in EXCEL (Office 2003) and need to have more than three conditions for colouring the cells. Very simply, I have x...
-
Copy_search_copy_paste_macro Closed
Hello, I am trying to create a macro. I am using a workbook with three separate pages I need the macro to copy the contents of a single c...
-
Entering row value in Excel formula from cell Closed
Hello, I want to make an sheet that pulls text from Sheet1 into Sheet2. This is a simple use of the "=" key, but, I want to select the row this d...
-
How to insert rows dynamically with in group Solved/Closed
Hi, currently I am creating a macro, in to that I have data for row and columns. now I want to count the product in column A, with formula =counta (...
-
Import data from web page to excel Closed
Hi, Whenever i run the report the report data will be stored in web page.I want to import to excel from web page.when i am doing so,the data wi...
-
Comparing rows of data Closed
Hello, I am trying to compare two sheets of data, column A has the company common key code to compare. Sheet1 ColA - Company Code: 1234 ColB ...
-
Copy and paste rows based on criteria Closed
Hello, i have used the below macro...it is pasting the rows that match criteria but at the end getting stuck.....when i debug it is highlighting End I...
-
Macro to search excel Closed
Hello, I'm trying to write a macro so when a number is scanned into Excel (using a bar-code scanner) it searches the sheet to check if that number...
-
Copy rows from one sheet to another Closed
Hello, I have two workbooks; Workbook 1 has 12 rows Workbook 2 has 12 worksheets that contains the pasted weekly results from worksheet 1. I am...
-
macro to design a screen Closed
Hello, I need a macro that will create a screen from data from three excel sheets which contain data like the field with its positon and len...
-
Needed coding in VBScript Closed
Hello Sir/Madam, It will be helpful for me, if u give coding for "comparing Two XLSheet in different workbook on the basis of th...
-
Comparing 3 columns of numbers Closed
Hello, have 3 columns of numbers in excel (A,B,C), where B=A+25. What I am trying to determine is if a value found ANYWHERE in column C falls between...
-
Merging an Excel Spreadsheet to Visual Basic Closed
Hello, If anyone could help me with this it would be greatly appreciated, Data binding has always somehow been difficult for me in Visual Basic. I...
-
Column A to heading Column B to rows Closed
Hello, I have two excel columns. Column A has what I want to be the row heading. It repeats itself and has 65 rows. Column B has unique values...
-
Print Qty of Excel Sheets = cell value macro Closed
Hello, I need help with a print macro. I have a file with multiple tabs (each tab having unique information) including a data entry tab. On the...
-
Macro help Closed
Hello, Is there a Macro available that will allow me to only pull unique data from one worksheet to another? For example, I have a bunch of data,...
-
Higlight formel (Rewhrite) Closed
Hello, all English is not my first nor my second laungish, so please excuse me for any miss spelling and gramma errors. Im looking for a F...
-
urgent help in macro Closed
Hello, happy nEW year i need your urgent help in macro . i have some data like below in excel A B C E F Customer Name RDS ID Device ID Produ...
-
Calculating time in an Excel formula Closed
Hello, I have an Excel formula that works: =WORKDAY(A2-13.5/24,1)+IF(NETWORKDAYS(A2,A2), IF(MOD(A2,1)*24
-
How to chang text color automaticaly in excel Closed
Hello, I want to chnge the text color if the value of other relative cell is changed. For eg. I have cell range from B11 to XAV11, if any value...
-
HELP IN MACRO Closed
Hello, happy nEW year i need your help in macro . i have some data like below in excel A B C ...
-
XP Compaq system restore, lost Office Closed
Did a Compaq XP system restore and can't get my Office 07 back. I am a septuagenarian, limited income and I can't afford another Office program. I lo...
-
Excel 2007 Moving information button Closed
Hello, I need to create a button which movies an information from one row in one sheet to other row in another sheet. I can create it with macro 1 b...
-
Compare two worksheets macro Closed
Hello, I was looking for some help as far as setting up a macro that compares to worksheets into a third worksheet and came across this macro. Thank...
-
Alternate way for "Find and replace"? PlsHelp Closed
Hello, I have an excel workbook which i have to change it everyday. It has two sheets: one of them the operators inputs the daily values and in th...
-
Try to match cells and return values Closed
Hello, I need help!! I have a table containing the following: Column A Column B Column C Column D product Country State Date ...
-
vb macro to copy image from file to cell Closed
Hello, I have a VB issue, i have a excel sheet where i wish upon entering a number in column C (starting at row 10) a jpeg with the same name will...
-
EXCEL 2007 HIGHLIGHT MAX&MIN VALUES Closed
Hello, I have lists around 500 rows long each group of dates ×& marks separated by an empty row is there a macro to highlight the max&min values ...
-
create a new matrix in excel macro Closed
Hello, I would like to create a new matrix under some conditions from old dataset. Basically, I want to choose rows from the old data as long as ...
-
Data entry in two excel files using a form Closed
Hello, I have two excell files "a.xls" and "b.xls" both are having Three sheets "Sheet1", "Sheet2" and "Sheet3". Both the sheets are protected by...
-
how to check for the last row of excel Closed
hi, i am writing data from csv file to excel using c#, by data contains more that 80000 rows, so i want to check the end of the excel file i.e the ...
-
Two Sets of Data Grouped Closed
Hello, I ma trying to create a worksheet where columns of data is compared and grouped. What it is, I am drawing up a spreadsheet in order to dete...
-
Countif macro codes on multiple criteria Closed
Hello, I need a macro codes with condition applied in formulae. I have a text as below in excel from C1 to C33 and i want a macro to count of "f...
-
Highlighting Cells based on Dates of other ce Closed
Hello, I am working on the following. I have names of customers in column A and dates in columns B, D, F, H, J and L. I am trying to highlight the...
-
change numeric value in alphabetic Closed
Hello, I want to change nemeric value in alphpbetic in excel worksheet Exmpal like 1000 change in One thousand Thanking you Rohit K...
-
Rollup or summary sheet Closed
Hello, i am quite a 'newbie' at VBA and have run into something that i can't seem to get started. i have sheets by month that have the same amoun...
-
TAT Closed
Hi All, please provide me with a macro to calculate the time i.e TAT(turnaround time) for the whole work for a month
-
Highlight duplicate values Closed
Hello, I need some help with a macro to highlight duplicate values in different columns that have to the same company ID. so I need 2 conditions i...
-
Copying data excel worksheets Closed
Hello, Can someone give me an easier way to do this? I have in column A; Team 1, Team 2, 3,4 etc down to 30. In coloumn B, I have 'week 1' Afte...
-
Match Excel Data and return associated data Closed
Hello, I have an excel sheet that I am trying to match data up on. Essentially, my data looks like this: Column A Column B Column C Col...