Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Comparing Excel Spreadsheets


  • Please log in to reply
3 replies to this topic

#1 Hal06

Hal06

  • Members
  • 919 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:New York, New York, USA
  • Local time:12:52 PM

Posted 14 June 2018 - 11:30 AM

Hi.

 

I have several spreadsheets each one dealing with a specific type of product and a list of persons associated with that product. I also have a master spreadsheet that covers all products and all persons. I want to make sure the master spreadsheet contains all of the information on the various specific spreadsheets.

 

What is an easy way to do this?

 

Thanks.



BC AdBot (Login to Remove)

 


#2 hamluis

hamluis

    Moderator


  • Moderator
  • 55,746 posts
  • ONLINE
  •  
  • Gender:Male
  • Location:Killeen, TX
  • Local time:11:52 AM

Posted 14 June 2018 - 12:49 PM

I think that I would use Access for such, rather than Excel. Just a personal bias, based on my limited use of each.

 

Worth A Look.

 

Louis



#3 Hal06

Hal06
  • Topic Starter

  • Members
  • 919 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:New York, New York, USA
  • Local time:12:52 PM

Posted 14 June 2018 - 01:22 PM

Thanks for the tip!



#4 daveydoom

daveydoom

  • Security Colleague
  • 108 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Ontario, Canada
  • Local time:12:52 PM

Posted 18 June 2018 - 07:18 PM

If you do use Excel you'll want to write a macro to ensure the master list is updated from the other lists.  

 

I wouldn't say either option (Excel or Access) will provide "an easy way to do this" unless you already know how to create VBA macros or use Access effectively :)  .


"A computer beat me in chess, but it was no match when it came to kickboxing"
-Emo Philips

unite_final.png





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users