The discussions
Find last row of data in excel spreadsheet
Hello, I'm very new to VBA and macros. I have been tryong to find the last row of data in my excel spreadsheet and then make this bold in a macro so ...
Cell references in excel formula's
Hello, I'm looking for a formula that will change the cell it refers to be a set increment. I need to repeat this a couple of times, by pulling th...
Day of the week- multiple rows!???
Hello, I am working in a Excel file and need help! I do not know a whole lot about excel so this should be interesting. I have a file where cl...
Excel 2007 help
Hello, I have a drop down on C19 with the following listings. A, B. If A is selected i would like to have the word "Stop" display on a cell. How do...
Excel date formatting problem
SolvedSo here's my problem. I have multipe dates all in one column on one tab/worksheet of an excel workbook. When I try to link to that date on another tab...
Script for split the data into seperate sheet
Hello, i need a script so that the data will move to diff sheets based on coloum and the coloum value is in range please suggest on this
How can i copy column to rows
Hello, Can anybody help me on this? please provide me a macro(VB) to solve this problem, I have 1st column with heading "geocode" and 2nd column...
Hiding rows in excel 2007 using macros
Hello, i need a macro which hides rows containing blank cells in a particular column
Cut cells into external book and copy result
Hello everyone! I'm new here and I hope i'll find my sollution here as well. I have two workbooks: a price converter and product list. I want to copy/...
Macro: setting a cell value from another cell
Hello, I am creating a spreadsheet for recording annual leave for a department. I have set up a macro so that when a button is clicked, all the curr...
Excel macro paste row for certain num of rows
Hello, I have a row with data that I reach from a blank row below and perform a count of the number of rows elapsed to get to the row with data. Af...
Default on accsing my browser
Hello, i have a N82i dual Sim made in Korea(Sony Erickson K700c) which can't access Google or any other web site does any one know how to troublesho...
How to browse with my phone
Hello, please i am using sony ericson phone and i want to browse with it, which i don't no the process or way to browse with it. Please help by sendi...
Macro to find coloured cells and remove #n/a
Hello, I hope you can assist. I have two questions. Firstly, I need to have a marco that locates a coloured cell in column "a" and if found, col...
Columns into rows
Hello, I have a data field which I am trying to rotate from Horizontal to Vertical. I am new to macro's. So my data is set is: Pet: Dog Name: ...
Excel columns
Hello, I am trying to create a formula that will add 1 to a number at the top of a column if a number in the rows below are greater than 19. Any idea...
Full protection of excel file
Hello, I want to fully protect my excel file so I have done the following: Protect each worksheet with password. Protect VBA project with passwor...
Excel max displayed as row title
Hello, im trying to get the max value for a set of data but displayed as the row's name field.. and not the actual number. ex. ...
I found it difficult to browse free
Hello, cant any one send an mtn free browsing settins
Vba return found cell value
Hello, What I have is a few rows of data, I want to search one column for data between a criteria ( 70 -71), find this data and then return the whole...
Compare excel data
Hello, I have two Excel files. Ex:A file having A to E column names and B file having A to J column names. A to E columns are same in A and B Tabl...
Please help with my spreadsheet
SolvedHello, I am having a hard time trying to figure out how to format my spreadsheet so that i can make it a template that i can use in future, this is w...
Data transfer from excel files using macro
Hello, I want to transfer data from excel files to one excel sheet. Not all data but few. ex: 50 excel character files & 1st row sheet 1 contain pri...
Limiting macro to a single spreadsheet
Hello, I have a simple macro which saves a spreadsheet to a memory stick for backup purposes via 'ctrl shift S'. If a second spreadsheet is opened th...
Free browsing with mtn
Hello, pls i really need a software for mtn free browsing on my pc. if u can grant my request will really appreciate it.
Excel mapping or macro help
Hello, I am new to macros and mapping so any help would really be appreciated. Thank you in advance. Here is my issue: I receive a large order that...
Query in macro
Hello, i have an excel file. contains 2000 rows and 6 columns. if Column "A" contains "1" and Column "B" contains "sweet", the entire row has to de...
Help with excel
Hello, I'm not sure quite how to get my spreadsheet to do what I need it to do. I have two tabs set up in the workbook; the first tab has a list o...
Excel formula
Hello everyone. I am trying to create a formula which will compare the value of a portion of one cell, to a table array, and return the 2nd column ...
Macro magic
Hello, I am using Excel 2007. I need a macro that will cut and paste certain cells from a row based on a cell value in that row. What is cut wil...
Reagin of microsoft excel files
Hello, I have downloaded C-Cleaner, after that I have added and run C-Cleaner by which I have lost all my Microsoft Excel files. Can I get bac...
Macro
Hello, I have a excel sheet. In that almost 500 datas exists. now i wanted to compare 2 conditions. If "C:C" column is "4" and "F:F" is "6", then ...
Excel if then statements
Hello, I am trying to figure out and make changes to spreadsheet someone else designed. Since, I haven't done elaborate spreadsheets in awhile, I n...
Browser
Hello, pls am trying to check my yahoo mail with my mobile nokia 7610 supernova but its not connecting. What do I do.
How to hide formula in excel sheet
Hello, i want to hide excel formula in my excel sheet. can anyone help. thanx
Excel help, combining info from two sheets
Hello, How can I match and combine records across two excel sheets. I have two excel sheets containing record information, about 6 columns for each ...
Matching of 2 cells &display corres 3rd cell
Hello, In Sheet 1 I should give two input DATA and this data will available in sheet 2 .excel should match the given inputs and result must get dis...
Excel macro help
Hello, I am using Excel 2007. I need a macro that will cut and paste certain cells from a row based on a cell value in that row. What is cut wil...
Free browsing
Hello,i want to know how to browse on a window vista laptop by using a nokia 3110c with a zain or mtn line. please reply. my number: 07038012814 my ...
Want new browser
Hello, I am currently running IE 7 on XP. I have downloaded without success IE 8, firefox, Google chrome, safari. None of them work. I have checked f...
I wants to browse free with my laptop&my phon
Hello, i wants to browse free with my toshiba laptop&my sonyericson w810i phone using mtn.
Vba conditional formatting coding in excel!
Hi, I have the following conditional formats: =AND($J8>=N$4,$K8=N$4,$K8=N$4,$K8=S$4,$K13=S$4,$K13=S$4,$K13
Excell date formula
Hello, dear i want to show the date on my excel sheet and ofcourse to change automatically on daily basis. please adviise the formula thanks
Browser service problem
Hello, Hi, everbody, this kalpesh... I have problem computer browser services autometic stop problem in windows xp . then i have start manually.. if...
Make back up of excel using macro
Hello, I am working on excel file ABC.xls. While the file is still open I want to run a macro which will make a copy of the current ABC.xls as Backup...
Please help! excel question
SolvedHello, I am trying to figure out how to count the number of cells that contain a certain text. For example: Column A 2007 Entry Draft ...
Wirless browser problems
Hello, i haVE A EXILLENT SIGNAL FOR MY WIRELESS BUT NONE OF MY BROPWSERS WILL DETECT IT EVERYTHING ELSE PICKS IT UP XBOX I PHONE OTHER LAPTOPS >>...
Learning macro
Hello, i wan to know about macro programming in Excel. i have one question ....... suppose i have a,b,c, d, e..........etc. columns i want ins...
Auto aoloring of cells and text
Hello, I have the following requirement: If the value in cell A1 is greater than 0, then the same value should be displayed in cell A2 with the ...
Vba: deleting selection on multiple sheets
Hello, I would like someone to write a VBA code for the following action: On the sheet "Verlofoverzicht" I've got a list of names. Both front- a...