Hello, Plse help! I save info from one spreadsheet to another.When i press the save button and the info goto sheet 2 and the word "filter" appear in ...
Hello, Dear Sir I am beginner in excel i have a question i want in a cell if i type a number in a cell and press enter the cell should contain "hel...
Hello I have the userform1, and a combo box linked to two cells callled "UNIVERSAL BOL" AND "BLANK BOL", plus two sheets called "BOL" and "BLANK BO...
Hello, I have one excel sheet, data of material receipts which is maintained by warehouse, ID is purchase order Number which is unique, and another...
Hello, I have two excel sheets. Sheet A with all the IDs and sheet B with volumes of IDs and corresponding datas about them. The ID values in sh...
Hello, I am trying to pull/filter a subset of names (formatted "First Last") where a matching name is found in a second column. I have tried using...
Hello, I have a worksheet which will have certain status like incomplete, rejected or approved in the Column C. If the status is rejected or inc...
Hello, I have an excel with 9 worksheets i wanted to vlookup in all the sheets from the 9th sheet if found any new cell it should add automaticall...
would like to ask on how to do in excel this matter: i have three excel file named AA, BB, CC from AA i will remove the name in A1 cell and plac...
Hello, i have one excel sheet which is having two columns, but in third columns i want to show the missing no. how, pl send mi the tips or any formu...
Hello, Can someone please give me some guidance on how I can do this? Let say I have: Sheet1 : usergroup a user xx1 xx2 xx3 xx4 x...
Hello, I have a task to move several cells in a few column to the far right column (like below) Number of column can be up to 25. ...
Hello, I want a formula to select a certain sel if today's date falls between a date range. For example: today's dat is 16/6/2010 and if falls bet...
How to protect only one particular column in worksheet?
Hello, date time value 05/11/2008 205 102 FALSE 05/11/2008 205 110 TRUE 05/11/2008 205 108 FALSE 05/11/2008 240 123 TRUE 05/11/2008 240 104 FA...
Hello, i have a date that contain 8 column and 26 rows, i want to post this data to an other excel sheet through a botten Configuration: Windo...
Hello, I have an Excel spreadsheet that I need a Macro for. The workbook contains 6 worksheets (5 data entry sheets and 1 overview sheet). I nee...
Hi all, I am new in excel macro programming. I need a macro for update the pending works lists as describes below. ####### Master Sheet(Work...
Hello, what is in the botton right hand corner of an active cell? Configuration: Windows XP / Internet Explorer 8.0
Hello, Dim lAtRow As Long Dim lThisRow As Long Dim Cell As Object dim something as integer etc Dim lAtRow As Long Dim lThisRow As Long ...
Hello, I have a text box on which i write a word, whenever i enter a work in text box and hit enter I want it to trigger the macro that i have....
Hello, I am working on a spreadsheet and dealing with cells that don't just have the date in them they also have other information in the same cell....
Hello, how to remove seekbrowser from mozilla fire thankyou
Hello, I want the enter button in my keyboard to triger macro in my excel file when i write any work in the text box field and hit enter it that...
I have a spreadsheet that i'm supposed to "automate" because the source keeps changing I'm not sure how to so.. I'm here.. I need to figure out a way ...
Hello, I would like to create a macro in excel to automatically insert a new blank row immediately after the last row of filled-in data and for th...
Hello, I have 24 cells(12 historical data and 12 forecast data) row-wise and they are not in continuous order. I need a macro code that would make...
Hello, The book must be able to, select automatically files or rows according to a title somewhere in the sheet. For example A ...
Hello, Please help me write a macro to sum the numbers in a column . Thanks ,
Hello, I want to insert a whole row below each found "input" in a coulumn. ie. A Time Elapsed 0:05 0:05 0:10 0:05 ... and ...
Hello, I have this code that i can not get to work all the way i get the error of "Too many local, nonstatic variables" i am new to this and all i...
Hello, I need help, i have macro in that file Column A already i have 10 lines of data. again i have to include few data for that how can i fine n...
Hello, I have a table in which every number from 1 to 52 expresses a specified text For example 1 = Sofia 2 = London ... I n...
Hello, here is my hijackthis log, I am currently in safe mode. Please help, thanks. Logfile of Trend Micro HijackThis v2.0.2 Scan saved at 7:29:57...
Hello, I am trying to copy data on one worksheet that is in a column to a separate worksheet that is in a row. Worksheet 1 B C O...
Hi, Can some one help me? I have a data with 2 worksheet 1)Data source 2)Data with header I would like to know how can i match the header wit...
Hi, I need a macro coding for the below scenario. In column D(Application) i have created a validation in which i have included the list of appl...
Hello, i want to create a macro to show the data from the sheet in a dialog box. Let suppose i have a sheet where i record the rent information a...
Hello, okay, say i had six new customers and out of six i closed three on a sale. that is closing 50% of customers. so, if V12=6 AND X1...
Hello, I have a macro that chooses dates from a field which is a general download from our information system. It then sorts the dates Ascending, a...
Hello, I need to copy dates from a webpage, it is displayed as JUN 12,2010 00:31:26 and I need the same date in excel as 12/05/2010 00:31 I'm u...
Hello, I have data pulled from database to CSV file which can be opened with Excel. The date in the spreadsheet shows as "201003" in text format, an...
Hello, I use "=AVERAGE(B2:AR2)" to calculate percentages based on information from 40 sheets. Example, On one sheet that compiles the data from 40 she...
Hello, Please help me to find the solution in MS Excel.. I have 2 sheets..Sheet 1 contains the Column B-list of mobile Nos and ColumnC - the users...
Hello, I nee to remove formulae for calculating averages in cells; replace these with average value.
Hello Team , How to write a code in VB which will filter the visible cells after a autofilter has been applied .As my data range chnages with each ...
Hello, I am using Excel as a source for fill-in templates. I would like to restrict the view of the worksheet to one page (fax cover sheet etc). Is ...
Hello, I am trying to get excel to send an email with data based on 2 columns. I want it to look at column c and it the date is equal to or earli...
Hello, I have 2 columns of numbers and I need a way to find the first instance that a number in column 2 is greater than or equal to a number in c...
Hello, I created a calendar cell pop-up and I wanted to include it in a range of cells. However I can't figure out how to include an entire range of c...