Search : in
By :

Excel macro: copy between sheets

Last answer on Mar 16, 2009 7:37:31 pm GMT gedas, on Sep 21, 2008 5:59:56 pm BST 
 Report this message to moderators

Hello,

I have sheet1 and sheet2.
I want to create a macro:

-copy Bx:Dx from sheet1 to sheet2 Bx:Dx
-where x from 6 to "get count row number, where cell is not null"


Thanks,
Gediminas

Configuration: Windows XP
Firefox 3.0.1

Best answers for « Excel macro: copy between sheets » in :
Excel Macro Help Please (Solved) Show
Excel – Macro to detect and hide blank rows Show Excel – Macro to detect and hide blank rows Issue Solution Note Issue I want a macro to unhide about 20 blank rows copy values into the top row then hide the remaining rows (some cells have fill though) then the next time it will...
Excel Macro for deleting rows IF cells not... Show
Excel – Macro for copy & paste selected range ShowExcel – Macro for copy & paste selected range Issue Solution Note Issue I have a summary of data by month in one sheet and the raw data in another sheet. Instead of creating multiple worksheets for my raw data for each month, I want...
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
[VBA: VB6] Using excel from another application Show[VBA: VB6] Using excel from another application Here is a little routine to call Excel from VB6 or another Office application. Paste in a general module (eg Module1) In VBA>> Insert>> Module and paste in the window ... In VB6>>...
Ask your question Reply

1

 Helper, on Mar 16, 2009 7:37:31 pm GMT
  • +8

I am doing library project but i have a problems. i need VBA condinal copy and paste in to cell. also every time i paste it need to change to another cell every time.

   
Reply to Helper
Ask your question Reply
They need your help