Results 1 to 10 of 10

How to get Data from multiple worksheets & put them on one worksheet

Threaded View

Marchie69 How to get Data from multiple... 01-10-2015, 07:43 AM
Richard Buttrey Re: How to get Data from... 01-10-2015, 07:49 AM
Richard Buttrey Re: How to get Data from... 01-12-2015, 07:05 AM
Marchie69 Re: How to get Data from... 01-10-2015, 08:12 AM
Richard Buttrey Re: How to get Data from... 01-10-2015, 05:05 PM
OM1950 Re: How to get Data from... 01-11-2015, 02:26 AM
OM1950 Re: How to get Data from... 01-11-2015, 02:23 AM
Marchie69 Re: How to get Data from... 01-11-2015, 12:13 PM
Marchie69 Re: How to get Data from... 01-12-2015, 06:24 AM
Marchie69 Re: How to get Data from... 01-12-2015, 07:20 PM
  1. #1
    Registered User
    Join Date
    01-09-2015
    Location
    Yorkshire, UK
    MS-Off Ver
    2010 64bit
    Posts
    5

    Question How to get Data from multiple worksheets & put them on one worksheet

    This is my first post so please bare with me.
    I've attached a copy of my workbook so you can what I am trying to do.

    I have seperate "Expenses" & "Income" sheets for each month and I want to pick out just the Cheques from the expenses sheets,
    together with the Date, Descripton, Cheque (amount) and Cheque # (number) and display them on a seperat worksheet.
    This would make it easy for me to see at a glance what cheques have been written.
    I've used "IF" statment but as you can see, it displays 0's and an odd date in the blank cells

    Any help would be appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need to combine data from multiple worksheets in multiple workbooks into 1 worksheet
    By ginric99 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-30-2013, 07:58 AM
  2. Combine data from multiple worksheets into a new worksheet
    By duugg in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-17-2009, 12:29 AM
  3. Replies: 0
    Last Post: 01-15-2008, 12:19 AM
  4. Replies: 0
    Last Post: 03-25-2007, 11:44 AM
  5. Compiling data from multiple worksheets into one worksheet
    By thelonious419 in forum Excel General
    Replies: 1
    Last Post: 04-24-2006, 01:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1