COPYING DATA FROM EXTERNAL ARCHIVE

[fher9728]

Hi,

I have a table were I need to paste numbers from external archives, not from my workbook, the thing that I have these columns:

# -B	UPC - C	Cant. -D	Descripción - E	Cod. SAP -F	Cantidad -G

I need two things, when i paste data to upc if I only paste one upc for example I want that in column #-B shows the first number - 1, and if I paste two values of upc I want it to show in Colum #-B 1, 2 and that successively, the other thing i want to do is that if i a paste a value in Column Cant. -D I want it to show the same exact value in column cantidad-F in a consecutive way, I can do it with formulas but I need to be with vba code, and I've been trying and I can't get a solution to this, this is an example of what i want,

please if you can help me,

thanks

 

[fher9728]

cross posted right here:
Macro for copying data from external archive and range(d6:d70)=range(g6:g70)