Excel Forum
-
Excel- merging running totals [Closed]
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 ...
-
converting date format in excel sheet [Solved/Closed]
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?
-
Printing 1997-2003 Excel Files [Closed]
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...
-
Excel 2002 macro [Closed]
Hello, Sub goalSeekSample() Dim seekValue As Double Dim changeCell As Range seekValue = InputBox("What's the value to seek?") For Eac...
-
Excel 2003 Please Help With CONCAT Dilemma [Solved/Closed]
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....
-
formatting macro [Closed]
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...
-
Moving data in Excel [Closed]
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...
-
excel [Closed]
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...
-
Excel Formula [Closed]
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...
-
VBA Code [Closed]
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...
-
excel formula [Closed]
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...
-
Excell [Closed]
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...
-
Excel Cells to Individual RTF files? [Closed]
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...
-
Compare two worksheet on conditional basis [Closed]
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...
-
Move cells to the next column [Closed]
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...
-
Excel [Closed]
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
-
how to comapre rows in excel? [Closed]
Hello, I m new to this forum..guys pls help me out. I wany to compare a row in one excel workbook with a column in other workbook. Can ny1 suggest...
-
use sql query in excel macro [Closed]
Hello, i have created a sql query using "new database query" in excel. i need to use that query in a macro and use variables in the query. the bol...
-
Dates in Excel [Closed]
Hello, Does anyone know if it is possible to program an excel date so that it will 'change colour' when the current/system date is within one (1) m...
-
Macros for Beginners [Closed]
Hello, i am a new member of this forum, need to learn macro programming in xl... can somebody advise links to get trained. rgds
-
EXCEL x-reference [Solved/Closed]
Hi there friends, I have a excel spread sheet that i am using to keep track of sales. What i need is a formula or function that will check a lis...
-
Consolidate / resort data code for excel [Closed]
Hello, I'm trying to write a macro for use in Excel that will take the data as shown in fig 1. and consolidate as in fig 2. to another worksheet w...
-
excell [Closed]
Hello, allot of times i copy and paste from web doc to excell (eg with bank statements) the column with the money is not recognized by excell as a num...
-
Anti virus updates but cannot browse web page [Closed]
Hello, Our company uses a wireless router. My business partner who uses Vista can connect to the internet with no problems. I however cannot...
-
Excel Formula [Closed]
Hello, Is there an Excel Formula that can be used for the following: If Column F = Name and Column G and/or Column H Does NOT = Name or is NOT B...
-
Merging cells with formatted data in Excel [Closed]
Hello, I have a spreadsheet where I need to merge the data from 4 separate cells in the same row into one cell. The problem I am having is that Ex...
-
finding the same value in diffrent sheets [Closed]
Hello, I have one workbook with different sheets naming jan,feb, march...etc theese are montly timesheets. i need to find the last week total in s...
-
Excel macro help!! [Closed]
Hello, I'm having trouble with a Macro. Obviously..haha Anyways, What I'm Trying to do is copy a value from one spreadsheet, find it in another ...
-
Spreadsheet/Cell Question for Excel [Closed]
Hello, Can someone help me? I have an Excel spreadsheet with multiple sheets. FYI, I have renamed the sheets (for example, Sheet1 is now "Calorie I...
-
MS Excel codes [Closed]
Hello, I am having a problem about MS Excel. What codes should I type if I need to replace all cells with negative sums with ZERO (0)? Please help m...
-
Can't Ping but can connect w Browsers [Closed]
Hello, Somehow my ping command won't work. I can connect to websites with my browsers, programs - even PPP sharing programs ... but when I go to comm...
-
browse files [Closed]
Hello, hi i got a problem of my computer i been trying to apload photo on my friendster but when i click the browse files is nothings happen will you...
-
unable to browse network [Closed]
Hello, hi everybody, i m unable to browse network and can not enter in any system and no one system can enter inmy system. go to commnad prompt and...
-
dowloading an excel 2003 file in office 2007 [Closed]
Hello, I am in hotmail and I am trying to open an excel 2003 file and I can not... it just keeps getting file information, I am running win vista ...
-
Count number of cells matching to criteria [Solved/Closed]
Hello, I have two column lists (one value in each cell) the first { 1 2 3 1 2 2 2 1 1 1 } and the second {A B C C C B B A A C } and I am attempting...
-
Excel query [Closed]
Hello, I want to know how to copy a data from cell of one workbook to cell of another workbook which has same data in different cell? For exampl...
-
macro for copying column data into row [Closed]
Hello, I am new to Macros and need an urgent help regarding the same. my requirement is first to calulate the number of records present in the she...
-
Pasting the entire rows in another sheet [Closed]
Hello, I am making a report where in if the job status of an employee is Resigned or Inservice, so i want all details of that particular employee t...
-
How to hide only 2 cells using macros? [Closed]
Hello, I have a checkbox for which I have already assigned a macro: Private Sub CheckBox9_Click() If (CheckBox9.Value = False) Then ...
-
convert excel report into DB table format [Closed]
Hello, I am trying to format an excel report into database table format inorder to import the data into the database . do i need to use macros? Ple...
-
excel help [Closed]
Hello, i am new to using excel so if anybody is able to help please could you tell me in laymens terms so i know exactly what to put in each cell. Wh...
-
Excel help needed [Closed]
Hello, I have a one page spread sheet with 7700 lines and there are six lines that repeat themselves about 300 times. I was wondering if there is ...
-
convert excel vba code to open office star ba [Closed]
Hello, Please send me the solution to convert excel vba code to open office star basic.
-
Excel search and copy help [Closed]
Hello All, I have Excel 2007 I would like to search a column and if the search maches my criteria then I need it to copy the entire row to a dif...
-
Problem in Macro for formating error 1004. [Closed]
Hello, All I am new in forum, I am not a programmer or any macro expert but facing a problem with our ERP software which our company is using its gen...
-
copy range data against a value in excel [Closed]
Hello, I have a chemistry of 304 L,304,310 etc & I have to past this chemistry where 304,304l appears in sheet of excell. e. is as follows...
-
Excel problem [Closed]
Hello, dear sir,i have a excel problem.I have four coloums like: "month" "1st value" "2nd value" "total value" now some value like this ...
-
Excel interface with the real world [Closed]
Hello, I want to interface an Excel spreadsheet with the real world. For instance, in it's simplest form, I would like to enter a number in a cell i...
-
Trying to make a checkbook on excell07 [Closed]
Hello, I am trying to make a checkbook on excell. here are the columns I am dealing with c=credit, d=debt, and e=balance first how do I make d tur...
-
Excel Equation [Closed]
Hello, I am working on Excel spreadsheet and need help with the add formula in a specfic row. Does anyone know how to write it? Example: 1 1 ...
Subscribe To Our Newsletter!
