Multiple users updating one excel spreadsheet

I am seeking one suggestion on how to build an excel macro for below requirement.

Request you to provide your valuable comments in EXCEL Only.

You might suspect that we always come down in favour of using spreadsheets for business applications. (I don’t admit to having heard of Fun Boy Three or Bananarama…).

The truth is that there is only ever one answer to the question: The answer is: “It Depends! Spreadsheets are a tool, and like any tool you need the right one for the job. So, it might be useful to list the Seven Deadly Spreadsheet Sins, how to avoid temptation and be delivered from all evil.

Scenario I have one spreadsheet "Product Master" that contains all the product details. Product ID, Product Name, Product Type, Quantity etc etc) I am designing a using excel VBA where anyone can fetch all the details of a product based on its Product ID.

Now the product-master sheet where all the product details is present will get updated on a daily basis.

The problem is that people like to view data in a totally different way than a computer likes to process it.

Bring data into a workbook in tables, calculate in tables and then present a report using matrices, graphs, charts, summarized tables or anything else that makes the data readable. Spreadsheets are error-prone because they have thousands of live formulas that are almost impossible to check. Not only do multiple live formulas increase the probability of error, they can also make the workbook fat, unwieldy and slow.

The solution is to set each formula in one cell, paste it to every record and replace with values.

People make decisions without full set of the facts.

Inconsistency can be ironed out by using a systematic worksheet structure.

Leave a Reply

  1. sex dating in west mississippi 25-Dec-2019 21:13

    Elizabeth Olsen is apologizing for being “tired and inarticulate” for the second time in 15 minutes, but actually she seems exactly like her usual whip-smart, thoughtful, engaging self.

  2. chemistry and attraction dating 18-Jun-2020 10:04

    Many of the couples also love it when users broadcast their own webcams!

  3. dakota dating personals picture services south 30-Nov-2019 11:59

    They’re taking things very, very slowly.” The couple split in November after 18 months together, blaming their hectic work schedules for the relationship meltdown.

  4. dating girls in laos 17-Oct-2019 17:22

    Having a loan or repayment plan with one monthly payment that fits your budget will let you pay all of your debts off and get you back on track with your finances.

  5. average height dating 06-Dec-2019 12:43

    Is the actress best known for her roles in Smallville or V really single again? (read more)Vandervoort spotted alone A fan spotted Laura Vandervoort walking alone, probably coming back from picking up her mail at the end of her several mile long driveway, on the afternoon of May 29, 2018. “Definitely yes,” says the fan, adding that “She was wearing a large sweater and looked really cute! A rep for Laura Vandervoort was not immediately available for comment.