JohnyG
05-19-2008, 03:56 AM
Hi,
I need a help in creating a macro.
I have a file that contains several worksheets. All worksheets contains special type of data for eg "software" sheet contains information about software, "hardware" sheet contains information about hardware and so on so forth.
The last sheet namely "Updates" is consolidated file where in we put in all updated regarding any product or service.
What I want is I need to create a macro that as and when any record get updated in "Updates" macro will check the infomation and update that information in respective pivot table available.
For eg. "Updates" sheet contains request type as "Hardware" that means ""Backordered 19"" Monitors- Nijel :
This backorder did not affect the shipping of bundles." shud get updated in Hardware sheet.
Appreciate any help on the same.
I need a help in creating a macro.
I have a file that contains several worksheets. All worksheets contains special type of data for eg "software" sheet contains information about software, "hardware" sheet contains information about hardware and so on so forth.
The last sheet namely "Updates" is consolidated file where in we put in all updated regarding any product or service.
What I want is I need to create a macro that as and when any record get updated in "Updates" macro will check the infomation and update that information in respective pivot table available.
For eg. "Updates" sheet contains request type as "Hardware" that means ""Backordered 19"" Monitors- Nijel :
This backorder did not affect the shipping of bundles." shud get updated in Hardware sheet.
Appreciate any help on the same.