Excel Forum
-
need a macro for the following [Closed]
Hello, i am have a set of numbers( indicating the product serial number) in rows having comments which include some text + date of manufacturing...
-
macro that takes multiple csv files and puts [Solved/Closed]
Hello, I need a macro that takes multiple csv files and puts them all in 1 worksheet. The csv files all have header info that i do not want copied ...
-
Excel 2007 "If....Then select Row and move&qu [Solved/Closed]
Hi all! I have what would appear to be a basic question, but can't seem to put my brain around the solution. I have a spreadsheet on Sheet 1. O...
-
Comparing 2 spreadsheets [Closed]
Hello, I need to compare 2 spreadsheets that are coming form different sources but have mainly the same content. I can easily edit them so that t...
-
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 ...
Subscribe To Our Newsletter!
DON'T MISS
- How to Upload High Quality Photos to Instagram
- How to Create a Gmail Account
- How to Fix a Blurry Snapchat Video
- How to Get More Followers on Instagram
- How to Recover a Disabled Facebook Account
- Computer Boots to Black Screen
- Facebook Code Not Received
- How to Install a VPN
- How to Recover Your Yahoo Account
- How to Get Free Diamonds in Free Fire
- How to Disabled Write Protection on a USB