Excel Forum
-
Excel macro to find value with a condition Closed
Hello, Say, a code like C1180230 may occur more than once in column A, but its occurence with name "Recipe" in the previous cell is unique. I wan...
-
Excel function query Closed
Hello, I want your help for calculating the balnk cell in the row in a particaular cell and paste the top row column value in that cell. Means ...
-
Macro for copy pasting Closed
Hello team , 1.Can you please help me with the macro to copy paste the filter area to another work sheet . 2.Also the tab from which it is copyi...
-
Insert rows Closed
Hello, I have a question about "if End If" nested in a For Next structure in excel vba. I have been trying to write a code but I cannot get the...
-
Copying data in a dfrnt sheet w/ condition Solved/Closed
Hello, Greetings everyone... I want to copy data from one sheet to different sheet but only if a condition is true. For example, 1st Shee...
-
none of the browser sounds are working Closed
all the media player sounds are working... and the game sounds too... but none of the computer system sounds are working( startup, login, windows...
-
Copy certain Excel cells to new sheet Closed
Hello, I have data that is inserted in a row. I'm trying to create a macro that will copy certain cells within that row and paste them into cells...
-
Excel: Find & Offset Solved/Closed
Hi can someone help me to get a macro code to make following: I have a file in which some cells having data as 10000, > 10000 and some others 10000...
-
Copy/paste cells from different sheets Closed
Hello, I am trying to create a diary using excel to keep track of everything. As I am a referee I want it to have all the games I have refereed on a...
-
Autofilter tp leave out #N/A in macro Solved/Closed
Hello, I have a project id in column C , which iam checking from another source data which is there in a differenr tab .So ihave a vlookup fprmula...
-
Inserting rows through excel macro Closed
Hello, I have 29 rows of product numbers composed of 6 different products in an Excel spreadsheet. I need a macro formula that will insert five ro...
-
Formatting Using VBA Closed
Hello, I am creating a macro based application. I wanted to merge almost 20-25 sheets to one sheets. that task is completed. After merging Now...
-
SOS...Copy Paste Loop on VB and Excel Closed
Hello, I need help to copy a range od cells and want to copy it for "x" number of times given in a cell say "K2". Need the loop to copy for exact n...
-
Score predictor in excel help?? Closed
Hi I am doing a world cup predictor spreadsheet in excel. How do I match scores and assign points in excel? eg. If someone predicts england to ...
-
Excel - cond. copy data from tab to tab Closed
Hello, I was hoping someone could help me out with a code for Excel. What I require is a macro or a workaround for Excel to copy a row from o...
-
Sum specific col if rows contain same info Closed
Hello, I would like to add cells in certain columns (for example: a & c) if the data in a certain row (say "8") is the same. I'm sure it's a logic...
-
Newbie needs a macro Closed
Hello, I need a macro that will search for the sku I'm looking for then scroll to the correct column and update the cell with the correct value th...
-
Inserting Worksheets Closed
Hello, Is there a way to automatically insert a new sheet in excel each day ? If yes, can the new sheets be formatted as the original sheet and al...
-
Conditional formatting with Excel Closed
Hello, I'm making a doc where Column A has number values the same as column B and C. For each cell the conditional formating of cell in column C w...
-
Macro/Function question??? Closed
Hello, i am currently making a spreadsheet that will log our equipment that is being repaired and have had some luck using the IF statement in th...
-
Macro Help! Closed
Hello, I need a macro that will select all rows that have have the word "Japan" in one of the columns. And then Copy and Paste that to Another sheet...
-
excel copying rows with two conditions Closed
Hi I'm trying to create a dashboard - which will automatically pick up rows based on a condition. I.e. copy the row if its 'closed won' and if it...
-
Writing a macro Solved/Closed
Hello, I am trying to get data whcih has been inoutted into one workksheet to copy into another worksheets when it meets a command in one of the c...
-
Dates Formatting in Excel Closed
Hi All, Thanks in advance for your help. I am autoformatting my dates in Excel 2007 to read as mmm-dd-yyy (i.e. Jan-01-2010) which is working per...
-
Help! Please my interner browser wont open Closed
Hello, My name is Edgar I have a problem with my laptop. the internet browser wont start when i open the internet explorer it closes down by itself....
-
Excel, IF fuction with cell text values? Solved/Closed
Hello, I would like to include the text value of a cell in the statement I have for one of the IF options. So far my formula is -: =IF((B1...
-
req: 'IF' formula in excel Closed
Hello, In one of my excel formate below mentioned row/coloums are there, Disp. Month IPO # IPO Dt Customer Details Job Name PO No. PO DT Inv N...
-
Excel Formula Display in Cell Closed
Hello, I hope someone can help me. I need to print the step by step values of a formula in a cell for example ilets say: cells(A,3)= Cells...
-
Excel:Conditional Formatting Stops Working Closed
Hello, First of all i am using 3 rules in conditional formatting and those are =AND(c1"",c1today() Green it works perfectly but ...
-
Auto Email when cells in range are edited Closed
Hello, Heres my problem: The company I work for currently uses an excel spreadsheet for scheduling. Its annoying and cumbersome. Once updated...
-
Setting up Criteria for VBA Macros in Excel Closed
Hello, I need to set up a loop function that will only output the data of the cheapest house, with a pool. Here is what I have so far, but my...
-
Highlighting cells within a loop Closed
Hello, I am trying to set my vb code to highlight columns C through G in a light blue color after each step of the loop. So for instance my for st...
-
How to automatically copy data from excel? Closed
Hello, I am running a data entry office and I need some help with present project. here is the exact scenario 1. I have data ready in ex...
-
Excel Convert Number to letters Closed
Pls let me know how to convert numbers into letters in excel
-
Copy data from one worksheet to another Closed
Hello, Configuration: Windows 7 / Internet Explorer 8.0 I am looking for a way where i can copy data from one worksheet to the another. Th...
-
Excel-Formula Closed
Hello, Configuration: Windows XP / Internet Explorer 7.0 I have 3 columns K, L and M that 2 of the fields are n/a and 1 of the fields will ha...
-
Deleting cells based on cell value of samerow Solved/Closed
Hello, When I delete cell D4 (it's contents turn to ""), I would like cells C4, E4, F4, G4 to be deleted as well. The row must still exist, so on...
-
Excel Leading Zero Format Closed
Hello, I would like some advice on formatting cells to have leading zeroes. I do know about using ="0####", but my problem is somewhat more comple...
-
Assign macro to button on a multi-page tab Closed
Hello, This seems easy but I am really stuck. I need to have a floating set of commands in a spreadsheet and I can't use attached custom toolbars (IT...
-
List 2 columns into one Solved/Closed
Hello, I hoping that someone can help me fix this. I have two columns with possible duplicate vendor name, example VendorName ...
-
How to make macros in excel Closed
Salam All Dear any one help me to make macro inexcel I m very new in this field and i m copying some data from any web sit (i-e www.192.com) a...
-
Excel sheet Closed
Hello, If you have data stored in an Excel sheet, describe the steps to import the excel sheet into MS-Access and to convert the data into a datab...
-
I need a formula for excel Solved/Closed
Hello, Here is what I need and cant find anywhere: IF A12="text1 (anywhere in text)",then b2="text2" please help provide a formula that ca...
-
excel formula file linked Solved/Closed
http://wikisend.com/download/466894/Check1.xlsx Their is a description on the file about what i am trying to do. besicly check one value to a list,...
-
Excel formula to pull data between dates Closed
Hello, I have a worksheet from a payroll program that is exported into Excel. In column A it prints the date and then names, the next date and t...
-
Separating string into different columns Closed
Hello, I am working in an Excel Spreadsheet where I have a column that looks like this: Column XYZ Engineers #### Lincoln Ave., Suite ### San ...
-
Merge 10 workbooks in a sheet Closed
Hello, I wanted to create an application using macro. I have 10 excel work books, i wanted to merge that all excel workbook into one work book....
-
Adding double quotes to excel Closed
Hello, How do I add double quotes the beginning and end of a column of numbers in Excel. Example 45671 needs to be "45671". Thanks. Config...
-
Autofilling formulas from multiple worksheets Closed
Hi guys. I am decent with excel, but I am trying to help a fellow employee out at the moment who has very little knowledge of excel. She is doing a ...
-
How to copy data using macros? Closed
Hello, I have a sheet which has data, Sheet 1 A B C D 1 2 3 4 1 2 3 4 -- -- -- -- Now ...