Excel Forum
-
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...
-
Excel Percentage Averages [Closed]
Hello, I have two columns of info, 1st column is of purchases and 2nd is of received values. Each Row is of a different site and I calculate the perc...
-
Macro Search and display [Closed]
Hello, How do i search a spreadsheet to find a date equal to todays date, then copy values in column B and column C and paste in another Worksheet....
-
Excell average function problem [Closed]
Hello, i have a row with 7 cell. 4 cells contain numbers, and 3 letter x. how to calculate average for the cell that do not contain letter x. thanks...
-
copy partial rows based on value [Closed]
Hello, I'm hoping someine can help me... I'm new to visual basic and I'm looking for a code to take the data from an excel spreadsheet, sheet 1 a...
-
adding data from other worksheets into one [Closed]
Hello, I am having aproblem loading a bunch of data from other worksheets into one worksheet (sheet1) in Excel. I have been trying to use the code: ...
-
MS Excel: Copying Condionally formated cells [Closed]
Hello, I have a conditional format where if a cell in a row has a specific value, it will set the format to highlight the whole row. I would like ...
-
excel calculate hra cca da only [Closed]
Hello, i have a worksheet with the following column a b c d e f g s....
Subscribe To Our Newsletter!
DON'T MISS
- Facebook Code Not Received
- How to Get More Followers on Instagram
- How to Create a Gmail Account
- How to Fix a Blurry Snapchat Video
- How to Get Free Diamonds in Free Fire
- How to Upload High Quality Photos to Instagram
- Computer Boots to Black Screen
- How to Recover Your Yahoo Account
- How to Recover a Disabled Facebook Account
- How to Install a VPN
- How to Disabled Write Protection on a USB