Excel Forum
-
VB Excel 2010 - Loop until can't find [Solved/Closed]
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...
-
excel transfer [Closed]
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...
-
Excel: locate value in one list & copy [Solved/Closed]
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 ...
-
Data Reshuffling of Cells [Solved/Closed]
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...
-
transfer data in one sheet to another sheet [Closed]
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...
-
Summary with data from different worksheets [Closed]
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 ...
-
I want to compare data in two sheets [Closed]
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 ...
-
Excel: If cells match use related value [Closed]
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...
-
Deleting multiple rows (2 rows and leave 1) [Closed]
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...
-
two worksheets compare info and insert data [Closed]
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...
-
problem with excel 2003 [Closed]
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...
-
List of sheet names used in one sheet [Closed]
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...
-
Changin format of date in excel [Closed]
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...
-
Macro Help [Closed]
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...
-
Compare columns [Closed]
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...
-
Microsoft Excel - Timesheet Help [Closed]
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...
-
Help for sorting top 5 values on Excel [Closed]
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...
-
Data from rows into columns [Closed]
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...
-
Code for Macro [Closed]
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...
-
Find missing data in 2 columns (Excel) [Closed]
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...
-
Excel letters relation to numbers [Closed]
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 ...
-
Excel 2007 Copy Multiple Columns into one [Closed]
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...
-
Creating a csv file with extract from excel [Closed]
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...
-
Excel Macro copy to cell based on criteria [Solved/Closed]
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...
-
Excel VB script to notify/popup [Solved/Closed]
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...
-
Microsoft Excel - Info Between Workbooks [Closed]
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 ...
-
Help for VBA [Closed]
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...
-
Excel 2007 not read [Closed]
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...
-
vb code to copy data from one sheet to anothe [Closed]
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...
-
SOLVED... didn't need a macro! [Closed]
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...
-
Excel Macro for deleting rows IF cells not... [Solved/Closed]
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...
-
Comparing value of a cell to a range of cells [Closed]
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...
-
Conditional Formatting in MS Excel [Closed]
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...
-
Paste inserting blank cells [Closed]
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...
-
Need Macro Coding [Closed]
Hello, I NEED SOULTION. i HAVE DATA LIKE BELOW FORMAT. A B Apple Apple Apple Apple ...
-
Excel - Select Last 25 Records [Solved/Closed]
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...
-
Auto Update Master Sheet [Closed]
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...
-
Excel - Removing different rows in 2 sheets [Solved/Closed]
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...
-
Excel [Closed]
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 ...
-
Compare columns and copy [Solved/Closed]
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...
-
Need to find correct Formula in Excel- Urgent [Closed]
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...
-
Excel filter with macro [Closed]
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...
-
Require Correct Formula in Excel [Closed]
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...
-
Creation of dropdown from dynamic list in VBA [Solved/Closed]
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...
-
Excel:Sorting2 [Closed]
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 ...
-
Avg multiple cells in multiple sheets - Excel [Solved/Closed]
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...
-
Macro to insert data to changing cells [Solved/Closed]
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...
-
how to insert 3 logical condition in excel,07 [Closed]
suppose in column g5 there is some values ranges 5 to 50, when g5
-
change date format in excel [Closed]
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...
-
Excel Merge Text files [Solved/Closed]
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...
Subscribe To Our Newsletter!
