Hello,
I am new to Macros and need an urgent help regarding the same.
my requirement is first to calulate the number of records present in the sheet and then based on this copy an entire column and paste it to a row present in another sheet.
Just to make it more clear, say i have two sheets "data" and "average". now i want to first calculate the number of records present in the sheet "data". say it is 100. now copy all the 99 records present in the column L (excluding the headrer row from L2 to L100). and now paste all these records in a row present in the "average" sheet (C6 to CW6)
please help me out in this. its really urgent!!!!!!!!!!!!!!
thanks for your help in advance.
Configuration: Windows 2003 Internet Explorer 7.0
Hi,
|
'excel macro' 'copy data from single text file to excel' Convert multi columns text into one column in excel Copy columns from one excel to another if match using macro Copy columns from one excel to another using macro Copy data from one spreadsheet to another if it matches Copy mulitple cells into one Excel 2007 macro select columns by header string Excel macro to open excel files copy data Excel macro to open xls files and copy data Excel row count macro Get last row cell macro How do i copy and paste data from a webpage to excel on a mac How to find a last row in a selected column in vba How to get data off of a memory card into a harddrive How to match a table column data with another How to use a button to import data into excel from another worksheet Replace a data in multiple columns using macros in excel Select to last column of a row macro