Excel Forum
-
browser issue Closed
Hello, First ... my email system seems to work just fine ... but, when I go onto the web, either through IE or firefox, the first page, such as MSN.c...
-
Free internet browsing on computers Closed
Hello, dis is x-maga i hv somtin here if u wish 2 browse free on ur laptop/desktop nd phone contact me on 08066339414 my price is #20,000 or if u hv ...
-
Importing csv file data in Excel with VBA Closed
Hello, I am builiding a spreadsheet that keeps track of my monthly business expenses. I use a small applet on my blackberry that allows me to enter...
-
macro button and macro Closed
Hello, Buttonname.caption=iif(buttonname.caption="Update On","Update Off","Update On") where to paste the above line to create macro button and ho...
-
Macro Help Closed
Hello, I need help with a macro. Mine works ok ... but I'd like more userflexibility. Let's say I have 4 .xls workbooks in a folder. I'd li...
-
date formula in excel Closed
Hello, can u pls help me in getting a simple date formula in excel eg:28/8/2009 i need to convert it to 28-aug-2009 please can u h...
-
Matching the case in excel cell Closed
Hello, I need to know is there any way where in I can match contents of two excel cell. for ex: A1 has the value A.K.Traders and cell A99 has Traders...
-
Sub routine to test and color cells Closed
Hello, I am trying to develop a simple function or sub to scan a worksheet of approx 2000 cells, test the contents, if the cell is empty leave, if t...
-
Make Excel particular sheet protection on net Closed
Hello, I have Excel sheet, with containing around 10 sheets, tat sheer was shared in net work with 5 diffrrent persons (systems). each person is re...
-
Excel: Copy active range to bottom of list Solved/Closed
Hello, On multiple sheets I have lists of peoples names. When I add a few new names on one sheet, I want a macro to copy-paste these names to the o...
-
Not able to browse but net is showing connect Closed
Hello, i have windows xp SP3 installed in my laptop, when i connect the modem to my laptop, at status bar it shows the message as internet is connect...
-
Unique excel formula Closed
Hello, I am using excel 2003. In my spreadsheet I have the following formula that I have to copy and paste into every single row in one column... ...
-
need to use color as argument excel Closed
Hello, I am writing a macro to produce payroll and have run into a snag. I pay a different amount for product x if the cell color is red than any oth...
-
Highlighting out of date cells Closed
Hello, I have never made a macro before and not even sure if i need it for this task but hey here we go. I need to highlight certain cells in red ...
-
Sum in Excel Closed
Hello, Hi I am sapna How to take sum in excel for figures in same colours in Microsoft office - 2003 For eg. if I want to take the sum of figures ...
-
Browsing Closed
Hello, I want to browse free with my sony ericsson phone, which opera mini version should i use. I have been using opera mini 4.0.1, but it has not b...
-
Excel - how to hide certain unwanted times? Closed
Hello, As you can see below information (extracted from Excel Sheet), my company works 24 hrs, and each time my staff tag on the main door, the log...
-
Excel If Then Statement Maximum Closed
Hello, I am trying to do an if then filter in excel 2003. I am calculating a simple percentage, up to a maximum x. So like =A1*.25, with a maximu...
-
how can i use my web browser in my phone? Closed
Hello, how can i use my web browser in my phone?my phone unit is nokia 6300china phone
-
Excel trick for reading tables? Closed
Hello, I'm using Microsoft Excel. Imagine I have a table with two columns, one labelled "Staff Name" and one labelled "Able to lock-up." The ...
-
internet browsing Closed
Hello, please how do i configure my freedom for browsing with my mtn line?
-
Copy Rows from SheetA,B&C and paste in SheetD Closed
Hello Experts, I am a novice in using VBA or Macros in excel. I need a help in copying all the available rows from Individual Sheet say A, B & C ...
-
VBA code correction! Closed
Hello, Does anyone know how i can amend the below code to printout a notepad file instead of a word document?? Sub PrintWordDocument() Dim wrdA...
-
ms excel install Closed
Hello,i have windows 2002xp professional in my pc .ihave downloaded ms excel 2007 from internet.but i am unable to install.please give your advic...
-
Conditional Formatting Excel 2007 Closed
Hello, I´m trying to get a whole column coloured, depending of the value in H$. This with only the use of Conditional formatting (no visual basic)...
-
Need help on Excel Macros Closed
Hello, I am not a techie and I have very limited knowledge on Excel Macros. I have two worksheets. Worksheet 1 - Employee information like E...
-
Simple Excel Formula Closed
Hello, I am trying to enter a simple formula into excel: IF F6>=0 THEN G5=F6 Cell F6 and G5 are on different pages in the same workbook.
-
Hide Macro excel 2007, run with a button only Closed
Hello, I am using excel 2007 and I wish to stop users runing macros except via macro objects in work sheets. Ie so other users can't access the macr...
-
Macro to sort Files with file extension Closed
Hello, I have sheet a with 46 rows and 1110 columns(this might vary). The cells contain filenames with various file extensions like .zip, .tif, .ex...
-
EXCEL: Deleting cell range (multiple sheets) Closed
Hi, I have been trying to figure out how to clear the contents of specified cell, say Range (A12:U12).Select ActiveCell.End(xlDown).Select Se...
-
Macro to test Null values Closed
Hello, I have a spreadsheet where if I enter a numeric value between 3000 and 7000 (excluding values between 6000 and 6500) it checks to determine ...
-
take a single cell and divide it into rows Closed
Hi Everyone! I am new here and need some help. I have Microsoft Excel 2003, not all that experience and have never used Macros. I am designing a da...
-
row data in columns Closed
Hello, Dear Sir, I have Data Like 324 Platinum Gold Silver 325 platinum Silver 326 Gold 327 silver 328 329 platinum 330 Gold I wa...
-
Browse Button Closed
Hello, i m new to vb script..actually in VBscript i want to create a browse button in the input box inorder to browse my files stored in the lcation....
-
copy row from one worksheet to another Closed
Hello, I have 11 worksheets in one workbook. First sheet is "Master", Second is "New BB" ,Third is "New LB, Forth is Steelers and so on(football tea...
-
Selecting multiple sheets from range values Closed
Hello, I have a workbook with information that distributes over a number of sheets (for the sake of simplicity call them "Home", "One", "Two", "Thr...
-
Creating dynamic cells in Excel 2003 Closed
Hello, I am creating a workload management chart, Gantt Chart, using Excel 2003. I have the start and end creating the "duration." Now I need the c...
-
Cells filling by array Closed
Hello, i have a problem in Excel 2007 in VBA. I have this code (part): Dim Oblast As Range Set Oblast = Worksheets(2).Range("H1:H" & Pora...
-
with excel had a report writer Closed
Hello, I have a spreadsheet with student names, each student is assigned to one of 4 teachers. Student name in A, teacher name in B other data in the...
-
Using Formula to Pull Data Out of Worksheet Closed
Hello, I'd like to pull 4 numbers out of a list of URLS in a spreadsheet. The 4 numbers will always be in the same place at the end of the URL. I need...
-
Save worksheets as seperate files Closed
Hello, I want to save the sheets in a work book as seperate files. Also these files should have one of the vba module from the parent workbook U...
-
Returning text from one of several columns Closed
Hello, I currently have IF Formulas in 3 columns across the page. The formulas return a blank ("") in 2 of the 3 cells in each row. I want to have ...
-
Excel: Getting numbers from cells Closed
Hi everyone, I'm looking for some Excel function help. I have some cells that have both numbers and text in them. I'd like to take the first few nu...
-
Refresh colour in conditional formating excel Closed
Hello, I have used the below vba code to format a drop down cell based on whether its pass or fail or block in excel(2000) 'START OF CODE Private...
-
Add Macros Closed
Hello, I already have few macros in Excel,how can i add a new macro in Excel.By adding new macro will it effect the old macro's which is already th...
-
Excel Macro to create a chart Closed
Hello, I have recorded the Excel macro 'ChartTestMacro2' below, that creatats a chart from the Sheet "MacroTestSheet". I have been unsucessful in ...
-
Free browsing Closed
Hello, pls who will help me send me a free browsing soft ware to my phone or how to configure my nokia 2600c for free browsing
-
excel formula Closed
Hello, i have one excel sheet, the first sheet has master data with various inputs like No,remarks 1,hello 2, hai 3, bye 4, good 5, bad...
-
Execl - Copy forumlas to multiple worksheets Closed
Hello, I am having trouble copying formulas to multiple worksheets. On the sheet name tab, I click "select all sheets" then I type in my formula...
-
Lookup Matching Names in Multiple Columns Closed
Hello, I found this site on a google search. Thanks in advance for any help that could possibly be provided. I'm an IT PM. I currently have spre...
