HI ALL
i enter data in master sheet and want to send data from master sheet to sale / purchase sheet vba
can any body help me to solve this
Thanks
sharing sample file
HI ALL
i enter data in master sheet and want to send data from master sheet to sale / purchase sheet vba
can any body help me to solve this
Thanks
sharing sample file
Thread moved to VBA section.
There are instructions at the top of the page explaining how to attach your sample workbook.
A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Post your workbook HERE, please. Don't open duplicate threads.
ok its done by mistake trying to attach file but unable to attach
posting sample file thanks
Non VBA
In Purchase
A4
=IFERROR(INDEX(MASTER_SHEET!$A$6:$A$1000,AGGREGATE(15,6,ROW($A$1:$A$1000)/(MASTER_SHEET!$K$6:$K$1000<>""),ROWS($1:1))),"")
in B4
=IFERROR(INDEX(MASTER_SHEET!$B$6:$B$1000,AGGREGATE(15,6,ROW($A$1:$A$1000)/(MASTER_SHEET!$K$6:$K$1000<>""),ROWS($1:1))),"")
Change highlighted range for other columns
in SAles
A4
=IFERROR(INDEX(MASTER_SHEET!$A$6:$A$1000,AGGREGATE(15,6,ROW($A$1:$A$1000)/(MASTER_SHEET!$N$6:$N$1000<>""),ROWS($1:1))),"")
in B4
=IFERROR(INDEX(MASTER_SHEET!$B$6:$B$1000,AGGREGATE(15,6,ROW($A$1:$A$1000)/(MASTER_SHEET!$N$6:$N$1000<>""),ROWS($1:1))),"")
Change highlighted range for other columns
Last edited by JohnTopley; 12-19-2021 at 01:39 PM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
thanks for your reply i am using this for about 20-25 thousand rows, there for its slows down if possible pls give me this in vba
Please Login or Register to view this content.
Last edited by JohnTopley; 12-20-2021 at 03:00 PM.
Another Option...For this to work I made one small change...Changed tab Sales to Sale
Please Login or Register to view this content.
@ John...
Just a heads up...In the below declaration....Only c is declared as long...the rest take on default variant
Also a good idea to...at the start of your Excel VBA code, add the Option Explicit Statement...This forces you to declare all your variables....In your code if the statement was included it would point out the error of not declaring n1 and n2Please Login or Register to view this content.
B3Gam.png
Last edited by sintek; 12-21-2021 at 03:44 AM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
thanks is working awesome
my thread is SOLVED but i dont know how to mark solved thanks
Glad to have contributed...Tx for rep +
Select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks