Excel Forum
-
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 cre...
-
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 ins...
-
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 I w...
-
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 Price o...
-
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 moni...
-
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 the ...
-
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 come ...
-
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 paste...
-
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 and pa...
-
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 ...
-
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 taken ...
-
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 mig...
-
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 only ...
-
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 have...
-
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 value. ...
-
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 rows ...
-
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 standar...
-
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 where ...
-
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 : ite...
-
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 updated. suppos...
-
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 query ...
-
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. I ...
-
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 below...
-
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 opt...
-
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 column ...
-
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 responce.. t...
-
excel [Closed]
Hello, if i want the same result in cell E1 as in C1 what should i do for eg : January Febra...
-
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 / vb...
-
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 Column C:...
-
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 =c3*178 but ...
-
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. I ...
-
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 tha...
-
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 can...
-
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 x ...
-
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 val...
-
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 alwa...
-
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 sheet1 ...
-
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 would...
-
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 coris...
-
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 that ...
-
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 with ...
-
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 set up...
-
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 in a...
-
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 button...
-
Internet conected but can't brows in day time [Closed]
Hello, Internet connected but can't browse during only day time . After 8 p.m. to 9 a.m.{appro.} i can browse easily My ISP is TATA broadband . Tat...
-
browse the internet w/o internet connection [Closed]
Hello, is it possible to connect or browse the internet without an internet connection?!!!!!!!!!!! please!! answer...
-
Macro iterate through with If [Closed]
Hello, I am trying to write a macro in excel but it has me completely stumped. I want to paste into column P the word 'resolved' for each cell wher...
-
Reagerding Macro [Closed]
Hello, I am using ofice 2003(Excel).While opening the excel every time i am getting a popup reagarding the enable macro option,what i am doing is set...
