The discussions
Seach for all worksheet and copy the name
SolvedHello, I'm trying to see if anyone can help me with this, I do have a master excel file that get info from other excel files, currently I have to d...
Ms excel 2007 - quick function question
SolvedHi Guys, So say you have 3 cells. A, B, and C. I'm trying to come up with a function to put in C that erases/blanks A if B is #N/A (IsError?). Can ...
Copy and paste certain columns based on dates
SolvedHello, I am trying to create a macro that will look at a list of dates in column B then copy and paste the data in column C and D to another sheet...
Hide columns
SolvedHello, I recorded a macro to hide some columns (says, column M to O). However, when I tried to run the macro again, the macro hide all the columns f...
Transfer of excel data from a row to another
SolvedHello, I have this excel sheet with numerous rows having columns A,B,C,D &E.column A is numbers & other columns hav data in text.I want to transfer...
Macro to copy and paste
SolvedHello, I would greatly appreciate any assistance with creating an Excel macro that will copy information from cells A1, B11:D11, A13, B23:D23, et...
How to pull content from 4 cells to 1 cell
SolvedHello, How can I pull content from 4 cells to I Cell in a specific format so that I have it displayed like this: sm=12.00/W123/F456,MD=13.00/W456/...
Vba 2010 open files in current folder loop
SolvedHello there, Think this is a relatively simple code and I've found examples but can't quite piece it all together to do what I want to do. I want t...
Vba locate & delete words within a sentence
SolvedHello, I know this is probably very easy but I'm having trouble figuring it out. I'm trying to find a code that will identify key words within a s...
Releasing filter before running a macro
SolvedHello, dear all friends, good morning. I have an invoice template in a worksheet in excel 2007.. By clicking two buttons ,I will be able to store ...
Highlight rows with conditions met
SolvedHello Friends, I desperately need a macro to Highlight /or separate rows when specific conditions met. sample file enclosed. Link http://www.spe...
Sharepoint link to excel via a cell variable
SolvedHello, Configuration: Windows XP / Internet Explorer 7.0Hello, Wonder if any of you gurus can help with the following, as it has got me totall...
Remove "calculate" from excel.
SolvedHello, When opening a saved sheet with data in excel,I get to see "calculate" mentioned on the bottom left. The problem is when this "calculate" i...
Excel/vba 2010 continue with macro
SolvedHello, Just a quick question I've got a Macro that runs perfectly except there are two times while it runs where it stops and asks you to click Ok...
Vba conditional formatting excel 03
SolvedHello, How can i apply a conditional format on a certain cell but with the condition in a different cell. F.e. if a cell in range C1:D5 (f.e. C...
Excel 2007 - macros
SolvedHello, I need to write a macro for following example. Item Qty c 2 B 2 b 6 C 5 c 5 a 2 Basically I want to group by Column A (i....
Highlighting and copying in excel
SolvedHello, I am just starting on visual basic and would like to record a macro whereas, once I have pressed play, Excel will select a cell 12 rows dow...
Printing excel sheet with jumbled columns
SolvedHello, Dear all, I have a typical question. I have a work sheet in excel 2007 with some headers in columns from C8 to N8 the columns C to F have t...
Excel office2007 macro
SolvedHello, I writting a macro to clean up the format of a report down loaded into excel. I'm stuff on on section. I have filter column A for blank cell...
Excel - cells formatted as numer pesel ???
SolvedHello, Firstly, just a quick one: I want to use conditional formatting to check if a cell ( say A1) has a red background and if it does then re...
Deleting and combining rows in excel with con
SolvedHello, I hope someone knows the answer: I have simple table Column A: item # Column B: text example: Item # Text 2 text 1 2 t...
Split worksheet
SolvedHello, Is it possible to Split one worksheet to different workbooks( files). I am having a statement to be send to 10 branch offices. sample...
Partial match multi-sheet comparison
SolvedHello, I am trying to compare a manufacture's part number in a spread sheet with a spreadsheet that we have to match these part numbers to their U...
Inserting/copy rows, transpose vba help
SolvedHello, I have searched through many posts and it appeard everyone is very helpful. My skills in vba are ok but i lack the knowledge to solve my prob...
Merge rows if it meets criteria in excel
SolvedHello, I would like to know if I can merge rows if it meets certain criteria in Excel. If Project ID on column A is matched, it will merge all the ...
Conditionally deleting rows in excel 2007
SolvedHello, I'm hoping someone here might be able to help me with this. I have a spreadsheet where column A is a project name then columns B, C and D a...
Webpage to excel
SolvedHello, Could you please help me in downloading data's from a web page to an excel. If that web page has multiple pages ( 1,2,3,4.... ), i want all ...
Formula: to count cells and then add number.
SolvedHello, All Hope you can help! I have a list of actions 1 Contacts 2 Appointments 3 Estimates 4 Sales contacts counts as 1 contact,...
Needed a vba.
SolvedHello, I'm very new to progamming kind of stuff... i need to generate a report from a excel sheet. Coloumn Q of "data" sheet has only 0 or 1, whi...
Excel "if" for letters to equal values
SolvedHello, I have a yes or no sheet, one column for yes and one column for no. I want the end column to calculate a 1 for yes, and 0 for no, and in s...
Simple excel formula help
SolvedHello, Configuration: Windows 7 / Firefox 3.6.17 Hey guys I'm doing some project on Excel for a class. When it comes to entering and crea...
Excel name match query
SolvedHi I have a column (A) in excel that lists all of the staff in an organisation, and in column B is their telephone number. In column C is a list o...
Split data into multiple sheets using macro
SolvedHello, Configuration: Windows Vista / Firefox 4.0 I have an excel sheet with the data in following manner. a b c d 1 1 1 1 2 2 2 2 3 ...
Excel macro help.
SolvedHi, I was wondering if someone could help me develop a macro that would reference a row in another worksheet. So for example if Column H = "x" in ...
Excel macro to identify/modify/combine cells
SolvedHello, I have a collection of survey results in Excel that are coded from another software that I need to prepare to put in SPSS, the results come...
Hiding a different sheet in workbook
SolvedDear sir, I have one worksheet and there are 20 different sheet in that worksheet. I want to show 1 or 2 sheet and want to hide rest sheet. May i...
Report from excel data sheet
SolvedDear Sir, I am new in excel. I am trying to use excel for my work easier. I have one excel file where there are different sheet of monthly salary ...
Excel vb macro
SolvedHello, I am new to vb and excel. I am trying to create a Macro that will look through all the worksheets in a workbook and find the column named "...
Codes for reminder creation in excel vba
Solved/ClosedHello, I want to get Reminder message box automatically, according to the date and time in Excel worksheet. What are the VBA codings & procedures?...
Can not run macro
Solvedhello sir, I am trying to put macro in any excel sheet then "can not run the macro" the macro may not be available or all macros may be disabled. ...
How to create shortcut keys to xl 2007macros
SolvedHi, I created few Macros in excel 2007,these working fine but how to assign short cut keys to these macros.In macros window in options property is ...
Ignoring rows with zero value
SolvedHello, A couple weeks ago ya'll helped me with some code to compare two sheets and create a new worksheet with all of the values that were identic...
Highlighting the values entered in an excel
SolvedHello, Dear All, I have a question to ask, Actually i am working with an Excel File which has so many sheets under one file, and this file ...
Copying data to another worksheet
SolvedHello, I have the following data in worksheet named "Auto Entry" Cell A1= X Cell A2 =Y Cell A3 =Z Cell A4=Input Value(1,2,or 3) In Cell A4 is...
Excel: matching and sorting
Solved/ClosedHello, Ok, how sould a computer dummy to this (the dummy is me): I have a list of 300 bike racers. In the columns next to the racer is items such a...
Can someone please write me a macro for excel
SolvedI want to be able to input a number into a cell and have that number recorded in a list elsewhere within the same sheet. Then be able to replace tha...
Copy selected cells to new sheet in a row
SolvedHello, dear all, I have an invoice template in the range b6:f57 in one sheet.. I want to select only some cell contents like c17, f17, f 19 , f 32, ...
Macros help
SolvedDear Friend i want to convert number to text in excel programme Example : ( 055555 : Zero five Five Five Five Five ) As This Format ...
Transfering data to a new sheet
SolvedI'm running excel 2007 on windows 7, if that's important. I'm trying to find a way to transfer data from a master sheet (or basically sheet 1) to...
Format data in excel for db transaction
SolvedHello, I have a simple question, I have a range of cells with numbers in each cell. I want to add a single quote or apostrophe in the start and end...
