Excel Forum
-
Excel formula generation [Closed]
Hello, I have data spaced 264 rows apart that I need to extract from a massive mess of data. Basically, I need to tell excel to pick info from cell...
-
Excel 2007 Please help! [Closed]
Hello, I am in Excel 2007. I have data from a formula returned on approximately 200 rows in column K. Because the forumla is only true for s...
-
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...
Subscribe To Our Newsletter!
DON'T MISS
- Computer Boots to Black Screen
- How to Create a Gmail Account
- How to Install a VPN
- How to Get More Followers on Instagram
- How to Disabled Write Protection on a USB
- How to Fix a Blurry Snapchat Video
- Facebook Code Not Received
- How to Upload High Quality Photos to Instagram
- How to Get Free Diamonds in Free Fire
- How to Recover Your Yahoo Account
- How to Recover a Disabled Facebook Account