The discussions
Vba code for copyg rows
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:- i...
How to solve this problem in excel
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
Hello,
Browser icon buttons
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 over ...
Help with excel formula
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 numbe...
Copyspecified data from a ldif/txtfile2 excel
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 . Basicall...
Whatisthe formula to get higer number inexcel
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 numb...
Excel macro- need help
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 with...
Need help in excel
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 retu...
Creating a macro
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
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... Her...
Change sheet name in formula when copied down
I have a workbook made that has a 'Quantities' sheet that list any number of quantities along with 'contract quantity', 'current quantity', etc. Ther...
Excel data extraction macro needed
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 am ...
How to prevent enable/disable macro box
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
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 to do...
Excel 2003: match names; view unfound matches
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 with th...
Excel help!
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. A li...
Excel lists - extracting data from it.
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. The ...
Excel lookup
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 in e...
Excel blank row deletion
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
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 check ...
Count and summarise records in excel 2003
SolvedHello, 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 possible u...
Excel macros
Hello, how to code an excel macro where an if staement will hide appropriate rows? Any suggestions would be greatly appreciated. 1. Yes ...
I can use my browser only with ip address
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 probl...
Auto fill the range between 2 cells
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 Comp...
Repainting a cell using excel vba
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 a1 As...
Macro to copy and paste value every nth row
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 rows I h...
Create msg/popup to notify in excel vba
SolvedHello, 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 check...
Copy rows of data based on alpha condition
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 name...
How to check multiple cells to return value?
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 listed ...
Excel- merging running totals
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 boss ...
Converting date format in excel sheet
SolvedHello, 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?
Printing 1997-2003 excel files
Hello, I am running a new laptop loaded with Vista 64 bit and Microsoft Office 2007. When I receive an XLS file in 2003 format it uploads in the 1997...
Excel 2002 macro
Hello, Sub goalSeekSample() Dim seekValue As Double Dim changeCell As Range seekValue = InputBox("What's the value to seek?") For Eac...
Excel 2003 please help with concat dilemma
SolvedHello, I need one column to show the following text: prxyz,(Data1 here),0699,ABCD(Data2 here),xxx Data1 is in Column A and Data2 is in Column B....
Formatting macro
Hi, I have data ranging from "B8 to BZ616" all the data contains either "TRUE" or "FALSE", I do not want to use conditional formatting. my questio...
Moving data in excel
Hello, I messed up sone data in Excel. I have a contact list and now I need to move everything in columns C-F down 4 cells. All the addresses are off...
Excel
Hello, i need help in solving a macro issue. i have written a macro to delete rows base on a certain criteria. this is, "week 01", the issue is, wh...
Excel formula
Hello, I have a excel spreadsheet where I have 10,000 rows and columns are filled with data, column headers are Name, country,total users, total us...
Vba code
Hello, I am very very new to VBA, (although I did some VB in college), and am attempting to create an Excel Macro that will allow me to search thro...
Excel formula
Hello, i want to know a formula from which i can get the answer in text. For example if i right an amount in the cell A1 (100/-) i want the answ...
Excell
Hello, I have two sheet.. one is the master sheet containg the stock and the second sheet containing the sales invouice for a particular month...
Excel cells to individual rtf files?
Hello, I want to creat a VBscript in Excel that will move the contents of each cell in a column (A:1-A:10) to an individual RTF, and retain the for...
Compare two worksheet on conditional basis
Hello, I have to compare two worksheets on conditional basis. ex: worksheet1 having two columns loginname(col A) and date (col B) and worksheet2 ha...
Move cells to the next column
Hello, I have a report that comes already formated for printing. However, I want to be able to manipulate the data to analyze it. Currently the r...
Excel
Hello, How to find with a function in excel how many names starts with a , if i have these names in columns: Matt Sara Andi Gent Alex
How to comapre rows in excel?
Hello, I m new to this forum..guys pls help me out. I wany to compare a row in one excel workbook with a column in other workbook. Can ny1 suggest...
Use sql query in excel macro
Hello, i have created a sql query using "new database query" in excel. i need to use that query in a macro and use variables in the query. the bol...
Dates in excel
Hello, Does anyone know if it is possible to program an excel date so that it will 'change colour' when the current/system date is within one (1) m...
Macros for beginners
Hello, i am a new member of this forum, need to learn macro programming in xl... can somebody advise links to get trained. rgds