Macro to extract data up to a certain Value

[Howardc1001]

I have data in Sheet Imported Data


I would like to macro to copy the data on sheet "imported Data" up to the maximum value on sheet "Extract' on Col U2


Your assistance in this regard is most appreciated

[vcoolio]

Hellow Howard,

I've assumed that you are basing the extracting on Column F in the Import Data sheet and want it pasted to the Extract sheet.

I've attached your sample with the code implemented and based on the above assumptions.

I've formatted Column F to Accounting. The same for U2 in the Extract sheet. I've also assumed that you'd want the Extract sheet cleared with each transfer of data.

Here's the code:-

Please Login or Register  to view this content.

I hope that this helps.

Cheerio,
vcoolio.

[Howardc1001]

Thanks Vcoolio

All the values are being extracted to sheet2

I only want the value <= the value in U2 to be extracted to sheet2

I have manually extracted the data


Kindly check & amend your code

[vcoolio]

Hello Howard,

........up to the maximum value on sheet "Extract' on Col U2

Have a close look at the filter line in the code.

There's nothing to amend. Have a look at the value you have in U2 then have a look at the values in Column F of the Import data sheet.
They're all below 200,000!
Change it to, say, 18,000 and see what happens.

Cheerio,
vcoolio.

[Howardc1001]

Hi Vcoolio

Sorry for not being clear from the start

The total of all the values that are in Col F to be extracted must not exceed 200,000

[Bo_Ry]

Still not clear

maybe accumulate sum in Col F not exceed 200,000

Please Login or Register  to view this content.

[Howardc1001]

Hi Bo_Ry


your code works 100%

[vcoolio]

Hello Howard,

Looks like Bo_Ry took care of business whilst I was sound asleep.
Pretty nifty I must say!

Good to see you have another one sorted out!

Cheerio,
vcoolio.