Excel Forum
-
Excel Help [Solved/Closed]
Hello, Ok am not that experienced with excel, so if any one can helo would be great. I have a huge spreadsheet and i am constantly updating...
-
Checking a row of cells and reporting [Closed]
Hello, I have an audit spreadsheet listing rooms by the building its in, the room number and a series of answers to questions afterwards...
-
Excel Help [Closed]
Hello, In my Excel Sheet Column A-------------------Column B----------------Column C 10---------------------------10-----------------------...
-
Excel macro: copy between sheets [Closed]
Hello, I have sheet1 and sheet2. I want to create a macro: -copy Bx:Dx from sheet1 to sheet2 Bx:Dx -where x from 6 to "get count row...
-
Excel loop, inner loop [Closed]
Hello, I have an excel file that has data in a cell that looks like "abcd-123456-efghijk-7890". My problem is that i have about 2000 of this...
-
Macro problem!!! [Closed]
Hello, Can anyone help me with the following problem I need to build a macro that can do these steps. step 1: the macro has to start when...
-
any one know about graphs on excel? [Closed]
Hello, How on earth do you convert data from the new 2007 windows xp thing in to a normal bar graph. i need the x axis to say 'number of words...
-
I can't browse any part of microsoftwebsite [Closed]
Hello, I have problem with my browser, I can't open any part of microsoft website in spite of I can open other website. I have the same problem...
-
I need help creating an Excel formula [Closed]
Hello, I work in Human Resources and need to create a formula for Personal Time Off. The employees accure PTO time at the rate of 0.46 per...
-
Naming Cells [Closed]
Hello, TIA: I have 16000 data pairs in each delimited text file.. Which l have quite a lot of.. and l have the wriitten the code for opening the...
-
Template sheet with changing variables [Closed]
Hi, I am working on a project where I need to make county data sheets for an entire state with different data in each because of the changing...
-
Having Excel IF formulas print text and calc [Solved/Closed]
Hello, I am trying to get Excel IF formulas to print text and calculation based on true/false. Such as, if I have some dates, and I don't need...
-
Excel Formula [Closed]
Hello, I wonder if somebody can help me with a pretty basic (I think) Excel formula. I would like for it to go through column A and search for...
-
Dynamic seletion of rows [Closed]
Hello, I need to select the entire row based on cell value. Ex: Students and marks is avialable in one excel sheet. I need to display the...
-
excel macro to copy cell content highlighted [Closed]
Hello, I am trying write a macro assigned to a button that copies the content of a cell into highlighted cells. Please can anyone suggest a...
-
how to check 3columns data at 1 time [Closed]
Hello, how to check 3columns data at 1 time.for example:- ColumnA---------ColumnB----------ColumnC 87----------------15------------------...
-
inserting customer address to Excel invoice [Closed]
Hello, I have designed an invoice template in Excel and want to be able to import the customer name and address fields automatically (currently...
-
VBA code for copyg rows [Closed]
Hello, m gettg problm while copyg rows from one Excel sheet to another sheet. plz its urgt me if anybody have sol yhn plz snt me. my problm is:...
-
how to solve this problem in Excel [Closed]
Hello, how to check 3 column data together and it has to check the same 3 column and it has to give the result example ColA-----------ColB------...
-
vba conditional formatting [Closed]
Hello,
-
browser icon buttons [Closed]
Hello,i've been trying to get rid of the browser icon buttons like forward, back, mail, fav., n so forth. every time i use customize n move them...
-
help with excel formula [Closed]
Hello, i am working on a spreadsheet that keeps track of machine hours. i need help with a formula that when themachine hours gets to 3000. the...
-
Copyspecified data from a ldif/txtfile2 Excel [Closed]
Hi There Good Day! I am having ldif file and and i need to populate an excel workhseet with some selective data from the ldif file ....
-
whatisthe formula to get higer number inexcel [Closed]
Hello, Hello, i'm jai krishnan im having a big problem in excel 1. in column A i'm having set of numbers in Column B also Having some set of...
-
Excel Macro- Need Help [Closed]
Hello, Could anyone please help me with Excel Macro logic/ or if more generous with macro code for the following scenario: I have a Dashboard...
-
Need Help in Excel [Closed]
Hello, I am SHANU I will explain what i want to do please help me out if any know about it I have 2 Sheets in Excel in Sheet 1 the names are...
-
creating a macro [Closed]
Hello, I would like to know, how to copy a word and paste it into another cell using macro?
-
Excel Help: transpose cells by content [Closed]
Hello Forum, I am struggling! I am trying to find a way to get a current column of data transposed into seperate columns of the same genre... ...
-
transpose column data every 9 cells [Closed]
Hello, I have 2 columns to transpose. The column A contains Date1..Date9..repeated. The column B contains the data I need. Country ...
-
Change sheet name in formula when copied down [Closed]
I have a workbook made that has a 'Quantities' sheet that list any number of quantities along with 'contract quantity', 'current quantity', etc. ...
-
excel data extraction macro needed [Closed]
Hello, Hie .I am working on a project in which l have to compare dates in excel and enter the difference (in days)in time in a separate column .l...
-
How to prevent enable/disable macro box [Closed]
Hello, Can anyone tell me how to prevent the enable/disable macro box from appearing when I start Excel. Thanks Marcos
-
Excel 2003Advanced Filter....copy to location [Closed]
Hello, I am trying to use the Advanced filter...and copy the info to different worksheet. It's not working out for me :( I have been trying...
-
Excel 2003: Match Names; View Unfound Matches [Closed]
Hello, I need formula or macro configuration help for Excel 2003. Within a spreadsheet, I want to compare the list of names in column A...
-
Excel Help! [Closed]
Hello, I'm working in Excel 2007 and having some issues doing what I need to do. I have a speadsheet that has a list of users in column A. ...
-
Excel lists - extracting data from it. [Closed]
Hello, I hope someone can help me! I have a long list of items in one column. next to each item I have to give certain values to some of them....
-
Excel Lookup [Closed]
Hello, I am using excel for analysing my data. I have time in column A and temperature in other 10 columns. I need to find the maximum value...
-
excel blank row deletion [Closed]
Hello, Can anyone provide the macro code for deleting all the blank rows in all excels in a folder?? thanks...munni
-
Macro to check conditions in two columns [Closed]
Hello, I am trying to update prices in excel spreadsheet. I have three different Unit of measures (Each, Pack, Case), I need a macro that will...
-
Count and summarise records in Excel 2003 [Solved/Closed]
Hello, Sorry to bother you but I have a minor problem with a spreadsheet and I don't know how to resolve the issue or whether it is...
-
Excel macros [Closed]
Hello, how to code an excel macro where an if staement will hide appropriate rows? Any suggestions would be greatly appreciated. 1. ...
-
I can use my browser only with IP address [Closed]
Hello, I am using Acer Aspire. I tried to connect with Ethernet cable at home and today wirelessly to my work network and it works ok. The only...
-
Auto Fill the Range Between 2 Cells [Closed]
Hello, My Question is I Have Put One Range Like " 1 " in One cell and ending series " 10 " in next cell . Now I want the excel To Auto...
-
Repainting a cell using excel VBA [Closed]
Hello, I am writing a code in excel VBA to generate a report.I am totally new to VBA.Here's my code Private Sub CommandButton1_Click() Dim...
-
Macro to copy and paste value every nth row [Closed]
Hi all, I need to copy cell value in D:1 onto a range of cell (O:3 to O:31) and from D:34 onto (O36: to O66) and so on... i.e. every 33...
-
Create Msg/Popup to notify in Excel VBA [Solved/Closed]
Hello, I need a Excel VB script to notify/popup a message when the number of the letter U on a calendar exceeds 6, 8, 12 etc. It will have to...
-
copy rows of data based on alpha condition [Closed]
Hello, I have a summary worksheet that houses all records. I'd like to break that summary worksheet into in multiple worksheets grouped by last...
-
How to check multiple cells to return value? [Closed]
Hello, I am a basic Excel user. I have an Excel sheet which displays a hierarchy of our institution's org units. The org unit names are...
-
Excel- merging running totals [Closed]
Hi there! First, I need to know if what I want to do is even possible. I have about 10 excel sheets- each with two running totals on them. My...
-
converting date format in excel sheet [Solved/Closed]
Hello, I have a cell which contains date in the format dd/mm/yyyy, but i need to convert to mm/dd/yyyy in excel how can i do this?
