Summary: Hi, I am working with Excel and looking for a way to create a Macro to delete specific rows of data that are unnecessary. For example the worksheet co...
Summary: Could some one please tell me how to construct a macro, in excel, to delete rows that in a collumn aren't multiples of 300. Thanks in advance ...
Summary: Yes but, before running the macro you must Cut column E and Paste it into column A for it to work as it only looks at column A. You can cut&paste it b...
Summary: hi I need any function or macro to do this conditional task as below! In excel file,I have a data from A1 to C300 then criteria 1: Check if A1= A2 the...
Summary: Thanks for the access suggestion, I will try that. If anyone else has a suggestion or MACRO that I could use to force excel to do an "F2" and "enter"...
Summary: Hello, I need some help setting up a macro for Excel. Situation: I have a list of IDs/SKUs on Sheet1, and a partial list on Sheet2. What I would like ...
Summary: Please forgive me if this has already been answered, but I didn't find what I'm looking for. I'm trying to figure out why in excel 2007 when I record ...
Summary: Hi there, Could anyone help me maybe with the following. I´m trying to copy paste a lot of graphs from excel to ppt with a macro i found somewhere el...
Summary: I wrote a macro in excel to follow a link, selectAll and copy the text from the browser and paste it in excel, but I keep getting this runtime error -...
Summary: Dear Friends I have excel sheet made of many rows and column, out of that one 03 column in a row need to input the number and all others are formulas....
Summary: Hi, When I open a excel doc in IE, I can only save the changes in my local machine and not the Web server. The requirement is that, I should be abl...
Summary: Hi , I have a excel worksheet which is linked to a database. The database changes and I need a macro in Excel to refresh all data when I open the ex...
Summary: OK, let's recap... - You have 600 sheets in a workbook - Each sheet has a data set in A1:G3 and G4:G23 - You want to copy those data sets to "it doesn...
Summary: I need to create a macro for excel that copies data in specific cells in Sheet1 to the next empty column in Sheet2. The data I am copying is coming f...
Summary: Hi,every month to process some database file we required to check weather database is modified on specific disk drive or not and what is the modified ...
Summary: I have taught my students for years to turn grid lines on and row/col names on in Excel before copy/paste to Word. Use Paste Special and "enhanced me...
Summary: Hi, A little difficult to advise, as I don't know what worksheet, worksheets or ranges that your current macro works on. So I am starting from scratch...
Summary: Hi, Thanks for your reply sorry I have not made myself more clear, it is the first time that I have ever wrote on a forum and was finding it difficult...
Summary: Hi I have a very simple question to ask about Macros. I have 36 different workbooks, and I want to count the number of lines on each workbook and cr...
Summary: If you select the cell adjacent to the target cell and hit Ctrl+d the following will give the result in the adjacent cell. For example: A3 contains th...
Summary: i have forgotten password for excel file, i have tried several demo versions of softwares but they dont allow to recover password greater than 3 chara...
Summary: Dim pathForDocuments As String Sub TDL() pathForDocuments = "C:\Documents and Settings\" + Environment.UserName + "\My Documents\SD TDL Auth to PIN.xl...
Summary: Hi I have just installed 5 new client PCs for a customer. It is a workgroup and the clients are running XP Home. They originally had all Windows 95 (!...
Summary: I would like to reference data listed in the MS Word cross reference dropdown in an Excel spread sheet and then pull cell data into word. I would lik...