• Creating tools to perform some actions

    I need to check for blank lines occurred in Excel file, if so I need to filter and check the associated name then send them a reply to update for that blank line which is taking so much time so wants to automate this task. Kindly help.

    okok20 pointsBadges:
  • Find and replace text in PPT

    I have a project to find and replace words in PowerPoint from Excel and then save the PowerPoint. My code is working fine. But when PPT has mp3 then it giving errors. Please see the code and tell me what change I should do. Sub pptopen()Dim a AsIntegerFor a =2To4Dim pptApp As PowerPoint.Application...

    fattahaabdul5 pointsBadges:
  • Productivity

    Your team consists of 10 agents, each agent takes 18 calls per day and the average handling time for troubleshooting calls is 90 minutes and the average handling time for transfer calls is 6 minutes and 10 minutes for information calls. The floor averages on the of calls are as follows...

    Haotamsy268015 pointsBadges:
  • Embedding linked Excel into PDF

    Can an Excel file linked from a PDF be embedded in that PDF to deliver 1 file instead of 2? Alternatives?

    EY135 pointsBadges:
  • User prompted for AS/400 log on when using Excel Add-in to upload data.

    I have users that are uploading data to the AS/400 (V6R1) using the Excel Add-in. One user gets a log on pop up window each time she initiates the data transfer. Others in her same group do not. Where would I go to turn this off? She is logged on an AS/400 session and it is still prompting for a...

    CChristo15 pointsBadges:
  • Excel 7

    I have a large spreadsheet with cell that contain  similar older catalog numbers. Want to update to the latest version of catalog number. Can I delete/ remove a character from the following Example:   23LB412  take out the "B" and keep the following: 23L412

    Coppertone5 pointsBadges:
  • Claculate slope & Intercept from line drawn in chart (Excel)

    Is there a way to compute the slope & intercept of a line (object) drawn on a chart in Excel using VBA? I have an X-Y chart with data and I want to have the flexibility of drawing my own "best-fit" line through the data. Thanks, Frank

    falfra10 pointsBadges:
  • Updating in realtime with MS Word and Excel

    There are 1500 people checking in to a motel for a yearly convention. I am in charge of registration and as I mark person/people who checked in, I want four other laptops that are online with same OS and same Excel or Word (office 2007) loaded on page. I want all four computers to update reg. as I...

    justme5710 pointsBadges:
  • Number formats

    I pasted a bank statement into Excel but I can't successfully do any calculations. Can you help?

    commercial5 pointsBadges:
  • Populate an Excel drop down list from ASP.NET using VB.NET

    How do you populate an Excel spreadsheet that contains drop down list using ASP.NET with VB.NET code behind. I can easily populate or update the cells by name because the headers are not on the first row but when I am trying to populate a cell that has a drop down list attached to it, even though I...

    oneHundred5 pointsBadges:
  • How to get weekly chart updates

    In Excel macros I would like to change a reference cell incrementally each time I do a button click. How would I do that? For example start out referencing cell b6 then one button click reference cell b7 and so on as often as I push the button it would increase the cell reference to the next...

    ResearchRat5 pointsBadges:
  • Export contacts info from Outlook 2007

    Can someone suggest the easiest way to export my personal Contact information from Office Outlook 2007? I want to migrate my personal Contact information from office Outlook to my home computer. Early response will be much appreciated as I am leaving office from this Friday (1/30). Thank you.

    SbElectric2,540 pointsBadges:
  • Excel lookup and totals

    Find specified values in one column, and total vaues in other columns of the specified value.

    tcmichigan10 pointsBadges:
  • Drop down menu’s in PDFs saved from Excel files

    Is there any straightforward way to save an Excel file as a PDF while retaining the functionality of the drop down menus? I have a few drop downs that I've added to an excel file and I want to save this file as a PDF to the point that I can open the PDF and change the drop down menus. Can this be...

    Duester5 pointsBadges:
  • Objects embedded in Excel

    I placed an object (PDF) in an Excel spreadsheet. When I go to minimize the row or filter the row/column's the objects do not move. How do I get it so it stays within that row?

    Chinavarepn5 pointsBadges:
  • How can I copy/paste a table from Excel to Lotus Notes

    Hi all, I've been reading some posts about my question over the internet but didn't find any accurate answer. Here's the problem: When I click a button in Excel, i need the table from a certain "Range" to copy/paste in the body of an e-mail that will send itself automatically. Now, I know how to...

    Selut22225 pointsBadges:
  • Excel conditional formula

    Hi all, I can write a basic conditional formula such as =IF(A1="23", "OK", "NOT OK"), but I want to add a supplementary condition ... For example if A1 is 23 and B1is 24 then the cell will display OK or NOT OK as appropriate... both conditions need to be met. TIA, John

    Johnaldo160 pointsBadges:
  • Option buttons in Excel

    Trying to create a checklist with multiple line items each having a "yes" or "no" response.

    Susan85 pointsBadges:
  • Excel

    All of a sudden when I open a number of Excel docs, I don't see the list on the bottom of the page to click and retrieve. I have to go back up to open and then open them from there.

    Mrboop10 pointsBadges:
  • CHR file

    My software exports file into CHR format. I can mail you the attachment. I want to convert the same into excel format.

    vishamber19645 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