Excel Forum
-
Compare columns Closed
Hello, I have two columns of IDs. Column A is the bigger of the two. Column B has IDs that are part of Column A. How to produce all IDs that are n...
-
EXCEL-MACRO link between 2 documents Closed
Hello, I am working on a table(in document A) which needs to be referred to another document(document B, not sheet 2 of document A). I used macro to...
-
Macro help Closed
Hello, I'm very, very new to vba. I have 2 worksheets. Sheet one has a long list of invoices and details. In sheet two I would like to have a user i...
-
2 spred sheet- 1 pivot table Closed
Hello, I have 2 sheets in a file and both have some similar data in columns and some colums are diferent in both sheets , now i want to manage bot...
-
Assign Value to Variable (Excel VBA) Closed
Hi I have a variable name CountNumber. I want it to have a value from the formula "count from A2:A500 range. How can I write the code in VBA with...
-
Excel 2000 Question Closed
Hi there, hope i can get some help with this. i have office 2007 at home and have created a sheet,....but my excel 2000 at work wont let the cond...
-
Disable buttons in Macro Closed
Hello, I want to know how to disable the buttons or grey them out in the macro window, when we click on Tools > Macro > macros > we get the window...
-
Open specific xl spreadsheet Closed
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 ...
-
excel formula help Closed
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...
-
load sheet with drop down menu Solved/Closed
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...
-
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...
