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 ...

Last reply on 23 Sep 2009 by
venkat1926

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...

Last reply on 23 Sep 2009 by
venkat1926

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...

Last reply on 22 Sep 2009 by
venkat1926

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...

Last reply on 22 Sep 2009 by
venkat1926

Excel date formatting problem

 Solved

So 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...

Last reply on 22 Sep 2009 by
chow70

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

Last reply on 22 Sep 2009 by
Trowa

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...

Last reply on 20 Sep 2009 by
venkat1926

Hiding rows in excel 2007 using macros

Hello, i need a macro which hides rows containing blank cells in a particular column

Last reply on 20 Sep 2009 by
venkat1926

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/...

Last reply on 20 Sep 2009 by
Aysal

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...

Last reply on 19 Sep 2009 by
venkat1926

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...

Last reply on 18 Sep 2009 by
Excelguru

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...

Last reply on 18 Sep 2009 by
flcconflict

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...

Last reply on 18 Sep 2009 by
closeup22

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...

Last reply on 17 Sep 2009 by
gusrob

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: ...

Last reply on 17 Sep 2009 by
Kat

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...

Last reply on 16 Sep 2009 by
Excelguru

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...

Last reply on 16 Sep 2009 by
Excelguru

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. ...

Last reply on 16 Sep 2009 by
venkat1926

I found it difficult to browse free

Hello, cant any one send an mtn free browsing settins

Last reply on 16 Sep 2009 by
closeup22

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...

Last reply on 16 Sep 2009 by
wil

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...

Last reply on 16 Sep 2009 by
venkat1926

Please help with my spreadsheet

 Solved

Hello, 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...

Last reply on 15 Sep 2009 by
chicky

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...

Last reply on 14 Sep 2009 by
umesh

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...

Last reply on 13 Sep 2009 by
Excelguru

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.

Last reply on 13 Sep 2009 by
dybbody

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...

Last reply on 13 Sep 2009 by
Excelguru

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...

Last reply on 13 Sep 2009 by
Excelguru

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...

Last reply on 12 Sep 2009 by
Excelguru

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 ...

Last reply on 12 Sep 2009 by
Excelguru

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...

Last reply on 11 Sep 2009 by
Excelguru

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...

Last reply on 10 Sep 2009 by
iveal

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 ...

Last reply on 10 Sep 2009 by
cool

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...

Last reply on 8 Sep 2009 by
User

Browser

Hello, pls am trying to check my yahoo mail with my mobile nokia 7610 supernova but its not connecting. What do I do.

Last reply on 8 Sep 2009 by
somky

How to hide formula in excel sheet

Hello, i want to hide excel formula in my excel sheet. can anyone help. thanx

Last reply on 8 Sep 2009 by
venkat1926

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 ...

Last reply on 8 Sep 2009 by
kulot

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...

Last reply on 7 Sep 2009 by
venkat1926

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...

Last reply on 7 Sep 2009 by
venkat1926

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 ...

Last reply on 7 Sep 2009 by
olfo81

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...

Last reply on 7 Sep 2009 by
sharpman

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.

Last reply on 7 Sep 2009 by
pcsces

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

Last reply on 7 Sep 2009 by
firsttimer

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

Last reply on 7 Sep 2009 by
onea97

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...

Last reply on 7 Sep 2009 by
realiser

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...

Last reply on 6 Sep 2009 by
venkat1926

Please help! excel question

 Solved

Hello, 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 ...

Last reply on 6 Sep 2009 by
deepbreathe

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 >>...

Last reply on 6 Sep 2009 by
afsgun

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...

Last reply on 4 Sep 2009 by
sharpman

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 ...

Last reply on 4 Sep 2009 by
deepbreathe

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...

Last reply on 4 Sep 2009 by
Trowa
Results 6551 - 6600 out of a total of 7,065