• Switching views in Excel when filtered

    I have several macros that switch views for a very large spreadsheet. I also have filtering available for the various columns. However, whenever the view is switched, the filtering is turned off. If filtering is on, I would like the filtered view to not change. Is there a way to keep the filtering...

    Tsbarr15 pointsBadges:
  • How to change config to download all fields to Excel than Inbox

    Using menu path Plant AnalysisExportTransfer to XXL in MCBA to download all switch drill down fields but currently am brought to SBWP. How do I change it to allow down load to Excel?

    Janwong5 pointsBadges:
  • Excel Date format () dd-mmm-yyyy error from exported crystal report

    I am exporting a crystal report file to excel and date field TRADE_DATE is coming out strange. i.e PARTY_ID TRADE_DATE CX () 16-Jul-2003 CX 29-Jul-2003 CX 09-Dec-2003 Some trade_date fields are in Custom Type "dd-mmm-yyyy" format ( which is the correct format) but some are in Custom Type "()...

    Shakeel4540 pointsBadges:
  • Windows Word Table of Content numbers change to number 3

    How do you prevent the numbering in a Table of Contents in a Word document changing to the number three when sent as an e-mail attachment?

    D Richter5 pointsBadges:
  • How to add another row header to Excel Report using Visual Basic

    HI, I want to add another row and column header to a Excel Report using Visual Basic..

    Jothi155 pointsBadges:
  • ctrl f and highlight intervening text

    For macro writing purposes, I'm trying to figure out how to make a ctrl f search in Word or a text editor highlight (for subsequent deletion) intervening text between the cursor and the found character. Is there some way to do that? Thanks!

    Petter10 pointsBadges:
  • Excel RTD and userform

    I need to read data from the spreadsheet into userform anyone can explain it to me? whenever i call the userform the cell stop from being updated/

    JonsIL45 pointsBadges:
  • Shading on Click and Drag

    When I click and drag to paint a range of cells, the shading doesn't show up. Is there a way to change my preferences and darken the shading?

    Foreverstargirl5 pointsBadges:
  • Power Point 2000

    Hello all, I have a bit of a challenge for you guys :-) I am having a problem with a computer that runs Windows XP, with Office 2000, when the users tries to use Power point it works ok, but when she attemps to insert a Chart she gets the option to double click on the middle of the chart that gets...

    CGarcia26C1,025 pointsBadges:
  • Trouble with pf transfer to excel

    I want to transfer an externally defined data file from the as400 directly into an excel file format, then send the file via email. I have email already set up. My problem is getting the file translated correctly for excel. I do not have client access. I have used cpytopcd for spool files, but...

    zbbwoc95 pointsBadges:
  • Shift Differential

    How can I write a formula for shift differential if 06:00-14:00 is normal working, 14:00-22:00 is $1.00 more an hour and 22:00-06:00 is .90 more an hour? (A5 Work Hours ) (B5-Sunday start) (C5- Sunday End) (D5- Monday Start) (E5- Monday End) etc. Thanks you to any one that can help.

    Bradyman69920 pointsBadges:
  • Excel – Question

    How can I copy multiple selections in Excel worksheet

    Nadeemzuhair10 pointsBadges:
  • Can I call upon the username of someone logged into the pc, and use it in a web link?

    Hi all, Basically, I've got a webpage I'm working on, and I'd like to be able to provide a link in that page, that will take a user into their home folder on the network. Since it'll be different for each user, but it uses their username as their home folder, I'm thinking there must be a way, to...

    Linger19740 pointsBadges:
  • What is NAT port forwarding?

    Describe in brief how you would set up port forwarding on a NAT router to allow a PC on the LAN to publish its web to the internet.

    1111100 pointsBadges:
  • Excel question

    Is there a way to rename the cell in Excel? For example...Cell A...Change the name from Cell A to Apple....

    Aristoniki15 pointsBadges:
  • Word 2003 window activation delay

    How can I find out the cause of a delay of 15-30 seconds when a Word2003 wndow is reactivated, e.g., after moving to another Word or other appl'n window and back again; the word window is dead, not even cursor flashing, for this delay. No HD activity. No virus checking message. It does NOT apply to...

    DaiCymru55 pointsBadges:
  • Excel 2003 Cell has formula but empty Value or text

    Hya I have a formula into Excel worksheet cell this value comes from out side Excel. sometimes there is a number and sometimes it contains nothing. I have used isblank isempty when the cell is empty and they return true (due to the formula inside the cell) do u thing i can chek if the cell is empty...

    JonsIL45 pointsBadges:
  • Range of one cell backcolor in excell 2003

    Dear Sir Madame I am doing a function in Excel 2003 that takes three cells as range data-type. the function all it does is to see if two of the cells equal to the third one. if yes I want to color the background as green Can anyone reply to my request? Thanks in advance p.s. I am using the RTD...

    JonsIL45 pointsBadges:
  • Excel cell referencing across worksheets

    In the past I used to be able to caculate a cell reference on another worksheet in the same spreadsheet and get the value(contents) and use it in the worksheet that was referencing out, but this feature seems to have disappeared. At present I am using Excel 2003. Any suggestions?

    Ianh5 pointsBadges:
  • Excel Functions

    I am compiling a sales report that with all the sales figures of different branches in my region, these figures are then listed from the best performer to the worst performer in a separate spread sheet using the large function in excell my problem is how do I get the name of the stores to follow...

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