Results 1 to 7 of 7

Copy data with 4 cell interval and copy range of data like vlookup with structured output

Threaded View

Daydreams Copy data with 4 cell... 08-21-2013, 10:37 AM
patel45 Re: 2 beginner problems 08-21-2013, 11:55 AM
patel45 Re: Copy data with 4 cell... 08-22-2013, 03:33 AM
Daydreams Re: Copy data with 4 cell... 08-22-2013, 04:54 AM
HaHoBe Re: Copy data with 4 cell... 08-23-2013, 12:02 AM
Daydreams Re: Copy data with 4 cell... 08-23-2013, 04:08 AM
Daydreams Re: 2 beginner problems 08-22-2013, 02:37 AM
  1. #1
    Registered User
    Join Date
    08-19-2013
    Location
    Germany
    MS-Off Ver
    Excel 2003
    Posts
    6

    Copy data with 4 cell interval and copy range of data like vlookup with structured output

    Hello everyone,

    first i would like to welcome myself as a new member of the forums, I came here because if have been struggling with a project for which i have to sort trough large amounts of data. I tried researching and tackling the problem myself however unfortunately i couldn´t find the solution online, if i missed a link to a topic with similar problems please forgive my ability to search and with a link to that topic i will be able to help myself.

    so the first problem is the following.
    I want a macro to copy range A1:B1 to A2:B2(I got this far =), then I want the macro to add an X number of cells to its copy range, in this example lets X be 4 cells and then I want it to repeat the process, copy from cell F4:G4 to A3:B3 the next copy sequence will be K8:L8. So the difficulty for me is now: what code to use to let the copy macro automatically skip 4 cells every time it makes its copy routine.

    My second problem has to do with data selection.
    If it is possible I would like to copy a specific range from a large range. More specifically I´m looking for a way to first search for a specific word like chairs, then I would like the macro to copy the cell containing the word chairs and the cell next to this. Like A1 (chairs) B1 (20) and after this paste it in a defined place A2:B2 or something. The word Chairs shows up multiple times in my dataset each time with a different amount and I would like to have a list of these amounts. lets say the range is from A1 to AA20

    I tried to apply different filters and sorting techniques however due to the very random distribution of the chairs in my dataset i cannot get this to work.

    thanks in advance for any help
    Last edited by Daydreams; 08-23-2013 at 04:09 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hello from a beginner
    By bstinson in forum Hello..Introduce yourself
    Replies: 5
    Last Post: 08-11-2013, 09:57 PM
  2. Help please for a beginner
    By LACKLUSTABUSTA in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-20-2010, 06:41 AM
  3. Beginner
    By Mardikas09 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2009, 05:59 AM
  4. Beginner needs code to be proof read (there ARE problems)
    By dcase in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-29-2006, 11:20 AM
  5. Please help a beginner....
    By Lindsey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-25-2005, 12:11 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