Experts,
In the attached workbook (EE-FROM_DATABASE-03-2008_
NB.xls) I have a data import from a database on worksheet (DATA). What I want to do is create some code in VBA to copy most cells from (DATA) to (TEMP) but in a new order. The reason for this is that the export from the database comes in a specific format (from an .exe file), thus I must manually move this report around.
Right now, I really want to learn some basic VBA stuff, so if someone can give me some of the code, say how to copy one or two ranges, then I can do the rest. I will then have a follow-up set of questions, I am sure, as I need to do some formulas within the VBA, but I want to learn so one step at a time, right?!?!
1. I want to copy all data in (DATA) column O, starting at O2 and going down to the end of the column, where data is present. I assume that something like .filldown would be needed, as each time this data is imported, it will occupy a different range (in terms of rows down). This data will end up in (TEMP) A2.
2. Whatever is used for the above (select column O. copy to TEMP.A2, etc) can I do that over and over again?
As (DATA) P2 needs to be copied to (TEMP) B2,
Then
(DATA) A2 needs to be copied to (TEMP) C2, and so on.
Thank you in advance!
Kevin
***edited for content, M_matt***
Start Free Trial
