Results 1 to 6 of 6

formula that pulls data from multiple cells and puts it in every 2 rows

Threaded View

cmorten82 formula that pulls data from... 10-20-2014, 11:43 AM
Pete_UK Re: formula that pulls data... 10-20-2014, 12:02 PM
cmorten82 Re: formula that pulls data... 10-20-2014, 12:06 PM
Ron Coderre Re: formula that pulls data... 10-20-2014, 12:11 PM
cmorten82 Re: formula that pulls data... 10-20-2014, 12:25 PM
Ron Coderre Re: formula that pulls data... 10-20-2014, 12:34 PM
  1. #1
    Forum Contributor
    Join Date
    09-11-2014
    Location
    Eugene, Oregon
    MS-Off Ver
    MS EXCEL 2010
    Posts
    210

    formula that pulls data from multiple cells and puts it in every 2 rows

    Alright so far I have not found anything that works and is efficient. I have attached a spreadsheet and within that spreadsheet there are two tabs (Sheet1, Data). Sheet 1 will have a formula for every cell in column D and it will pull the data from the Data tab in cells F,C,B,D (In that order) and place that data in Column D. The formula that is currently in there does exactly what I need but when I drag the formula down it takes way to long to process, it says Calculating: (8 Processor(s)) and has even crashed my computer. I have 16GB RAM and an Intel 8-core Haswell Extreme Edition processor (the i7-5960X) so I don't need any upgrading. . The idea is that I am working with debits and credits and this data will be fed into an Oracle system and what I need is that formula to pull that specific data into two rows (Debit row, Credit Row) so D2 and D3. so basically the formula in sheet 1 cell D2 will concatenate the data in F2,C2,B2,D2 from the data tab and then I want to drag that formula down and have it place the exact same data (F2,C2,B2,D2) into sheet 1 cell D3 as well. and then if I drag the formula down to cells D4 and D5 it will have concatenated the data from F3,C3,B3,D3 from the data tab into those cells. I would continue to drag as this data sheet will be filled daily with new data and is usually around 60-100 rows of new data every time. Thanks for any help
    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. formula that pulls data from one cell and puts it in every 2 rows
    By cmorten82 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-16-2014, 06:48 PM
  2. Macro that pulls data like vlookup but for multiple instances
    By finance14 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-27-2011, 10:53 PM
  3. Excel 2007 : Multiple Data Web Pulls
    By ScottKuh in forum Excel General
    Replies: 0
    Last Post: 01-31-2011, 11:47 PM
  4. macro that puts a formula in a group of cells then goes and values those cells
    By caliskier in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-31-2007, 02:00 AM
  5. Replies: 2
    Last Post: 03-20-2007, 05:58 AM

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