simple help

  1. J

    VBA Copy and Paste Values not working

    This code "works" however it will copy over the formulas, I need it to only copy the values. Most of the threads say to do .PasteSpecial xlPasteValues, as you can see I did that below . I am working in two separate workbooks. Am I missing something? :confused: TIA!! Application.DisplayAlerts =...
  2. B

    SIMPLE ISSUE with dragging a reference

    I need I drag a simple cell reference through a series of rows AND columns for example... In cell a1 =m1 b1 =m2 c1=m3 A2 =m4 b2 =m5 c2=m6 When I drag it it obviously drags incorrectly. I also tried making m absolute but it still did not drag correctly. I just really don't want to...
  3. B

    Help on Excel Formula using Sum and If

    My spreadsheet has a list of customers and invoice amounts and a yes or no that indicates whether or not they have paid. I want to sum only the amounts that have been marked as a yes (for paid.) I tried using the sumif function but it didn't work correctly. My next idea was to do an imbedded...
  4. T

    New Excel User - Simple Word Count Tracker Help

    Hello all, This is probably a very simple challenge that I've run into, but I am a writer, and I am currently trying to create a spreadsheet that tracks how many words that I type daily. I am currently using Google Docs spreadsheet application online, but have access to Office 2007 on a...

This Week's Hot Topics

  • separating multiple Proper names (uppercase letters) from a list
    I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
  • 'for' Loop
    Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
  • Open specific pdf in folder with vba
    Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
  • What is wrong with this For Loop code?
    I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
  • Data to match
    Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
  • Shifting Columns
    Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top