Excel Forum
-
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...
-
get columns from one sheet to another Closed
Hello, i have one sheet with values in number of columns. Its columns may not change but its rows will increase. I would liketo get some o...
-
Excel:Sorting Closed
Hello, I have 2 columns with country names i need to find which country is most used and sort it DESC and by A-Z (most common used countries are m...
-
copy rows and paste in a single column Closed
Hello, I have multiple data rows and columns in excel format 0.00111 0.00111 0.00111 0.000018 0.000018 0.000018 0.000017 0.0000...
-
Excel text to columns converting PM to AM Closed
Hello, I have a spreadsheet that has 9/11/2011 1:33:03 PM in the display bar, 09/11/11 13:33:03 PM in the cell. When I perform text to columns to...
-
Compare two excel Columns of differant size Solved/Closed
Hello, i am having two excel columns of differant size..Both the columns contain mobile numbers..i have columns A containing all the mobile numbe...
-
Macro help - search for text in Excel Closed
Hello, I've been trying to wrap my head around how to do this but haven't had any luck -- I want to search for text in excel in a spreadsheet of 40...
-
Excell mess Closed
Hello, I want a price from Column E if it has in Column F (next to it) the number 1 to go to Column Named GRoup 1 if it has number 2 tou go to Group...
-
Copy paste rows in Excel across worksheets Solved/Closed
Hello, I'm trying to create an excel macro that will copy a sequence of rows from 2 different worksheets and paste them in a third worksheet using t...
-
Excel Conditional Formatting VBA Closed
I am trying to format excel to do the following If A1 is "Bad" B1 to G1 Cell color is Grey If A1 is "Good" B1 to G1 Cell color is Green If D1 is ...
