The discussions
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
How to comapre rows in excel?
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
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
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
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
SolvedHi 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
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
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
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
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
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
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!!
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
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
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
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
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
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
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
SolvedHello, 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
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
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
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?
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
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
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
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
Hello, Please send me the solution to convert excel vba code to open office star basic.
Excel search and copy help
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.
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
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
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
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
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
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 ...
Range in excel
Hello, how to sum the values of range eg; A B C 1 21-30 31-40 41-50 sum= 2 51...
Excel 2007 macros-first
Hello, I would like to create a MACRO-with the field AQ2 to AR2 -month AQ32 to AQ42--data similarly for all these AQ2 to AS2 till AQ2 to BA2.I ne...
Excellent router for gaming?
any advice for a good router for gaming purposes guys ???
Excel formula
Hello, If date changes in one file then it should take value from another file of same date. Please revert with excel formula and exmple. Reg...
Excel qualifying dropdowns
Hello, I am trying to build an order form for our suite of products using Excel. In order to make this as "idiot proof" as possible, I'm building ...
Excel - sorting 4 columns
Hello, I need some help with the data I have gathered from a form with a question with a multiple tick option. The data collected is similar to this...
Excel format
Hello, I have a spreadsheet with a column which is supposed to represent dates. However cells are of the format of 25 12 08 - this example repre...
Creating new rows/columns
Hello, hi I working on excel sheet of 2000 rows. I wanna insert more new rows in a colums whennever there is a empty cell between two cells u...
Print userform for multi-sheet printing
Hello, I would like to write a macro that prompts a UserForm to select which sheets/tabs to print from a workbook. This macro should identify the ...
Combine 7 excel's into 1 excel
Hello, I have 7 excel's .I need to combine all these into 1 excel under different work sheets.The column's are not same in any of the excel (entir...
Counting in excel
Hi Having a problem, I want to count the number of cells that starts with a certain figure, Example 90500-3 90400-3 400000-3 50000-3 30...
Copy of info from sheet to sheet
Hello, I'm trying to copy names from a sheet with adresses that are active to a new sheet which is to be used as a planer, so i can update the active...
Import into excel goes into first cell
Hello, Im having an issue with excel. My office has a database program where they export data into excel. one pc has the russian language install...
Excel -copy macro problem
Hello, I have developed a macro (attached to a button) that copies data from one row (cells D8, E8, F8 & G8) to a sheet called transmittals. Every ...
