The discussions

Search for any value within a range and copy

 Solved

Hello, I am a beginner with Macros and would like to find code that will allow me to do the following: 1. Look for ANY values present in colu...

Last reply on 29 Dec 2011 by
venkat1926

Micro sd card password

i forget my micro sd card password set by nokia 5250. So,memory card doesn't support in other mobiles.please help me

Last reply on 29 Dec 2011 by
bionik

Splitting similar values of column to 3 colum

Hello, I have a spreadsheet that lists employees, then it list one of three quarters, and then it list their ranking for that quarter. I need the...

Last reply on 28 Dec 2011 by
TS

Paste to all sheets except some with criteria

 Solved

Hi, How can I make a macro paste copied data into some sheets of a worksheet but not other sheets. For example, I have 10 sheets in my worksheet ...

Last reply on 28 Dec 2011 by
nzstorm

Formating a column using macro

 Solved

Sir A forum member helped me in writing a macro to copy certain data from sheet one to sheet two. I modified basic macro to suit as per my require...

Last reply on 27 Dec 2011 by
Kishore

Seach for value, select entire row, copy

Hello, I have one macro that will search for a specific range in a series of workbooks and copy that range to a new workbook, and another that will ...

Last reply on 27 Dec 2011 by
rizvisa1

Excel vba user form

Hello, I am quite new to Excel VBA and I , desperately, need an expert help. am trying to create a user form that generates customer IDs made of 9 ...

Last reply on 27 Dec 2011 by
rizvisa1

Call an excel document to another sheet

Hello, Can any one suggest how to call a separate document(or) a Cell from one excel sheet to another excel sheet. For Example Book 1 got he...

Last reply on 27 Dec 2011 by
rizvisa1

Forgot password

 Solved

Hello, sir i have nokia2690 mobile the security code was changed onetime but the new password is forgot so please help me. Configuration: / Ope...

Last reply on 27 Dec 2011 by
bionik

Compare and count

 Closed

Hello, I want compare the two text coloum and count them for example mumbai ok mumbai ok mumbai not ok delhi ok pune not ok bhopal ok I wa...

Last reply on 27 Dec 2011 by
pcsces

Plz help me reviving some deleted fb messages

Hi , i have deleted some important facebook messages accidentally... can i revive them? please help me. thanks and regards, rosie Configuration...

Last reply on 27 Dec 2011 by
ashu44

Automatically copy from one page to excel

Hello, I want to copy information from one sheet to another regarding the categories. For example if I have airline company name, aircraft type, ...

Last reply on 26 Dec 2011 by
venkat1926

I forgot my password

 Closed

Hello, I am babu from pondicherry...........i forgot my password its not opening nearly for 1 year please help me to know my security code?????? ...

Last reply on 26 Dec 2011 by
pcsces

Excell conditional formatting

Hello, I have been using conditional formatting to make a cell change colors if a)greater than or b)less than, today's date; however, I don't know...

Last reply on 25 Dec 2011 by
venkat1926

Problem in receiving same mail on 2 systems

Hello, i have created a outlook account on ms 2007 in two systems where both the systems ll receive same mails sent from outside. but the problem is o...

Last reply on 23 Dec 2011 by
Ambucias

Office 2010 excel

 Solved

Hello, i am trying to show in cell J2 if the sum of cell I2 is more than 10 to show 10 and if the sum is les than 5 to show 0 have found how to show ...

Last reply on 22 Dec 2011 by
john

Change cell color every 7 days

Hello, Is there any way to change a cell's color once a week on a certain day on a regular basis. Example, only on Wednesdays cell color changes to p...

Last reply on 22 Dec 2011 by
vertix

Excel 2010 - if function with dates

Hello, I am trying to show in cell J2 if the date of cell I2 is between 1/1/2011 (MM/DD/YYYY) and 12/31/2011 to show SS12 and if not between those ...

Last reply on 22 Dec 2011 by
TrowaD

Create new worksheet with data

Hello, i have created a workbook, that contains my home income and expenditures. it contain for every month, i want, it create a new worksheet for...

Last reply on 22 Dec 2011 by
TrowaD

When data changes in sheet1 delete row in s2

Ok, I was able to use Macro to copy row from sheet 1 to sheet 2 with a condition. Now i want to either add to the Macro or create another Macro to de...

Last reply on 22 Dec 2011 by
FromNC2PR

Data transfer between cells

HELPPP meee!!! :( 1. i desperately need to transfer data between cells within a single EXCEL sheet. 2. on top of that, i need to have the data m...

Last reply on 22 Dec 2011 by
JaX

Copying data from worksheet 1 to worksheet 2

 Solved

Hello, I am using MS Office Excel 2007 and need to know how to copy a row of data from one worksheet to another worksheet using a criteria from colum...

Last reply on 22 Dec 2011 by
RWomanizer

Copy rows based on criteria - vba

Hi I have about 25000 entries of data that I wish to sort, Angle and time. I want to take them from a complete list in Sheet A to breakdown in Shee...

Last reply on 22 Dec 2011 by
RWomanizer

My memory card asked password

Hallo, sir Ji i am used Nokia 2690 and i am format my cell and my memery card asked password...pls help mee...

Last reply on 21 Dec 2011 by
pcsces

Vb, how to pull formula on graph to a cell?

Hello, I already have a VB in place that brings in data and from that data I have a trendline, exponential, and displaying the formula on the grap...

Last reply on 21 Dec 2011 by
weenie

Multiple conditions multiple worksheets vba

Hello, I've a small macro which I cannot get working. I would like the macro to copy from sheet 1 anything that has the country code 'ITA' and is ...

Last reply on 20 Dec 2011 by
TrowaD

Excel - delete info from a cell found in anot

 Solved

Hello, Hello, I need a solution for the following situation: See attached screenshot from my Excel spreadsheet. I would like to know if the...

Last reply on 20 Dec 2011 by
TrowaD

Cut &past data from sheet to shhet depending

 Solved

Dears, I'm a novice in M* Excel. Still, for day to day followup purpose, I need a macro and/or appropriate solution that does the following: For...

Last reply on 20 Dec 2011 by
Sibsanne

Need some help comparing rows from 2 tables

Hello, i have 2 tables... table 1 has sequential serial #s (a) and corresponding prices (b). table 2 has the same serial numbers (a) (used multi...

Last reply on 20 Dec 2011 by
venkat1926

Find and display match text between columns

Hello, I have a work sheet listing Client names in column A and IP for each client in column B. Column C has a list of IPs which I need to match ...

Last reply on 20 Dec 2011 by
RWomanizer

Text look up

Hello, Question is in Excel Sheet 1 Sheet 2 A ...

Last reply on 20 Dec 2011 by
RWomanizer

Updating data to multiple workbooks

 Closed

Hello, I have data being populated into my main workbook - saved as Shrink Summary (mm/year).xlsm in total 56 rows in 3 different groups. Start r...

Last reply on 18 Dec 2011 by
pcsces

Question on linear interpolation

Hello, I have 2 columns with values and I need to find linear Interpolate values (Voltage) at the 4 different values @ 100nA, 1uA, 10uA, 100uA. Look...

Last reply on 16 Dec 2011 by
weenie

Forgot my mobile secuirty password

 Closed

Hello, sir I forget my mobile phone security password model is nokia 2730 sr no.358314/03/844784/6 pl provide me my password than open m...

Last reply on 16 Dec 2011 by
Ambucias

Finding words in excel cells

Hello, Hello, I'd like to scan a column for any word that's in a list in another sheet and put a code (e.g. "A") on the cell next to it each tim...

Last reply on 15 Dec 2011 by
rizvisa1

Miscrosoft 2007 outlook - windows xp sp3

Hello, i am trying to send emails from sage accpac ( Financial application) & keeps getting message " Deny or allow to send message" extremely annoyin...

Last reply on 15 Dec 2011 by
agent

Excel help?

Hello, I have a pivot table that lists items I sell at auction. After the auction ends I need to produce invoices to all buyers and I want to wri...

Last reply on 15 Dec 2011 by
Franc

How to do html tagging in excel

Hello, Guys pls do help me i have one sheet with lots of details in it and for eg in row 1 from cell A1 to A100 has different content but i need t...

Last reply on 15 Dec 2011 by
RWomanizer

Deleting rows with negative numbers

Hello, I would like to delete spreasheet rows if column H contains a negative number and the line above it in excel. Please help! Configuration...

Last reply on 15 Dec 2011 by
RWomanizer

Convert multiple rows and columns to one colu

 Solved

Hello, I have some data in excel sheet. Here is the example. 480,000 600,000 720,000 520,000 650,000 780,000 300,000 375,...

Last reply on 14 Dec 2011 by
venkat1926

Excel formula

Hello, I want to set up a formula to send information from one sheet to another in the same workbook. The information in the source worksheet is...

Last reply on 14 Dec 2011 by
rizvisa1

2010 excel cell color changing

Hello, I have a spread sheet that has due dates, I want to change color of cells to reflect time due eg: time of due date red 5 days before due...

Last reply on 14 Dec 2011 by
rizvisa1

Color code excel cells according to scores

 Solved

Hello, How do I color code cells in excel ti turn colors according to scores--such as red (0-69%), yellow 70-89%), green 90-100%)? Thank you, E....

Last reply on 13 Dec 2011 by
venkat1926

Match excel columns containing names

 Closed

Hello, Using Excel 2010 and I have 2 lists - 1 from phpmyadmin with a list of names entered by my users and a second list from my courier company ...

Last reply on 13 Dec 2011 by
Ambucias

Updating 1 excel spread sheet usng 2nd sheet?

 Closed

Hello, I have 2 excell spread sheets, bothare mailing lists. i woould like to match firstand/or last names from the 2 lists inorder to be able to u...

Last reply on 13 Dec 2011 by
Ambucias

Can i delete text up to a character in excel

 Solved

Hello, Is there a way of deleting all the text up to a certain character in excel. i im trying to import a CSV file in to exchange and need it tyding...

Last reply on 13 Dec 2011 by
Mahek

Excel - fill column in list based on criteria

Hello, I am trying to fill a column in a list, based on criteria. Example: In Table 1, I configure the criteria: If string contais "aaa" ...

Last reply on 13 Dec 2011 by
venkat1926

Compare columns

 Solved

Hello, I have a situation like below. Column A Column B Column C A1 1 A2 ...

Last reply on 12 Dec 2011 by
thomaswinter85

Excel: match data/copy to another worksheet

Hello, Can someone help me with this please? : ) I'm using 2 worksheets: On 'Tab A' I have: Column A Column B Notification Product Even...

Last reply on 11 Dec 2011 by
venkat1926

Memory card password forget

Hello, my 2GB memory card password will be forget pls help me C2-00 mobile model number Configuration: Windows 7 / Internet Explorer 8.0

Last reply on 10 Dec 2011 by
pcsces
Results 5651 - 5700 out of a total of 12,264