Search : in
By :

Macros in Excel so it copies onto next row

Last answer on Nov 4, 2009 6:47:26 am GMT infinityx8, on Oct 13, 2008 8:55:40 am BST 
 Report this message to moderators

Hello,

I'm trying to copy values from one sheet to the other in excel via use of a macro. The data is in rows, and is there anyway that I can program the macro so that it copies the data onto the next row whenever the row above it is occupied. (As you can see I'm new to Visual Basic Code)

Thanks in advance!!!

infinityx8

Configuration: Windows Vista
Internet Explorer 7.0

Best answers for « Macros in Excel so it copies onto next row » in :
How to convert Excel into PDF? ShowHow to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. Step 1 PDF995 is software that gets installed on your computer which enables you to print any sources of document to...
Copy rows based on a condition ShowCopy rows based on a condition Issue Solution Note Issue How can I have excel copy the entire row of data from worksheet Employee Inventory to another worksheet called EEs if column Q contains TERM. I've tried almost everything but...
Management Chart ShowThe Concept of a Management Chart A management chart is a comprehensive graphic representation of a set of indicators that give a manager all the elements needed to make decisions visually and quickly. Considering its strategic value, a...
Ask your question Reply

1

Dave, on Nov 20, 2008 2:30:19 pm GMT
  • +1

You cant you have to insearch a new row when you record the macro then inseart it baby

   
Reply to Dave

2

Lathly, on Dec 17, 2008 3:34:42 pm GMT
  • +1

You could ofcourse use the "Use relative reference", but that means that the selected cell cannot be moved on the sheet you are copying to.

   
Reply to Lathly

3

jonny, on Jan 15, 2009 12:10:32 pm GMT
  • +9

Range("A1").Select
Selection.End(xlDown).Select

i think i might be trying to do a similar task. this is what i tried, if it doesnt help, please disregard as i too am new to vb.

   
Reply to jonny

4

Sambo, on Sep 11, 2009 2:51:17 pm BST
  • +1

1. Copy the cells from sheet 1.
2. Select the top cell of the first column in sheet 2
3. Open Find & Replace (Ctrl + F)
4. Open the options in Find & Replace and change "search by rows" to "search by columns"
5. Leave the value you're searching for blank.
6. Click "Find Next"
7. Paste special (values only)

Only works if you have no other blank cells above the cell you want to paste into.

   
Reply to Sambo

5

 nazish, on Nov 4, 2009 6:47:26 am GMT
  • +1

I want that when i copy the specified rows it paste in colums but after specified colum it paste to next row till spcified colum and so on.

   
Reply to nazish
Ask your question Reply
They need your help