• excel table to text flat

    Hello, I am not an IT expert to start with! I have a series of tables in excel made of 3 dimensions. Two dimensions are vertical (indicator and country), one is horizontal (years). The different tables contain data for a variable number of years and for a variable number of countries and...

    Brunella5 pointsBadges:
  • Search Excel Macro Help!

    I do not know scripting and i really wish i did, any help would be greatly appreciated!I have an excel document that I need to search through for a list of words, when of the words from my list is found, i need the word it found to be put into a new column.

    Abrkadabragimmeahandle5 pointsBadges:
  • Excel macros – code does not execute

    I have written the following macro. I do not really see it necessary to explain ehat it does, I only need help with a problem - for some reason it does not reach the code after the loop. It does everything exactly as I want it until and into the loop, but does not execute the code after the loop at...

    Wyaneva10 pointsBadges:
  • I am unable to do my Import, when I run my macros I received two errors, running excel 2003

    I Need some ones' assistance with this error that I am getting in my excel spreadsheet: "compiler error in hidden module: ChroniclesExport " This error is only when I'm running the MACRO's function. The MACRO has been checked by other colleagues at my work and is running fine on some PCs & but it...

    IVANZAMU40 pointsBadges:
  • Help with a macro for linking a data entry form spreadsheet to the results spreadsheet

    I am entering seminar selection data for 600 students and i have a spreadsheet with names and id numbers. there are 20 seminars that they may attend and they have "ranked" them 1-20. I would i have a data entry sheet with a VLOOKUP that will find the student (on the second sheet) and display the...

    JBH18555 pointsBadges:
  • Linking a checkbox to another checkbox – Excel 2003

    In Excel 2003, I have a spreadsheet with multiple sheets (including a detailed page and summary page). Each sheet has about 20 subjects that contain YES / NO / N/A answer checkboxes. I need to be able to link corresponding summary and detailed checkbox's with each other. EXP: When you check the...

    Meman22435 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 receipnts. every row has an email address(lotus/outlook) and then the next four cell in the saem row has the data for the same recipant. I want a macro to be created so that when i run this marco a new mail is drafted for each receipant...

    Micqa5 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 – I need to find rows that match a user entered entries and sum results of column b

    I have a spread sheet that looks like this Project Well Hours Lewis 1 12 Lewis 2 3 Lewis 1 9 I want to find all the rows that match a user inputed name (in this case 'Lewis'), then add the numbers in column c labeled 'hours', if the sum equals 24 then no problem, but if the sum does not equal 24...

    Ksaep0420 pointsBadges:
  • Menu Driven Macros

    I have a database within Excel 2007. There are quite a few macros in it. I want others to be able to use the database and certain macros, but I want the options to be in a menu type layout not on the bar. I know this has to be possible, but I don't even know what it would be called to look it up....

    Cindyhale5 pointsBadges:
  • Deleting Excel Worksheets with macro

    I am using excel 2000 and have workbook that uses macro to delete several worksheets and then save the workbook under a name in one of the cells. All works fine but for each worksheet a quiery pops up to ask if you want to delet this sheet. How do I delete sheets in the macro without having this...

    Rbloxsom5 pointsBadges:
  • I am getting “compiler error in hidden module” error in Excel 2003 while running Macro

    I am getting :"compiler error in hidden module " error in EXCEL 2003 only while running MACRO. Actully this MACRO is running on some PCs & for some PCs it is showing that error. The installation of MS EXCEL 2003 is same on all PCs. Please help me ASAP. Thanks in advance !

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

    Adavidson5 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:
  • How to send mail to multipie recipients from lotus using excel macro

    Hi , I am using following code right now for sending mail from lotus using excel macro for single client its working fine Sub SendLotusNotesMail() Dim UserName As String Dim MailDbName As String Dim Maildb As Object Dim MailDoc As Object Dim AttachME As Object Dim Session1 As Object Dim EmbedObj1...

    Sh3210 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 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 3B...

    PeteAtGlasshead5 pointsBadges:
  • How to paste data directly from Excel to PowerPoint graphic as data

    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 graph and paste the data in. Any help...

    Charm20 pointsBadges:
  • find which excel spreadsheets contain macros

    in a folder or drive how can I find which excel spreadsheets contain macros without opening every one individually?

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

    Kferranti5 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.