Excel Forum
-
Excel Formula [Closed]
Hello, I need to calculate between two columns. Such as: If there is written (A2:A100) "aminul", then count how many times was written (B2:B100)...
-
Excell 2007 thinks too much [Closed]
Hello, How the heck can I prevent this from happening? My entire office has a problem with this. Sometimes when entering info into a spread...
-
Can't print my timesheets [Closed]
Hello, I try printing the whole report and it only prints the last 2 colums on my PC
-
using nested if to blank out adjacent cells [Closed]
Hello, I would like to use a formula to blank out adjacent cells if a specific value is entered for example: I have cells A1, B1, C1 If I...
-
Access 2003 VBA Idiot [Closed]
Hello, as the title suggests, I'm a VBA idiot. I don't know jack about it. other than to create a macro and convert it. here's my problem: I...
-
Urgent in excel [Closed]
Hello, I want help you Please I have 35 Trainings and I Planned them to The next year in Every month I put the training The answer how I can...
-
Matching two worksheets [Closed]
Hello, I have two worksheets one contains invoice numbers and payments and the other has invoice numbers and charges. On my charges worksheet...
-
Excel Formula for prices [Closed]
Hello, I really don't know how to create formula for my task: Item bouth for Total price £535,000 (comission + price) How much is the...
-
browsers do not work but im conected to the i [Closed]
Hello,Everyone ive been having this problem for 4 days now. i have an IMicro desktop computer, w/ windows vista and i recently upgraded to two...
-
need a macros to be used in excel [Closed]
Hello, I want a vbscript for a macros to be used in excel which would do the following operastion: It will find the characters/delimeters in...
-
Excel - Summarising Roles for a Roster [Closed]
Hello, I am creating a spreadsheet that will be used to assign rosters and keep track of staffing levels. I have finished most of it but have...
-
directional macro [Closed]
Hello, I'm trying to figure out a macro here. Pretty much, I'm importing a lot of data into an excel spreadsheet and then I want to copy and...
-
Macro Help- Copy, Analyze, Create Graph [Closed]
Hello, I'm trying to write a macro that will take an xls file that has only one sheet, create a second worksheet within the excel file, copy...
-
Need Macro to sort thru raw data [Closed]
Hello, I have a POS data file that I'm not sure how to approach. The data columns are not specific and the data loops across a few rows. What I...
-
Need Help in Excel [Closed]
Hello, I have two excel sheets with around 8000 columns in one sheets and 2000 columns in second sheet. All the columns of second sheets are...
-
Explorere Browser changes size onscrn [Closed]
Hello, I am on an acer aspire and the screen changes size when a 4 headed arrow pops up- yes even when only one finger is on the cursor pad - how...
-
copy required data from one excel to anther [Closed]
Hello, i want to copy only required feilds's data from one excel sheet to another. suppoes there are 5 feilds in the excels ,now i want to use...
-
excel [Closed]
Hello, when users enter a date in excel using this format 12-01-2008, i need the cell to automatically change the format to 12/01/2008 i...
-
Excel - dropping zeroes from time [Closed]
Hello, I have a set of times in column A in Excel (HH:MM:SS). In column B I need those same times, not rounded, to have 00 as the Seconds...
-
Calculate the sum of rows using macro [Solved/Closed]
Hello, I need some help with the folowing problem. I have a table with changing length of rows and columns. I need to calculate the sums of the...
-
macro to find lowest level from Hierarchy [Closed]
Hello, please see the excel file i have below i need to search the lowest level from the heirarachy level list which i have as output of my...
-
End of Excel data throurh VBA [Closed]
Hello, Is there any method to find a particular value in the excel through VBA. Alternatively: how can i get the colunm and row of the cell...
-
excel worksheet [Closed]
Hello, I have to update the excel worksheet column which has prices of all the products. ill give the example: I have a list that contains :...
-
How i connect many worksheet in a single work [Closed]
Hello, Sir, I'm Robin Sarma and i have problem in MS-EXCEL, Sir, how i connect many worksheet in a single wokbook
-
Editing be done in particular sheets [Closed]
Hello, I have 4 sheets in a workbook, one sheet where i would input the parameters name it Input, & other sheets where it would b...
-
Referencing multiple Cells to one cell [Closed]
Hello, I have a table of values that i have screenshott here, for you: http://tinypic.com/images/goodbye.jpg I also have what resembles a...
-
excel formula [Closed]
Hello, i want to count some cell but if 2 conditions are meet.
-
Excel Sheets lookup/macro [Closed]
Hello, I have a excel spreadsheet with around 50 sheets. In each sheet, in square D3, there is a name of the person who that sheet applies to....
-
can't get worksheetfunction to work [Closed]
Hello, i have a column of data where i am trying to find the maximum for each 96 values. you'll understand this better when you see my macro...
-
unable to paste excel on my local HD [Closed]
Hello, I copied excel file from the repository of our company and wanted to paste it on my local HD. When I right click on the desktop, the paste...
-
Macro comparing two columns [Closed]
Hello, I am trying to compare two entire columns in excel, Column A and Column B. If any cell in column A= Lead and any corresponding cell in...
-
urgent help needed in excel [Closed]
Hello, please help me out with this.. formula to find out a value from the list of values in an column. will appreciate a quick...
-
excel [Closed]
Hello, if i want the same result in cell E1 as in C1 what should i do for eg : January ...
-
Hypelinked Combo Box in Excel [Closed]
My Query is I Have made a Combo Box in Excel Sheet 1 in that Combo Box i have 2 sheets Sheet 1 and Sheet 2 . Now i want to Hyperlink...
-
Matching cells [Closed]
Hello, I would like to know if there is any formula for this situation. I have Column A: account numbers. Column B: Account Balance ...
-
I want Excell to Calc based on Input Data [Closed]
Hello, I want to be able to put in a number and then excel does a cal all in one cell. I know I could put 6 in C3 then in D3 put...
-
Spreadsheet [Closed]
Hello, I'm currently working on a spreadsheet for a timesheet. I want to format a cell to display the date of a certain day of the week. e.g....
-
stopping at bottom of spread sheet [Closed]
Hello, I often have to format a whole column with the same formula. I click the corner and pull it down which works fine. The frustrating part is...
-
Excel 2003 VB Macro for finding txt strings [Closed]
Hello, I am trying to write an Excel 2003 Visual Basic Macro that searches a cell for a particular word. But the cell contains several words. So I...
-
Help using Excel Macro To Insert Rows [Closed]
Hi, I currently have over 7000 rows of data, displayed similarly to this: Iten: Value Value Value Apples ...
-
Macro variable help [Closed]
Hello, I have declared a variable Dim x As String x = Cells(x + 10, 10).Value I am getting the value of a cell in x. I want to use that...
-
macro or formuale help required comparing cel [Closed]
Hello, I've got Excel 2003 with 2 columns of data A & B with people names in it. Column A is always populated with data (a name), column B isn't...
-
Copying the first four columns data [Closed]
Hello, I want to copy the first 4 column of data from one sheet to another sheet in the same excel. Basically the first 4 columns of data in...
-
Format Cells Excell [Closed]
Hello, I would like to format a cell in excell to accept dd/mm/yyyy or just yyyy. Excel 2007 using windows vista premium. If not excel, I...
-
Conditional Formatting (more than 3) in Excel [Closed]
Hello, I want to select a colom containing discription's Example (HATS)(bats)(cats) if this criterea is found i want the rows to the left that...
-
Relative Sheet Reference [Closed]
Hello, I am trying to write a macro (new to VB) that shifts contents in a branch layout to be aligned on the left, column A. I have this code...
-
Excel: Convert Oz. to milliliters inside Text [Closed]
Hello, I've been looking for a solution for the following issue: I have a very long excel list of product description that contain product...
-
naming range in a macro [Closed]
Hello, I am tyring to name a range say a14:d14 (working_cap_formula) and then copy of past into range a15:d15 (working_cap_paste). I have...
-
Cell Date Creates a New Sheet [Closed]
Hello, I am working on an excel worksheet for a construction project. I have an "Additional Work" worksheet set up so that I can enter a date...
-
How to create a clickable button and macro in [Closed]
Hello, I am trying to create a button in an Excel worksheet that will continuously recalculate the formulas on a given sheet. I have seen a...
