new excel user

  1. K

    Need to add time to multiple cells containing date AND time of previously created spreadsheet

    Hello, I am Using Windows 7 and Excel 7, I have a previously created spreadsheet in which cell B2 contains the date AND time. It looks like this: 2015-07-17 12:55. There is no formula in the formula bar, and it is in a "general format" as best I can tell. (I did not create this spreadsheet.) The...
  2. T

    Macro to import table from word file to successive rows or columns in excel

    Hi folks, as my name suggests I am fairly new to VBA and the world of macros but am already enjoying it :) I wanted to develop a macro which will import a table or a part of a table from word files (user to be prompted for the location of the word file) in to a single excel worksheet on to...
  3. C

    The Final Pieces to the Puzzle, anyone?

    Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim c As Range If Target.Cells.Count > 1 Then Exit Sub Set c = Intersect(Range("C14:C28"), Target) If c Is Nothing Then Exit Sub Cells(Target.Row, 1).Resize(, 5) = "" Target = "X" End Sub I had seen this on a previous post in...
  4. K

    Help with VLOOKUP and SUMPRODUCT formula

    Hi all, I am wondering if you could help me with the following? <tbody> A B C D E 1 Name Start Date Team Language Agent 2 Bob Smith 01/01/2014 Gareth English New 3 Jenny Lemon 01/01/2014 Ben English Experienced 4 Richard Smith 01/01/2014 Laura English Experienced 5 Steve...
  5. S

    HELP! New to coding-need to split workshhet into multiple by finding a word that ends the data each time

    Hi. I am not really a coder and this is new to me but I have an extremely large spreadsheet I need to disect into a seperate workbook for each set of data. While browsing on this forum I saw many references for splitting data, but it always split it due to a certain value in a column. My...
  6. N

    Multiple Images import with Macros (specific)

    Dear all, I have a question. Please see below image. I have the Item names in D drive folder named Images. Over 27000 Images are in there. I want when I write the image name in cells (B2 to B2000), Images should appear itself in front of them in (A2 to A2000). Please help. All Images are in...
  7. 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...

Watch MrExcel Video

This Week's Hot Topics

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