Excel Forum
-
comparing columns in two excel files [Closed]
Hello, I have read through many of the solutions here, but cannot find one that works for me. I have two excel files containing different data ...
-
bring different number into another sheet [Closed]
Hello, I will try to explain myself in the best possible way. I have a spreasheet in excel. I also have a list of number like this: Cell C 2...
-
VBA EXCEL- copy and paste different documents [Closed]
Hello, I need ugent help in this task! The only thing i have to do now is to copy and paste range of texts from one document to another by using MACR...
-
Excel [Closed]
Hi, Can anyone help , How can i search value in x column of sheet1 by that value how can i insert y column value in sheet 2 For Ex: N...
-
Delete all rows where qty = 0 [Closed]
Hello, I have a HUGE spreadsheet (60K lines). If column "E" = 0, then I want to delete the entire row. I've worked on this for a couple of days ...
-
EXCEL SPREADSHEET NEED FORMULA PLEASE : ( [Closed]
Hello, I am STUCK and it's driving me bonkers!!!! I have a 2003 EXCEL SPREADSHEET ISSUE: If Column B (FROM worksheet TEST PAGE 1) MATCHES wh...
-
excel 2007- compare columns - return values [Closed]
Hello, Excel 2007. I have 5 columns A, B, C, D and E. Column A and B are of equal length, column C is longer. Columns D and E are still empty. ...
-
formula to dup information between sheets [Closed]
Hello, I want to be able to type information into one sheet in an excel doccument and then based on the information i input into column E have it ...
-
Background color of cell in Excel [Solved/Closed]
Hello, I am trying to write a simple formula that will give me the backgroud color of a cell (in Excel). Something along the lines of, if background ...
-
Cannot browse or see my flash [Closed]
Hello, Respected all I tried allof your solutions They are based on the fact that the system can SEE the drive. In my case it detects it but does...
-
EXCEL VBA copy button to another document [Closed]
Hello, Bascially, I created a button in Document A which can help me to sort a table ( the button consists of VLOOK UP in data from another document...
-
Transfer from one sheet to another. [Closed]
Hello, I have an Excel workbook that I need help with. On sheet one I have a column with client's names (B6-B35, B37-B66). On this same sheet I ha...
-
copy command within a macro [Closed]
Hello, I built a macro to copy data from a worksheet tab to another tab. The size of the data file varies so bult the macro like this but it still o...
-
Sorting and combining rows... [Closed]
Hello, I have to sort rows based on their cell values in MS excel For ex.: Task Style A B C D E...... 12 1 0 2 4 3 45 ...
-
Need to chose one data element from 3 columns [Closed]
Hello, I have an Excel spreadsheet where I want to populate Column D on my spreadsheet. Column D should be populated by 1) Column A if there is a ...
-
browsing problems [Closed]
Hello, my name is Edward and I have Cect5188(china mobile), how can I activate and use operamini for free? Configuration: Linux Mandriva / Fire...
-
copy and paste vba button [Closed]
Hello, im aiming to create a button which allow me to input data from the other document. However, the simple "copy and paste" doesnt not work nor t...
-
One Column formula different rows [Closed]
Hello, I have one formula for a column and 100 rows. The formula takes data from several different column cells on the same row. If I want to use...
-
Conditional formatting/Formatting in VBA [Closed]
I need some help with Conditional Formatting/Formatting using VBA. I need a VBA code that will look at one cell and set the conditional formatting ...
-
Usding Macro to pull information to worksheet [Closed]
Hello, I am new to excel. I want to create a function in my spreadsheet (Sheet1), that when I click on a button it pulls information from Sh...
-
How to add time reminder in excel file [Solved/Closed]
Hello, I have made a work to do list and I would like excel to remind me at every task time. as I have made a column for work to do item and ti...
-
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 ...
Subscribe To Our Newsletter!
DON'T MISS
- How to Upload High Quality Photos to Instagram
- How to Disabled Write Protection on a USB
- How to Get More Followers on Instagram
- How to Install a VPN
- How to Recover Your Yahoo Account
- How to Get Free Diamonds in Free Fire
- How to Create a Gmail Account
- How to Recover a Disabled Facebook Account
- Facebook Code Not Received
- Computer Boots to Black Screen
- How to Fix a Blurry Snapchat Video