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 ...
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...
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...
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 ...
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 ...
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...
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 ...
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...
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. ...
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 ...
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...
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 ...
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...
Hello, Sir, I'm Robin Sarma and i have problem in MS-EXCEL, Sir, how i connect many worksheet in a single wokbook
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...
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 ...
Hello, i want to count some cell but if 2 conditions are meet.
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 ...
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...
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...
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 ...
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...
Hello, if i want the same result in cell E1 as in C1 what should i do for eg : January Febra...
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...
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:...
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 ...
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 ...
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...
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...
Hi, I currently have over 7000 rows of data, displayed similarly to this: Iten: Value Value Value Apples x ...
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...
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...
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 ...
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...
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...
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 ...
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 ...
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...
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...
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...
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...
Hello, is it possible to connect or browse the internet without an internet connection?!!!!!!!!!!! please!! answer...
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...
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...
Hello, Thank you very much for providing gee pee 7310 pc suite link. But gee pee pc suite does not have any option for the browsing internet ...
Hello, Problem.... I'm entering dates into Excel. I need these dates date in the format "ddmmyyyy" with leading zeroes where the day is < 10 e.g. ...
Hello, can anyone plz explain to me how to connect phone to browse on pc or laptop...
Hello, How do I change one cell in a worksheet one and have it update the other worksheets at the same time within the same Excel file. Keith
Hello, i had one excel sheet which contains one tracker of four sheets. I want a formula to copy that data's from one sheet to other sheet au...
Hello, I have three work sheets with columns namley process code, process name, quantity produced per day. I need to create another sheet comprises...
DON'T MISS