The discussions

Dynamic seletion of rows

Hello, I need to select the entire row based on cell value. Ex: Students and marks is avialable in one excel sheet. I need to display the students ...

Last reply on 6 Mar 2009 by
Pedda

Excel macro to copy cell content highlighted

Hello, I am trying write a macro assigned to a button that copies the content of a cell into highlighted cells. Please can anyone suggest a soluti...

Last reply on 5 Mar 2009 by
manrick

How to check 3columns data at 1 time

Hello, how to check 3columns data at 1 time.for example:- ColumnA---------ColumnB----------ColumnC 87----------------15-------------------20 10---...

Last reply on 5 Mar 2009 by
jaikrish_18

Inserting customer address to excel invoice

Hello, I have designed an invoice template in Excel and want to be able to import the customer name and address fields automatically (currently hel...

Last reply on 4 Mar 2009 by
helpmeout

Vba code for copyg rows

Hello, m gettg problm while copyg rows from one Excel sheet to another sheet. plz its urgt me if anybody have sol yhn plz snt me. my problm is:- i...

Last reply on 4 Mar 2009 by
ameero

How to solve this problem in excel

Hello, how to check 3 column data together and it has to check the same 3 column and it has to give the result example ColA-----------ColB----------...

Last reply on 3 Mar 2009 by
pro-genius

Vba conditional formatting

Hello,

Last reply on 2 Mar 2009 by
Tina

Browser icon buttons

Hello,i've been trying to get rid of the browser icon buttons like forward, back, mail, fav., n so forth. every time i use customize n move them over ...

Last reply on 2 Mar 2009 by
wallplz

Help with excel formula

Hello, i am working on a spreadsheet that keeps track of machine hours. i need help with a formula that when themachine hours gets to 3000. the numbe...

Last reply on 2 Mar 2009 by
kathcat

Copyspecified data from a ldif/txtfile2 excel

Hi There Good Day! I am having ldif file and and i need to populate an excel workhseet with some selective data from the ldif file . Basicall...

Last reply on 1 Mar 2009 by
deri58

Whatisthe formula to get higer number inexcel

Hello, Hello, i'm jai krishnan im having a big problem in excel 1. in column A i'm having set of numbers in Column B also Having some set of numb...

Last reply on 26 Feb 2009 by
Jaikrish_18

Excel macro- need help

Hello, Could anyone please help me with Excel Macro logic/ or if more generous with macro code for the following scenario: I have a Dashboard with...

Last reply on 26 Feb 2009 by
availlity

Need help in excel

Hello, I am SHANU I will explain what i want to do please help me out if any know about it I have 2 Sheets in Excel in Sheet 1 the names are retu...

Last reply on 25 Feb 2009 by
SHANU

Creating a macro

Hello, I would like to know, how to copy a word and paste it into another cell using macro?

Last reply on 25 Feb 2009 by
Oterwill

Excel help: transpose cells by content

Hello Forum, I am struggling! I am trying to find a way to get a current column of data transposed into seperate columns of the same genre... Her...

Last reply on 21 Feb 2009 by
sunshinevivi

Change sheet name in formula when copied down

I have a workbook made that has a 'Quantities' sheet that list any number of quantities along with 'contract quantity', 'current quantity', etc. Ther...

Last reply on 20 Feb 2009 by
lestuce

Excel data extraction macro needed

Hello, Hie .I am working on a project in which l have to compare dates in excel and enter the difference (in days)in time in a separate column .l am ...

Last reply on 19 Feb 2009 by
Umer

How to prevent enable/disable macro box

Hello, Can anyone tell me how to prevent the enable/disable macro box from appearing when I start Excel. Thanks Marcos

Last reply on 19 Feb 2009 by
Sweet

Excel 2003advanced filter....copy to location

Hello, I am trying to use the Advanced filter...and copy the info to different worksheet. It's not working out for me :( I have been trying to do...

Last reply on 19 Feb 2009 by
Crazzydreamer

Excel 2003: match names; view unfound matches

Hello, I need formula or macro configuration help for Excel 2003. Within a spreadsheet, I want to compare the list of names in column A with th...

Last reply on 18 Feb 2009 by
99cateyes

Excel help!

Hello, I'm working in Excel 2007 and having some issues doing what I need to do. I have a speadsheet that has a list of users in column A. A li...

Last reply on 18 Feb 2009 by
locklessmonster

Excel lists - extracting data from it.

Hello, I hope someone can help me! I have a long list of items in one column. next to each item I have to give certain values to some of them. The ...

Last reply on 17 Feb 2009 by
Helper

Excel lookup

Hello, I am using excel for analysing my data. I have time in column A and temperature in other 10 columns. I need to find the maximum value in e...

Last reply on 17 Feb 2009 by
Zeenath

Excel blank row deletion

Hello, Can anyone provide the macro code for deleting all the blank rows in all excels in a folder?? thanks...munni

Last reply on 17 Feb 2009 by
Michael

Macro to check conditions in two columns

Hello, I am trying to update prices in excel spreadsheet. I have three different Unit of measures (Each, Pack, Case), I need a macro that will check ...

Last reply on 17 Feb 2009 by
rine012

Count and summarise records in excel 2003

 Solved

Hello, Sorry to bother you but I have a minor problem with a spreadsheet and I don't know how to resolve the issue or whether it is possible u...

Last reply on 17 Feb 2009 by
GRA

Excel macros

Hello, how to code an excel macro where an if staement will hide appropriate rows? Any suggestions would be greatly appreciated. 1. Yes ...

Last reply on 13 Feb 2009 by
Helper

I can use my browser only with ip address

Hello, I am using Acer Aspire. I tried to connect with Ethernet cable at home and today wirelessly to my work network and it works ok. The only probl...

Last reply on 13 Feb 2009 by
xpcman

Auto fill the range between 2 cells

Hello, My Question is I Have Put One Range Like " 1 " in One cell and ending series " 10 " in next cell . Now I want the excel To Auto Comp...

Last reply on 13 Feb 2009 by
JIN

Repainting a cell using excel vba

Hello, I am writing a code in excel VBA to generate a report.I am totally new to VBA.Here's my code Private Sub CommandButton1_Click() Dim a1 As...

Last reply on 12 Feb 2009 by
Helper

Macro to copy and paste value every nth row

Hi all, I need to copy cell value in D:1 onto a range of cell (O:3 to O:31) and from D:34 onto (O36: to O66) and so on... i.e. every 33 rows I h...

Last reply on 12 Feb 2009 by
pc

Create msg/popup to notify in excel vba

 Solved

Hello, I need a Excel VB script to notify/popup a message when the number of the letter U on a calendar exceeds 6, 8, 12 etc. It will have to check...

Last reply on 11 Feb 2009 by
Siebel SME

Copy rows of data based on alpha condition

Hello, I have a summary worksheet that houses all records. I'd like to break that summary worksheet into in multiple worksheets grouped by last name...

Last reply on 11 Feb 2009 by
solene77

How to check multiple cells to return value?

Hello, I am a basic Excel user. I have an Excel sheet which displays a hierarchy of our institution's org units. The org unit names are listed ...

Last reply on 10 Feb 2009 by
Helper

Excel- merging running totals

Hi there! First, I need to know if what I want to do is even possible. I have about 10 excel sheets- each with two running totals on them. My boss ...

Last reply on 10 Feb 2009 by
Helper

Converting date format in excel sheet

 Solved

Hello, I have a cell which contains date in the format dd/mm/yyyy, but i need to convert to mm/dd/yyyy in excel how can i do this?

Last reply on 10 Feb 2009 by
daywish

Printing 1997-2003 excel files

Hello, I am running a new laptop loaded with Vista 64 bit and Microsoft Office 2007. When I receive an XLS file in 2003 format it uploads in the 1997...

Last reply on 9 Feb 2009 by
herbbob

Excel 2002 macro

Hello, Sub goalSeekSample() Dim seekValue As Double Dim changeCell As Range seekValue = InputBox("What's the value to seek?") For Eac...

Last reply on 8 Feb 2009 by
anon125

Excel 2003 please help with concat dilemma

 Solved

Hello, I need one column to show the following text: prxyz,(Data1 here),0699,ABCD(Data2 here),xxx Data1 is in Column A and Data2 is in Column B....

Last reply on 8 Feb 2009 by
excelgamine

Formatting macro

Hi, I have data ranging from "B8 to BZ616" all the data contains either "TRUE" or "FALSE", I do not want to use conditional formatting. my questio...

Last reply on 6 Feb 2009 by
Helper

Moving data in excel

Hello, I messed up sone data in Excel. I have a contact list and now I need to move everything in columns C-F down 4 cells. All the addresses are off...

Last reply on 5 Feb 2009 by
Helper

Excel

Hello, i need help in solving a macro issue. i have written a macro to delete rows base on a certain criteria. this is, "week 01", the issue is, wh...

Last reply on 5 Feb 2009 by
Helper

Excel formula

Hello, I have a excel spreadsheet where I have 10,000 rows and columns are filled with data, column headers are Name, country,total users, total us...

Last reply on 4 Feb 2009 by
Helper

Vba code

Hello, I am very very new to VBA, (although I did some VB in college), and am attempting to create an Excel Macro that will allow me to search thro...

Last reply on 4 Feb 2009 by
melnisson

Excel formula

Hello, i want to know a formula from which i can get the answer in text. For example if i right an amount in the cell A1 (100/-) i want the answ...

Last reply on 4 Feb 2009 by
tiestomania

Excell

Hello, I have two sheet.. one is the master sheet containg the stock and the second sheet containing the sales invouice for a particular month...

Last reply on 4 Feb 2009 by
Ron

Excel cells to individual rtf files?

Hello, I want to creat a VBscript in Excel that will move the contents of each cell in a column (A:1-A:10) to an individual RTF, and retain the for...

Last reply on 4 Feb 2009 by
metallic_gear

Compare two worksheet on conditional basis

Hello, I have to compare two worksheets on conditional basis. ex: worksheet1 having two columns loginname(col A) and date (col B) and worksheet2 ha...

Last reply on 3 Feb 2009 by
Helper

Move cells to the next column

Hello, I have a report that comes already formated for printing. However, I want to be able to manipulate the data to analyze it. Currently the r...

Last reply on 3 Feb 2009 by
Helper

Excel

Hello, How to find with a function in excel how many names starts with a , if i have these names in columns: Matt Sara Andi Gent Alex

Last reply on 3 Feb 2009 by
password00
Results 6901 - 6950 out of a total of 7,065