Transaction to Inventory excel VBA using macro

**mohi021** · 01-17-2021, 05:33 AM

Hello guys!

I want to write a macro to receive data from the 'Transaction' sheet and gives me an 'Inventory' sheet but I don't know how to do it

(the 'Transaction' sheet may contain many shares so the macro should count them all and if we sell a share that we don't have in the first place,(short it) it should warn us)

could you please help me??

**Trebor76** · 01-17-2021, 08:26 AM

Hi mohi021,

Welcome to the forum.

I'm sure about "if we sell a share that we don't have in the first place,(short it) it should warn us" but this will do everything else:

Please Login or Register  to view this content.

Regards,

Robert

**mohi021** · 01-17-2021, 10:10 AM

Thanks a lot, man! you are a true savior!! <3
I have a few questions if you bear me,

1)when I delete the data on the 'Inventory' sheet(just Second row onwards) and for example add a new set of data for 'Transaction's
it will delete the first row on the 'Inventory' sheet, and when I want to set another batch of data for 'Transaction's and run the Macro
It says 'Object variable or with block variable not set'...so the macro deletes the Header Row for the 'inventory' sheet. I want the first row
on the 'inventory' sheet to remain.
.
2)our language is Persian (Arabic letters) so, if I change the cells' data into Persian, would it destroy the code?
.
Thank you very much

**Trebor76** · 01-17-2021, 06:21 PM

Hi mohi021,

you are a true savior!!

Hardly. Just another Excel user

1 - The code clears and reimports the data to the Inventory tab so you don't have to do that manually. The revised code does however only delete from Row 2 onwards.
2 - No, it shouldn't matter. You will have to test that yourself though.

Thanks,

Robert

Please Login or Register  to view this content.

Transaction to Inventory excel VBA using macro

LinkBack

Thread Tools

Rate This Thread

Display

Transaction to Inventory excel VBA using macro

Re: Transaction to Inventory excel VBA using macro

Re: Transaction to Inventory excel VBA using macro

Re: Transaction to Inventory excel VBA using macro

Thread Information

Users Browsing this Thread

Similar Threads

Excel Inventory - create shopping list based on inventory taken

[SOLVED] Inventory management macro subtracting too much inventory

[SOLVED] Macro for finding Last day of transaction

[SOLVED] macro to record transaction

Complicated set of calculations based on transaction IDs, transaction value, etc.

Lastest transaction date for each inventory item

Excel Inventory Macro

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions