• 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:
  • how to increase no of rows of validation list (drop down list)???

    Hello, Thanks for viewing this thread. I have one excel sheet. I have entered following data in 30 rows in one column and created the validation list for that data 10:00 AM 10:01 AM 10:02 AM '' '' ' '' 5:00 PM I want to show drop down list box with my own no of rows to be displayed not current...

    Abhikop5 pointsBadges:
  • Combining data from two Excel sheets into a new sheet

    Hi, I Have few leave detail excels wherein the leave details of each resource are present.I need help to create a macro wherein all months leave details will be clubbed together into a new excel for each resource.Kindly help me with the code or give me some ideas to do this since am very new in...

    Vaibhav1235 pointsBadges:
  • Tree node for documentation

    Hi, I need to prepare a Menu and submenu details. Each menu option has many sub menus, so seeing the next menu is tough. Please advice how can I create a Tree node like + will expand , - will collapse the list. I need to do it for documentation. Please advice.

    as400dev480 pointsBadges:
  • Macro to breakout data into separate tabs

    I have a weekly report that holds line item detail for seven different account numbers. The data is going to vary from week to week and I need vba code that will separate the data by account number into different tabs. Any tips on how to write the code? RWC

    HNAvigator20095 pointsBadges:
  • Help on Excel 2007 Macro

    Hello Experts,I have a data with two columns. Column A contains the Engineering Change Order (ECO) numbers and Column B contains the Models affected on the particular ECO. Some ECOs with affected models are only 1 model, some ECOs are affecting two or more models. If the ECO is affecting multiple...

    manang05175 pointsBadges:
  • Privacy warning in Microsoft Excel 2007

    When I'm tried to save a spreadsheet in Microsoft Excel 2007, I often get this "privacy warning" message. This happens with both macro and on-macro spreadsheets. Is there any way to get rid of this message?

    ITKE350,845 pointsBadges:
  • Excel Macro to extract substrings from a comma-separated string.

    How can I write an Excel macro to exctract substrings from a comma separated string located in a single cell and put each substring in a cell of a certain column.

    Sdsdsd15 pointsBadges:
  • Can data in Excel 2003 be set up to automatically move from one sheet to another in a workbook?

    Is it possible to create a macro, or multiple macros to upon a button push move data from one sheet to another in the same workbook in Excel 2003? We have a workbook with three sheets, instead of having to manually copy and paste information once we have completed it from sheet one to the others we...

    Kaylee5 pointsBadges:
  • 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:
  • Unable to run macro in Microsoft Excel 2007

    I'm unable to run any macros stored in this workbook but macros stored in the personal file will run. What should I do?

    Rich6245 pointsBadges:
  • Excel Macro Help – .ThemeColor = xlThemeColorDark1

    The spreadsheet I'm working on pulls data from an oracle database and automatically populates cells for which there is no data with "999999." I am attempting to use an excel macro to essentially gray-out all cells that contain this value with the intention of saving users the time it takes to apply...

    Jwahl5 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