Vba problem

[Closed]
Report
-
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
-
Hello,

thanks foryour attention.infact I am working in a company where I have to enter the data on the daily basis.So sheet2 is changes.bu sheet one i my master sheet where I have to keep the data for years and I have to upgrade when ever I receive the new data i.e sheet2 ect.and my master sheet is shared.I want some macros so I dont need to put formula daily.just my one click I can get my data.

hopefully you are getting my point.
thanks




4 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
before writing the macro please explain how the new data in sheet 2 can be recognised from the old data.
or
every time the old data in sheet 2 is cleared and then new data is entered.
Hi

Infact sheet 1 is my master sheet.and I ahve to extract data from other sheet.infact sheet 2 is always change whenever my manager provide me new data some time he gave me 2 or 3 spread sheet and said that extract data from these and put it in master sheet.I have to match the order number because this is unique field.on the basis of this I have to extract some field from the same row.
could you please do it early because its urgent.I have to submit report.
thanks
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
post a small extract of master sheet and other sheet if necessary with random data. configuration should be same in your original file. sorry your project is to be taken in the midst of my other work. I shall try to get it as quickly as possible
How I can sent?In attachment?Or only the fiels I should sent?
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
Hi Irum,

Try using www.speedyshare.com to upload your workbook, then post back the link.

Best regards,
Trowa