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...
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...
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...
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...
Hello, I would like to know, how to copy a word and paste it into another cell using macro?
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...
Hello, I have 2 columns to transpose. The column A contains Date1..Date9..repeated. The column B contains the data I need. Country xxxx State ...
I have a workbook made that has a 'Quantities' sheet that list any number of quantities along with 'contract quantity', 'current quantity', etc. Ther...
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 ...
Hello, Can anyone tell me how to prevent the enable/disable macro box from appearing when I start Excel. Thanks Marcos
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...
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...
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...
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 ...
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...
Hello, Can anyone provide the macro code for deleting all the blank rows in all excels in a folder?? thanks...munni
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 ...
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 possible u...
Hello, how to code an excel macro where an if staement will hide appropriate rows? Any suggestions would be greatly appreciated. 1. Yes ...
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...
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...
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...
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...
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 check...
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...
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 ...
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 ...
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?
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...
Hello, Sub goalSeekSample() Dim seekValue As Double Dim changeCell As Range seekValue = InputBox("What's the value to seek?") For Eac...
Hello, 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....
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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
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...
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...
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...
Hello, i am a new member of this forum, need to learn macro programming in xl... can somebody advise links to get trained. rgds
Hi there friends, I have a excel spread sheet that i am using to keep track of sales. What i need is a formula or function that will check a lis...
Hello, I'm trying to write a macro for use in Excel that will take the data as shown in fig 1. and consolidate as in fig 2. to another worksheet w...
Hello, allot of times i copy and paste from web doc to excell (eg with bank statements) the column with the money is not recognized by excell as a num...
Hello, Our company uses a wireless router. My business partner who uses Vista can connect to the internet with no problems. I however cannot...
DON'T MISS