Hello, We are trying to manipulate data from a very old DOS program. We have a lengthy macro that works well until the end where it seaches for s...
Hello, I have a problem. I want to transfer some data from the files to excel. I meant I have some forms from my colleages about their work ti...
Hello, I need some help with Exel. I have two lists: List one contains two coulmns: ID numbers and age. List two contains also two coulms: ID ...
Hello, Dear Friends, I need your help to solve the following problem. I have few files containing data of more than 50,000 records. Some rec...
Hello, how i can transfer some cells in one sheet to another sheet automatically. for example i have one sale report that i want to this information...
Hello, I have a file with 42 worksheets, all the same format (kind of "entry screens"). I need to create a summary table listing the data from all ...
Hello, I am stuck up with a problem in macro please do help me, I have 2 sheets with data i want compare two sheets, if the data is same it should ...
Hello, Here is what I need to figure out how to do: If the value of A matches any other cell in A then I need all matching columns to t...
Hello, I need a REALLY QUICK reply. I'm working on a worksheet in excel that has hundreds of rows and I want to delete every 2 consecutive rows an...
Hello, I have two worksheets and I am trying to find and compare information in one and then return the matching information to the spreadsheet fo...
Hello, I have a problem with excel 2003 I am trying to do this: i have a sheet with 20.000 rows and some of them (the rows with the died perso...
Hello, I have been given a model with 53 sheets, I want to check if the formulas are ok. I was thinking to make a flowchart or matrix to be able t...
Hello, Trying to chang the date format in 2007 Excel. The date looks like 05 Oct 2011/0630 and I was wanting 10/5/2011 6:30... Any help greatly ap...
Hello, I have created a sheet which contains all the details abt the customer and feed back received from the clients and the sales team, Each...
Hello, I need your help to resolve next problem: i have 5 columns (A, B,C,D,E) with these characteristics : 1. The length of all 5 columns are vari...
Hello, I was wondering if anyone could please help me with a problem I've been having, I would be greatful. I want to send info from one worksheet to...
Hello, I have office 2007 & I would apreciade if somebody could help me with my problem bellow! I have 3 columns, column A with names, column B with...
Hello, I'm not that great in Excel so I was wondering if there is a way to separate rows and move to different columns in Excel 2007/2010. I ha...
Hello, Can you please tell me how to write a code to select a statement in a list of statements in excel macro(code) Configuration: Windows...
Hello, I have two lists of data (patent serial numbers) that I need to compare and find the missing serial numbers. In Column A I have my databas...
Good evening I am making an excel spread sheet template for an assignment at college and I have hit abit of a snag. I want to express an answer in ...
Hello, I am trying to create a macro that will automatically copy multiple column lists into a single list. Let me clarify. Sheet 1 contains...
Hello, I need to extract data in a sheet called csv (A1:H6) in my excel workbook into a new csv file with a new name. The new name is generated...
hey everyone, I'm stuck. I hope someone can help me out today. I have an excel spreadsheet with 1400 rows. The first 3 rows are irrelevant (headi...
Hello, I want to have different cells in the worksheet have pop up messages/notifications when the date or deadline is reached. so when the 1 june 2...
Hello, I was wondering if it was possible to send info from one worksheet to another in Microsoft Excel. I know how to use the function =sheet!a1 ...
Hello, This question is related to MS Office 7. I want to write a code to validate codes used in transaction are present in master sheet or not...
Hello, i am using microsoft 2007 version ,but i want to convert my power point to 2003 version as my client does not have 2007 version . kindl...
Hello, My problem is similar to first one. I was able to solve with the solution provided by helper. thanks helper. But, if column Q contains blan...
Hello, Turns out no macro is needed... =INDEX(Sheet1!B:B,MATCH(A1,Sheet1!A:A,0)) I have a rather complex issue I'm trying to solve with a macr...
Hello, I need help to create a Excel macro. Basicly what I have is a sheet full with information about different departments and what I want to do...
Hello, I want to compare the value in a cell - B1 - to the values in a range of cells and return 1 if true and 0 if false. I set up $H$1:$H$14 as my...
Hello, Would appreciate if you could please help me with the entire process how to do do conditional formatting for one entire row- which contai...
Hello, Using VBA I want to copy a column with a variable length and paste into another column inserting 2 blank cells for every value pasted, like t...
Hello, I NEED SOULTION. i HAVE DATA LIKE BELOW FORMAT. A B Apple Apple Apple Apple ...
Hi I have a spreadsheet that is entered into daily a list of actions taken in a department. This needs to be printed weekly and displayed. Obviously t...
Hello, I am trying to prepare a master sheet. My problems is as below:- There are 4 different work stream owners and all of them have access to...
Hello, I have two worksheets containing a different number of rows. I want to delete all rows in sheet 1 that have a value in column A that c...
Hello, i want to highlight a cell if there is no value in the cell. I am using the isblank funtion in the excel but how do i set the color code ...
Hello, I need a Macro to do next : i have 2 sheets Sheet1 and Sheet2. In Sheet1 column A has a variable range of values i.e. A2 : A... Column B is e...
Hello, Received one issue on 29-Sep-11, the turnaround time to solve this issue is 6 working day. In my case A1-9/29/11 and TAT for its closure of...
Hello, I have a excel with different criteria , in which i have to filter according to three criteria's . * And finally i have to pick a ce...
Hello, Received one issue on 22-Sep-11, the turnaround time to solve this issue is 6 working days therefore the Expected date of Closure is 29-Sep...
Hello, I have been trying to make a Macro that can create a dropdown list from a dynamic list in column A. So far I've come up with the followin...
Hello, Would be very thankful if You could help. I have 2 columns with country names i need to find which country is most used and sort it DESC ...
Hello, I need to average multiple cells across multiple sheets, but not all are in the same column/number. I need to average B35,D35,F35 in Sheet 1...
Hello, I'm trying to write a macro in excel for inserting input text to a specified cell. I have already an InputBox specifying the text to be put...
suppose in column g5 there is some values ranges 5 to 50, when g5
Hello, Configuration: Windows 7 / Firefox 6.0.2 My spreadsheet has date in cells as: 7/1/2003 but displays as Jul-03. Need to have date in c...
Dear Forum Members, As I am not a VB expert I have copied some codes and edited to suit for my purpose. My idea is to combine many .pyc files in a f...