Hi all,
I need to copy cell value in D:1 onto a range of cell (O:3 to O:31) and from D:34 onto (O36: to O66) and so on... i.e. every 33 rows
I have a few hundred of these excel files to grapple with so it's really not an option to do it manually. Also each excel file has different size, e.g. some starts from 1960 and ends at 1981 while some starts from 1965 and ends at 1971.
I would really appreciate it if someone can suggest a macro that will do the job. Many thanks!
JA
Configuration: Windows XP Internet Explorer 7.0
This might be a start to solving your problem. This macro will highlight the data that you need so that you can extract it. don't have advice on the rest of the problem
|
Copy & paste disabled Cutting and pasting values from formulas in excel Excel copy paste date change Excel image macro copy to another workbook Excel macro copy cell then move next cell Excel macro copy paste clipborad Excel macro copy row range Excel macro if cell then delete row Excel macro if cell value hide row Excel macro loop for values in column and return copy of multiple rows insted of one Excel macro to copy paste till blank cell Excel macro vb paste value from formula Excel run macro when list value changes Excel vba macro copy range from personal and paste into active workbook Macro copy paste entirerow Search worksheet copy paste cell vba Show me the macro copy and paste excel Vba get column number of last value in row