• Cell Automated Population using Excel macro

    Hi, Is there a way in macro wherein if a certain cell has value, the other cells will be automatically populated? Example: In cell E6 I put the date, cell A6, B6,C6 and D6 will automatically copy the values in A4, B4, C4 and D4. Same goes when I enter the date on cell E7. Thank you so much in...

    Eron09135 pointsBadges:
  • New to macros – extracting data

    Hello, I'm just learning how to use macros and have this fairly large project to do. It concerns extracting data from a schedule (timetable) with the courses, course code, name of tutor on it. I have managed to extract from a cell and have the following information come up in a message box (course...

    Oistins2610 pointsBadges:
  • Excel macros not working in password protected workbook

    Excel 2007 macros work perfectly in original workbook however when I save as and create a password to open the workbook, it opens OK but the macros don't work. The Excel options have the macros enabled but they are deactivated somehow.

    Yoka25 pointsBadges:
  • Search for duplicates in a collumn and delete the row on which it occurs

    Hi, I have a spreadsheet with list of identifiers in collumn 1, this is auto generated and due to the source info some of them duplicated, what I want to do is find the duplicates and remove the entire row they appear on. I know this is possible using clipboard and filters but I would rather avoid...

    Harleq20 pointsBadges:
  • 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?

    aderene180 pointsBadges:
  • How to assign numerical values from a dropdown list in Excel 2010

    I'm trying to write a roster template, and need to be able to assign numerical values to shift types (AM/PM 9, MIDDBL 12, DBL 14 and OFF 0). Each week day currently has a drop box for each employee listing the bracketed shift options. Ultimately I want to be able to calculate how many hours are...

    KAJ5465 pointsBadges:
  • One macro to systematically run F5 key on up to 20 other macros

    I have put together a series of macros which autofilter information to create a report on different tabs within a workbook. Having 17 macros all similar it would be handy to have one macro which would systematically activate each Module in turn and therefore require just the one key combination...

    AsHappyAs75 pointsBadges:
  • Excel and Access integration and auto-population

    Overall, I want to create a database that tracks defects for several sites and ouputs the information in a pivot table.  Each site (7 in total) documents their internal defect data and sends it to me weekly.  I then merge all of this data (have been doing so manually) into one spreadsheet to...

    Sm6hans25 pointsBadges:
  • Excel 2007 Macros problem

    Hello, I am using Office 2007. The Macros are disabled when we open password Protected Workbook. What should we do?

    Mobilink115 pointsBadges:
  • 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.

    78345 pointsBadges:
  • Microsoft Excel 2010 macro help

    What I have: this is one transaction in a parking garage. 4 columns, 3 rows Date/Time     Movement          *blank*               Ticket Number Facility         *blank*               Car Park             System Device Card             *blank*            ...

    MrJoe12135 pointsBadges:
  • Excel 2007 – formula or macro to show value from one cell next to a given reference

    Hope someone can help. I am trying to work out a formula to place the value of a cell on a spreadsheet into a second sheet within the workbook using a reference in the column next to the cell with the value in it. EG - Sheet 1 has a cell with £500 in cell 3A The reference 1.01 is located in cell...

    PeteAtGlasshead5 pointsBadges:
  • 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.

    JH3935 pointsBadges:
  • How to paste data directly from Excel to PowerPoint graphic as data using Excel VBA

    I've been trying to search for ways to copy data from a spreadsheet onto the datasheet of a graph in an open spreadsheet. I am unfamiliar with VBA code, but got it to copy and paste to the correct slide, but only as text. I have been unable to select the actual existing graph and paste the data in....

    Charm20 pointsBadges:
  • Excel Macro

    I created a macro and it is saved in personal.xls. How can I make this macro available to other users? I want to be able to give them the ability to run the macro - they do not need to modify it.

    lorit365 pointsBadges:
  • How to send a mail to multiple recipients from Microsoft Excel sheet?

    I have an excel sheet. This excel sheet has data for many recipients. every row has an email address (lotus/outlook) and then the next four cell in the same row has the data for the same recipient. I want a macro to be created so that when I run this macro a new mail is drafted for each recipient...

    Micqa5 pointsBadges:
  • Import lotus notes view data from Excel

    I need to import frequently data from some Lotus Notes views into my Excel sheets, I want to know if they are a macro or a VB script which could do that.

    Witold200830 pointsBadges:
  • Cell Colors in Excel

    I would like to have some code that will update the color of a cell based upon values in other cells. Even when the cells are on different worksheets within the same workbook.

    TweetyBird695 pointsBadges:
  • Import text from another excel workbook

    I have a excel workbook (wb1) where the columns is showing the months and the rows is showing different actions that take place. If an action takes place in a specified month the cell corresponding to both the action and the month is marked yellow. In another workbook (wb2) I want to be able to...

    AenE15 pointsBadges:
  • 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.

    Jlcford15 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following