Excel Forum
-
Need vbcode to compare excel sheet and access Closed
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...
-
Excel extraction Closed
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...
-
Compare names for match in 2 columns Closed
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...
-
Deleting empty rows in excel Closed
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...
-
macro to vlookup Closed
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...
-
excel code Closed
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...
-
excel formula Closed
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...
-
Multiple columns into rows Closed
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...
-
Excel Move Cells to Right. Solved/Closed
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. ...
-
community help with excel Closed
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...
-
Protecting column in worksheet Solved/Closed
How to protect only one particular column in worksheet?
-
EXCEL 2007 FIND MAX VALUE Solved/Closed
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...
-
post a data to an other sheet. Closed
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...
-
Copy and paste macro into the next open cell Closed
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...
-
Required help for writing a excel macro Closed
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...
-
excel definitions Closed
Hello, what is in the botton right hand corner of an active cell? Configuration: Windows XP / Internet Explorer 8.0
-
need explaination how macro works thanks! Closed
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 ...
-
Excel Activex Textbox1 question. please help! Closed
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....
-
Excel Formula Closed
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....
-
how to remove seekbrowser from mozilla fire Closed
Hello, how to remove seekbrowser from mozilla fire thankyou
-
I want the enter key to triger macro,pls help Closed
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...
-
Excel Macro to sort columns of diff category Closed
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 ...
-
Excel Macro to insert a new row Solved/Closed
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...
-
Excel Macro Closed
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...
-
adding files or rows of my selection excel Closed
Hello, The book must be able to, select automatically files or rows according to a title somewhere in the sheet. For example A ...
-
Sum of numbers using macro Closed
Hello, Please help me write a macro to sum the numbers in a column . Thanks ,
-
Macro to Insert a row below Closed
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 ...
-
Help with If VBA Statement Solved/Closed
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...
-
Macro for Select next line Closed
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...
-
Excel function or macros Solved/Closed
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...
-
Browsers not working Closed
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...
-
Link column data to row cells - formula Closed
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...
-
Create sheet base on the header Closed
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...
-
Macros Solved/Closed
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...
-
Macro to show nonzero data in dialog box Closed
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...
-
excel formula Closed
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...
-
Macro, Range Selection Closed
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...
-
Date copy issue in excel Closed
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...
-
Date wrong after converted in Excel Closed
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...
-
Excel Help with Percent calculations Solved/Closed
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...
-
MS Excel problem Closed
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...
-
Excel formula Closed
Hello, I nee to remove formulae for calculating averages in cells; replace these with average value.
-
How to copy visible cells after filter in VB Closed
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 ...
-
Select view in Excel Closed
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 ...
-
checking data in 2 columns and sending email Closed
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...
-
finding matching numbers in 2 excel columns Closed
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...
-
VBA language for a range of cells Solved/Closed
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...
-
EXCEL IF statement with % Closed
Hello, Im trying to get a formula for the following statment: A1 is Within 20% of net sales, then give it a score of 5 A1 bt. 21-25% of net sale...
-
Compare multiple cells and return other value Solved/Closed
Hello, a problematic case, when comparing values in multiple cells (rows) in Excel. In a single cell , "A1" I would need an answer depending on...
-
EXCEL: List Cell Number if contains number Closed
Hello, I need help here. Have tried everything I can think of and still not getting the results I need. I need a formula that will list the na...
