Vba problem

Closed
irum - May 21, 2012 at 07:21 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 24, 2012 at 09:58 AM
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 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
May 24, 2012 at 12:33 AM
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.
0
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
0
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
May 24, 2012 at 08:41 AM
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
0
How I can sent?In attachment?Or only the fiels I should sent?
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
May 24, 2012 at 09:58 AM
Hi Irum,

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

Best regards,
Trowa
0