Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by JayMan25

  1. JayMan25

    Excel - Copy Entire Row From One Worksheet to Another

    I understand that part but it I still cant figure out how to copy and paste only the rows with "Yes" in them in column G example A B C D E F G H 1 dog cat bird mouse good hungry yes sick 2 cat dog good mouse good hungry no sick 3 cat...
  2. JayMan25

    Excel - Copy Entire Row From One Worksheet to Another

    Sorry I wasn't clear about this I want To Use a Macro to do all of this.
  3. JayMan25

    Excel - Copy Entire Row From One Worksheet to Another

    Hey Guys or Ladies, I can't figure out how to copy an entire row based on the data from one column. For example if I start at column G5 from worksheet named(old data) if the column has "Yes" in it then I want to copy all the data in that is in row 5 to another worksheet named(new data)...
  4. JayMan25

    Resize Word Metafile from Excel SpreadSheet

    Thanks!
  5. JayMan25

    Resize Word Metafile from Excel SpreadSheet

    When the metafile is pasted into the word doc its size is to big to fit on the page properly. I just can't figure out how to change the height and width of the image to fit on the page using VBA. Also is there a way to compress the image file size as well?
  6. JayMan25

    Resize Word Metafile from Excel SpreadSheet

    Hey guys i'm having a problem trying to figure out how to resize this metafile image that i'm pasting into word. Here is the code so far. I'm new at this and I'm stuck. Public Sub Create_Word_Report() Const wdWindowStateMaximize As Integer = 1 Const wdPrintLayoutView As Integer = 3 Const...
See more

Part and Inventory Search

Back
Top