Cell Reference

[Andri]

Dear All,

I have two workbook A.xls and B.xls (where consist of 3 sheets).

I would like to combine all Part Number in B.xls into A.xls with the
following condition.
1.Sheet 1 - 15 records, sheet 2 - 35 records and sheet 3 - 50 records.
2.the first records of every sheets start from F4.
3.I would to combine those 100Records into A.xls.
4.When touch at the last row, then go to the next sheet, until 100 records.
5.In A.xls finally will leased those records from A1 to A100.

Please how to link those cell by VBA?

thank you for your kind help/.

respectfully,
andri

 

[Bob Bridges]

Hi, Andri. I gather you're starting from scratch, here - that is, you don't
know much about VBA programming yet. Nothing wrong with that; we all had to
start at the beginning. The best way I know to get a sample program that'll
do what you want is to start by recording a macro in Excel. Start recording
the macro, do what you want to do, then stop the recording and look at the
resulting program. In this case it will NOT do everything you want it to do,
but you'll get an idea of how to start. Then, if you have some programming
experience, you should have some idea of how to make the program closer to
your goal. Even then you'll probably need to ask a few questions, if you're
as new to this as you sound, but that's ok: By then you'll be able to ask
more specific questions, with perhaps an example of what your code looks like
so far.

If you DON'T have any programming experience, you probably should back up
and start with a simpler task than this one. But I'm guessing you already
know a little about programming and just need to get a little further, right?