Populating table in stages

**jsantos** · 03-03-2019, 01:49 PM

Hi all

Started a project that proved more complicated than anticipated.
Basically I have 20 clients that sent me their requests by e-mail on pdf format, which is ready on range C23:E72.
I want to extrac the info from the 20 different pdf docs one at a time and the way I see it, is that once each is copied across to excel I then need to copy the range of cells (C23:E72) and paste values on a certain cell on the same sheet. I say certain cell because cell C18 will have the client reference number which will dictate where on the table the information needs to go. For example, Client 1 reference on table will be on cell R22, Client 2 will be on Cell V22 and so on.

I can create a basic VBA code to copy and paste values but have no idea how could I paste it on the correct place?
I do understand I am asking a lot, but any help will be appreciated.

Thanks
jsantos

**bakerman2** · 03-03-2019, 10:52 PM

Will this do ?

Please Login or Register  to view this content.

**bakerman2** · 03-04-2019, 04:03 PM

Glad to help and thanks for rep+.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

**jsantos** · 03-05-2019, 05:02 PM

Didn't want to start another thread, as my next question is kind of similar, can move if nescessary.

I now have all the info populated on a table and need to move it across to a different table so its ordered by product line and store. I have done it but was wondering what other ideas are out there.
The way I did it was by naming ranges and then using these as references for a Vlookup nest formula. Is there a way to get the same done but using VBA?

This gives an idea of what I have done
Sorting SHEET (ranges) TSY Orders SHEET
Store1 =Sorting!$R$23:$U$72 C5 =IF(ISERROR(VLOOKUP(A5,Store1,3,FALSE)),"",(VLOOKUP(A5,Store1,3,FALSE)))
Store2 =Sorting!$BB$23:$BE$72 D5 =IF(ISERROR(VLOOKUP(A5,Store2,3,FALSE)),"",(VLOOKUP(A5,Store2,3,FALSE)))
Store3 =Sorting!$BF$23:$BI$72 E5 =IF(ISERROR(VLOOKUP(A5,Store3,3,FALSE)),"",(VLOOKUP(A5,Store3,3,FALSE)))
Store4 =Sorting!$BJ$23:$BM$72 F5 =IF(ISERROR(VLOOKUP(A5,Store4,3,FALSE)),"",(VLOOKUP(A5,Store4,3,FALSE)))
Store5 =Sorting!$BN$23:$BQ$72 G5 =IF(ISERROR(VLOOKUP(A5,Store5,3,FALSE)),"",(VLOOKUP(A5,Store5,3,FALSE)))
Store6 =Sorting!$BR$23:$BU$72 H5 =IF(ISERROR(VLOOKUP(A5,Store6,3,FALSE)),"",(VLOOKUP(A5,Store6,3,FALSE)))
Store7 =Sorting!$BV$23:$BY$72 I5 =IF(ISERROR(VLOOKUP(A5,Store7,3,FALSE)),"",(VLOOKUP(A5,Store7,3,FALSE)))
Store8 =Sorting!$BZ$23:$CC$72 J5 =IF(ISERROR(VLOOKUP(A5,Store8,3,FALSE)),"",(VLOOKUP(A5,Store8,3,FALSE)))
Store9 =Sorting!$CD$23:$CG$72 K5 =IF(ISERROR(VLOOKUP(A5,Store9,3,FALSE)),"",(VLOOKUP(A5,Store9,3,FALSE)))
Store10 =Sorting!$CH$23:$CK$72 L5 =IF(ISERROR(VLOOKUP(A5,Store10,3,FALSE)),"",(VLOOKUP(A5,Store10,3,FALSE)))
Store11 =Sorting!$CL$23:$CO$72 M5 =IF(ISERROR(VLOOKUP(A5,Store11,3,FALSE)),"",(VLOOKUP(A5,Store11,3,FALSE)))
Store12 =Sorting!$V$23:$Y$72 N5 =IF(ISERROR(VLOOKUP(A5,Store12,3,FALSE)),"",(VLOOKUP(A5,Store12,3,FALSE)))
Store13 =Sorting!$CP$23:$CS$72 O5 =IF(ISERROR(VLOOKUP(A5,Store13,3,FALSE)),"",(VLOOKUP(A5,Store13,3,FALSE)))
Store14 =Sorting!$Z$23:$AC$72 P5 =IF(ISERROR(VLOOKUP(A5,Store14,3,FALSE)),"",(VLOOKUP(A5,Store14,3,FALSE)))
Store15 =Sorting!$AD$23:$AG$72 Q5 =IF(ISERROR(VLOOKUP(A5,Store15,3,FALSE)),"",(VLOOKUP(A5,Store15,3,FALSE)))
Store16 =Sorting!$AH$23:$AK$72 R5 =IF(ISERROR(VLOOKUP(A5,Store16,3,FALSE)),"",(VLOOKUP(A5,Store16,3,FALSE)))
Store17 =Sorting!$AL$23:$AO$72 S5 =IF(ISERROR(VLOOKUP(A5,Store17,3,FALSE)),"",(VLOOKUP(A5,Store17,3,FALSE)))
Store18 =Sorting!$AP$23:$AS$72 T5 =IF(ISERROR(VLOOKUP(A5,Store18,3,FALSE)),"",(VLOOKUP(A5,Store18,3,FALSE)))
Store19 =Sorting!$AT$23:$AW$72 U5 =IF(ISERROR(VLOOKUP(A5,Store19,3,FALSE)),"",(VLOOKUP(A5,Store19,3,FALSE)))
Store20 =Sorting!$AX$23:$BA$72 V5 =IF(ISERROR(VLOOKUP(A5,Store20,3,FALSE)),"",(VLOOKUP(A5,Store20,3,FALSE)))

Thanks
Jsantos