Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-06-2015, 08:28 AM
HAWKE HAWKE is offline Product information database Windows 7 64bit Product information database Office 2010 64bit
Novice
Product information database
 
Join Date: Jan 2015
Posts: 2
HAWKE is on a distinguished road
Default Product information database

HELLO



I work for a large company and I am trying to build a simple database of our products that can be used by the technical team

we have a range product that requires a text to be attached. there are a total of 30 products that come in 10 different sizes with 20+ different screw threads

each text needs to contain the size and the thread. each product has a different certification

Is there a way I can input a product name size and thread required into 3 separate cells and have a 4th cell produce the required text with the modification's to it ?

I will type each certification variation if need be
Reply With Quote
  #2  
Old 01-06-2015, 12:30 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Product information database Windows 7 64bit Product information database Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,919
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Hi
perhaps post a sample sheet ( no pics please). Thx
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 01-07-2015, 12:47 AM
HAWKE HAWKE is offline Product information database Windows 7 64bit Product information database Office 2010 64bit
Novice
Product information database
 
Join Date: Jan 2015
Posts: 2
HAWKE is on a distinguished road
Default

hi

i don't have a sample sheet i have been trying to work out how to do this and made no progress

i tried using filtering to do this but i cant seem to get the information to stay together the way i want
Reply With Quote
  #4  
Old 01-07-2015, 07:24 AM
gebobs gebobs is offline Product information database Windows 7 64bit Product information database Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

A sample sheet with a few examples of the data you have (products, screw heads, etc.) would be helpful.
Reply With Quote
  #5  
Old 01-08-2015, 01:03 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Product information database Windows 7 64bit Product information database Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,919
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Quote:
Originally Posted by HAWKE View Post
hi

i don't have a sample sheet i have been trying to work out how to do this and made no progress

i tried using filtering to do this but i cant seem to get the information to stay together the way i want
But you do have some data (on a sheet , no pics) and examples of what you should obtain?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Tags
database, keywords



Similar Threads
Thread Thread Starter Forum Replies Last Post
Product information database Help with Sum Product johnberman Excel 2 05-08-2014 02:32 AM
Product and Sum on 2 rows apolloman Excel 2 04-27-2011 07:14 AM
product key cplove Office 3 03-25-2010 09:17 PM
Product Key. Spirit Office 0 02-02-2010 10:27 AM
product key Tom-Aspin Word 1 01-25-2010 04:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:07 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft