vba problem Closed

Question

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




Configuration: Windows 7 / Internet Explorer 9.0

venkat1926 · Answer

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.

irum · Answer

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

venkat1926 · Answer

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

irum · Answer

How I can sent?In attachment?Or only the fiels I should sent?

Vba problem

4 responses

Similar discussions

Subscribe To Our Newsletter!