Excel macro between worksheets
I have an Excel Workbook with a "Paid" sheet and an "Outstanding" sheet, both sheets have a File Number column. I would like to create a macro that looks through the "Outstanding" sheet and if the File Number from the "Outstanding" sheet is also in the "Paid" sheet can the entire row be deleted...
I have an Excel Workbook with a "Paid" sheet and an "Outstanding" sheet, both sheets have a File Number column. I would like to create a macro that looks through the "Outstanding" sheet and if the File Number from the "Outstanding" sheet is also in the "Paid" sheet can the entire row be deleted...
5 pts.
Is there a macro to transfer a row of data from top to bottom row of range ??
I use excel 2007. I have a s/s encompassing over 350,000 rows. Data consists of a series of ranges from columns A:N and rows varying in number between 3 and 30. There are two blank lines between each range of data. Each range is (with exception) numerically ordered down column H (e.g, 1, 2, 3,...
I use excel 2007. I have a s/s encompassing over 350,000 rows. Data consists of a series of ranges from columns A:N and rows varying in number between 3 and 30. There are two blank lines between each range of data. Each range is (with exception) numerically ordered down column H (e.g, 1, 2, 3,...
Disable saving in Excel 2007
Hi, I need to get rid of the save option. I only want the sheet able save when the document is closed and it askes if you want to save. I do not want the document to be saved any other time. Here is my document (Office 2007 Only). http://www.savefile.com/files/1848919 It has been made to book...
Hi, I need to get rid of the save option. I only want the sheet able save when the document is closed and it askes if you want to save. I do not want the document to be saved any other time. Here is my document (Office 2007 Only). http://www.savefile.com/files/1848919 It has been made to book...
Have an Excel macro download data to the iSeries
Is it possible to code an Excel macro to download a spread sheet to the IFS (on the iSeries) and then to start an iSeries job to process the downloaded data?
Is it possible to code an Excel macro to download a spread sheet to the IFS (on the iSeries) and then to start an iSeries job to process the downloaded data?
Trying to copy a value created within a subroutine to another cell in the same worksheet
I have a string of cells that are populated by my macro. what i need to do is: each time the value populates, i need to copy just the value to another cell so i can record the results of the macro for a long string of numbers. heres what i have, this is not working for the last step - Sub Count()...
I have a string of cells that are populated by my macro. what i need to do is: each time the value populates, i need to copy just the value to another cell so i can record the results of the macro for a long string of numbers. heres what i have, this is not working for the last step - Sub Count()...
Excel Macro to parse list of excel files and move them depending on a single cells value
Does anyone know how to creat an Excel macro that I can run on a directory of excel files that will look for a value of cell B47 and if it's > 600 move it to another directory and if it's < 600 move it to another one?
Does anyone know how to creat an Excel macro that I can run on a directory of excel files that will look for a value of cell B47 and if it's > 600 move it to another directory and if it's < 600 move it to another one?
Excel Macro to Create additional Sheets, based upon cell values
I have a spreadsheet that contains a report of which department has an item entered. what I want to accomplish is to move the individual 'department' data to thier own sheets. I have one case where I will have 4 different departments combind on one sheet, the remaining will occupy thier own sheets....
I have a spreadsheet that contains a report of which department has an item entered. what I want to accomplish is to move the individual 'department' data to thier own sheets. I have one case where I will have 4 different departments combind on one sheet, the remaining will occupy thier own sheets....
Help finding duplicate info in Excel in different columns
Hi, I have an excel spreadsheet that looks like below: Origin Store1 Store2 Percent Source Warren 12345 45678 2.45 b Warren 45678 12345 2.45 r I want to be able to recognize and delete one of these rows as a...
Hi, I have an excel spreadsheet that looks like below: Origin Store1 Store2 Percent Source Warren 12345 45678 2.45 b Warren 45678 12345 2.45 r I want to be able to recognize and delete one of these rows as a...
Place Holder
I have part numbers that are in the form of 12345678-001. I am trying to write a macro that will search through the 13000 lines of part numbers and enter a revision level next to it. I want it to only look at the first 8 numbers (before the "-"). This is what I currently have: Dim Timer As Integer...
I have part numbers that are in the form of 12345678-001. I am trying to write a macro that will search through the 13000 lines of part numbers and enter a revision level next to it. I want it to only look at the first 8 numbers (before the "-"). This is what I currently have: Dim Timer As Integer...
How to link a macro by clicking on a cell of an Excel sheet
I need to get the current time by clicking on the cell in excel.
I need to get the current time by clicking on the cell in excel.
Updating textboxes on a Userform
How can I get real time information in a text Box on a userform when a macro is running
How can I get real time information in a text Box on a userform when a macro is running
Excel Phantom Macro annoying me!
Hi. I have a workbook that *did* contain some simple macros. However I no longer needed them so deleted them, but now when I open the excel workbook it still comes up with the "enable/disable macro" dialog box.... I have no macros in existence so how do I stop the security warning appearing every...
Hi. I have a workbook that *did* contain some simple macros. However I no longer needed them so deleted them, but now when I open the excel workbook it still comes up with the "enable/disable macro" dialog box.... I have no macros in existence so how do I stop the security warning appearing every...
excel macro formated to highlight current date
I have a calendar in an excel workbook that I would like to develop a macro that could be formated to highligt the current date. I have my dates formated as the serial date. When I write my macro it highlights the same "number" "=DAY(TODAY())" in every month.
I have a calendar in an excel workbook that I would like to develop a macro that could be formated to highligt the current date. I have my dates formated as the serial date. When I write my macro it highlights the same "number" "=DAY(TODAY())" in every month.
Macro determining end effective dates
I am using Excel 2003. I am creating a data-entry spreadsheet that contains supplier costs for components. For each component (Record), it has a begin date for when the price goes into effect and an end date. Since I want a history of this item and the dates that it increased or changed, there...
I am using Excel 2003. I am creating a data-entry spreadsheet that contains supplier costs for components. For each component (Record), it has a begin date for when the price goes into effect and an end date. Since I want a history of this item and the dates that it increased or changed, there...
finding words within other words with an Excel macro
column B has 2 letter words, the next 3 then 4 and so forth. I am looking to find the words in each column to the right to find all of theentrie that contain it and change the color of only the 2 or 3 or 4... letters in the new word for all words in each of the colomns to the right. Example: AA...
column B has 2 letter words, the next 3 then 4 and so forth. I am looking to find the words in each column to the right to find all of theentrie that contain it and change the color of only the 2 or 3 or 4... letters in the new word for all words in each of the colomns to the right. Example: AA...
Excel macro
I would like the user to be able to hover the mouse over a picture which then would enlarge to some defined size and then return when the mouse is moved off of the object.
I would like the user to be able to hover the mouse over a picture which then would enlarge to some defined size and then return when the mouse is moved off of the object.
Help in creating a macro
I am creating an associate scorecard. I have an excel file with top two filter, month and the name. Based on the month and associate name, I will pull the performance data (Joining date, emp id, AHT, CSAT etc) for metrics from another excel file using vlookup. (NO WORK is required here) What am...
I am creating an associate scorecard. I have an excel file with top two filter, month and the name. Based on the month and associate name, I will pull the performance data (Joining date, emp id, AHT, CSAT etc) for metrics from another excel file using vlookup. (NO WORK is required here) What am...
How to use Excel to manage inventory
I'm using an Excel workbook to manage a fulfillment inventory. It contains three worksheets. Worksheet 1 includes the current inventory of all the products available for fulfillment. Worksheet 3 contains a list of the packing lists and quantity of the products (by part number) that were sent out...
I'm using an Excel workbook to manage a fulfillment inventory. It contains three worksheets. Worksheet 1 includes the current inventory of all the products available for fulfillment. Worksheet 3 contains a list of the packing lists and quantity of the products (by part number) that were sent out...
Excel Form Macro
Hello Excel Gurus, I am in great need for an Excel Froms Macro that Switches a Spin Control (asignes integer value) to a cell and is mux'ed betwen different cell references that are activated by a radio button. I created a model code fragment well over a year ago and got the functionality to work...
Hello Excel Gurus, I am in great need for an Excel Froms Macro that Switches a Spin Control (asignes integer value) to a cell and is mux'ed betwen different cell references that are activated by a radio button. I created a model code fragment well over a year ago and got the functionality to work...
Excel data daily update linking between workbooks
Using Excel, I am trying to link a column in one workbook to update daily to one cell in another workbook. The part I can not get to work is making the one cell automatically pull the current date value from the first workbook. I believe I need to use either an IF formula or a macro to tell the...
Using Excel, I am trying to link a column in one workbook to update daily to one cell in another workbook. The part I can not get to work is making the one cell automatically pull the current date value from the first workbook. I believe I need to use either an IF formula or a macro to tell the...
