Using Excel To Create A Customization Catalog?
Jan 21, 2005
I am attempting to create a type of customizable catalog using Excel. This idea is to have one worksheet in the workbook contain a standard set of info for all products, including a picture of the product. Another worksheet would be the "selection" page where a user puts an "x" next to the model number they want in their customized catalog. The third worksheet would contain the customized catalog entries.
I have been able to get all the data info to assemble correctly on the third worksheet using the IF function (data like model #, price, availability, description etc.) but the master data also contains a picture of the product. Try as I might, I cannot find a way to get the image to move over with all the other data.
Is there a way (functions or VBA) that I can keep the image from the master worksheet with all the data when it copies over to the customized catalog page ?
View 4 Replies
ADVERTISEMENT
Nov 9, 2008
I have a spreadsheet (rows 1-15) where column A is a list of items in ascending order, and column B shows the catalog# that the item appears in. An items can appears in multiple catalogs.
I would like to develop a spreadsheet(rows 18-21) that shows the items that appears in each catalog.
The items should still be in ascending order.
The order of the catalog# row18 does not matter.
I have several hundred items and 30 catalogs....
View 12 Replies
View Related
Jul 22, 2008
Anyone who opens my sheet, has to feed his/her name which will be appeared in a particular cell.I am using the below code.
View 12 Replies
View Related
Nov 20, 2007
I have a custom toolbar created in a workbook. I have coded my workbook so that the full screen is displayed, removing the title bars, status bars etc
Application.DisplayFullScreen = True
However, there is still another menu option I am not able to remove. It is the "Add or Remove Buttons" and when you click that the "Customize..." button also is enabled.
I looked up some code on microsoft and only found code in office97 that gave me errors in 2003:
Sub DisableCustomize()
Application.CommandBars("Tools").Controls("&Customize...").Delete
CommandBars("Toolbar List").Enabled = False
End Sub
The quote from the site says "To prevent others from changing the menus and toolbars in a custom application, remove or turn off the Customize option on the Tools menu and turn off the Toolbar List shortcut menu."
I get an error saying invalid procedure when I run that.
how to disable the button or prevent users from choosing it?
View 9 Replies
View Related
Jul 6, 2012
Is it possible to edit and/or add extra symbols for the macro buttons? I mean to extended what the pallet offers Cutomsie Ribbon > Rename (As it is used to be before ribbon age with the ultra primitive built in symbol editor)
View 1 Replies
View Related
Jun 10, 2013
I have a built a catalogue of records for various of my companies assets. Each asset has its own sheet in a work book and I have used a vb macro to include an automatic Index sheet at the front of the book. This takes the names of the various tabs, in the order I have them in the workbook and creates a simple listing in column A as an Index List
What I want to do is to build a summary table to the right of the Index List, pulling in a few of the key data points about the assets into a single table.
To do that I need to be able to extract the text string from the Index List and use it to form part of a cell reference pointing to a specific cell in the relevant individual Asset sheets.
View 4 Replies
View Related
May 9, 2014
I need to write a code to create visio flow diagram with excel inputs(Excel 2007). Attached is the requirement.
Requirement_Specification.docx
View 1 Replies
View Related
Jul 9, 2014
I am creating an Excel spreadsheet. Here is what I am trying to accomplish:
I need the spreadsheet to include: name of a vendor, address, email, Form Rec'd, Form Expires, and finally, a column that will create a reminder pop up to: Send email to vendor for Form Renewal (maybe 30 days prior to the Form Expires date).
View 2 Replies
View Related
Dec 19, 2009
Currently we have an excel sheet in which it contains four sheets(sheet1,sheet2, sheet3 and sheet4). In this sheet1,sheet2,sheet3 and sheet4 there is some text data in the columns.
what we are looking is we want a comment box to appear when one moves the cell focus in a sheet (sheet3 or sheet4) to a cell in the field column. In the comment box it should display the data which is in the other sheets(sheet1,or sheet2). The items in the comment box should be data field column,fight type,Defect colour, and list in english column.
The comment should be temporary..i.e it appears when focus is on the particular cell in column field and disappers when focus is moved to another cell.
View 14 Replies
View Related
May 31, 2006
I want to the following steps to be done by vba of excel.
1. copy ranges of cells in the active worksheet (sheet3)
2. add a new workbook and paste the copied ranges to sheet1
3. save the new workbook with the new file name (e.g. date)
4. close the new workbook and clear the contents the copied ranges of cells in old workbook.
following code and make it more simpler?
Worksheets("Sheet3").Activate
If Range("l1").Value <> "" Then
Range("l1").Value = CDate(Date)
End If
asdate = Range("l1").Value 'date entered by user
resp4 = MsgBox(" Case particulars of " & asdate & " will be backed up and deleted from this sheet! Proceed? (Y/N)", vbYesNo, "Deletion of Data")
If resp4 = 7 Then
Exit Sub
View 11 Replies
View Related
Oct 23, 2012
I'm working on a time system tracking, and I want to know if it's possible to have a button for authorization (and sent by mail to me) to authorize or reject the workbook..
do this automatically in vba macros?
View 1 Replies
View Related
Oct 26, 2012
I am using MS Excel 2007.
I have column "A" a list of my PDF filenames and File path in Column "B". I want to establish hyperlinks for each of these PDF filenames (column A) and link it with the file path that I generated in Column B.
=HYPERLINK(B1,A1) did it very well, but unfortunately when converting to PDF, the hyperlink is not working, and I believe the conversion retained is only in text, so now my only resort is hardcoding it by VBA.
View 5 Replies
View Related
Apr 28, 2014
I have a very large table that I want to be able to summarize neatly and columns that have zeros for a specific person, so its easier to input data later.
View 1 Replies
View Related
Apr 9, 2014
I have this form (Invoice) on a spreadsheet and I want the footer (Taxes and Total) to appear only at the bottom of the page or of the last page, if many. I call this a "Report Footer" because no matter how many pages the invoice might have, this section will be pushed to the bottom of the last page.
I need to ask because we all know that we cannot program formulas in the actual Excel spreadsheet footer!!Facture-Logicim.xlsx
View 4 Replies
View Related
Sep 20, 2011
I am struggling with trying to create a Top 10 list in Excel 2007. I have googled and search the forum but could not find a solution. (Aplogies if i have overlooked a thread)
I have attached an example of my problem.
1. In Column F i would like to extract the names of the Top 10 performers, based on their respective score. Hence, based on the scoring in Column D, Column F should extract the Top 10 performer names from column A.
2. In Column G, same as above, but bottom 10 names
3. From the attachment, you will view some names are highlighted. I.e. Gary & Neil, and Ian & Michael. These are highlighted based on the fact that they have equal scores.
When extracting the Top / Bottom 10 list, i would like to rank the performers with same score differently. e.g. Gary & Neil, both scored 0%, hence they are equal. But in the Top 10 list, i would like to rank Gary higher as his absolute target is higher. (63 vs. 27) . Same applies to Ian & Michael, Michael should rank higher in the Bottom 10 List as his absolute target is higher.
View 5 Replies
View Related
Nov 27, 2013
make a list of all Excel Workbooks in specific folder(My Documents). And once clicked, it will open the file immediately.
View 10 Replies
View Related
Jan 24, 2014
The situation I have on my hands is over 200 users, were the majority can't use Excel's built in function to create PDF's.
Yes, I've tried to teach them, but I'm probably not a good teacher.
So, I've resorted to create a button at the top of the worksheet, that says "Create PDF". I thought this was gonna be very easy to program, but alas.
Is there a way to start the built-in Excel dialog that happens when you click "Create PDF/XPS" in "Save & Send"?
View 4 Replies
View Related
Jul 22, 2014
Attached is my excel worksheet I have created for a tracking/billing system for numerous schools. How I can create a search form?
For example, I want to find all of the kids in 5th grade that had to be referred throughout the whole document. Or I want to find a certain name to see if they have been paid but I do not know the location.
SmilesStats.xlsm
View 7 Replies
View Related
Nov 15, 2011
Code that will autofilter my sheet for rows that contain either a 1,2,3, or 4 in Column "Z". Then, create a new workbook for each unique value in column "O" and save that to a folder on my desktop named "Contracts". Next, while still filtered by by "Z" and for every unique value in column "O", filter and name a sheet in the new workbook for each unique value in column "B". Finally, while the main sheet is filtered I need to copy and paste the visible cells (minus header row) from columns C,D,E,F,G,H,S, and U to consecutive columns in the newly created worksheet beginning in cell "A9".
I am using excel to create some contracts for a few partners. Each partner could work with several of my clients and I need to give each partner a personalized contract for each of my clients with which they work.
I hope my description of the problem is not too confusing. If so, let me know and I will try to clarify exactly what I am trying to say.
I have tried to combine some code that I already have but, being a newb with loops, I can't seem to get it to do everything.
View 1 Replies
View Related
Mar 15, 2012
VBA code which will create a pdf file from excel (for a specific range in a worksheet) and then send it to a destinator via my outlook mail?
View 5 Replies
View Related
Jun 17, 2012
I have a small loan business funded by multiple investors. A spreadsheet that could calculate each investors monthly share of cash flow. Can a party familiar with Excel create this custom sheet with my input. How would your charges be determined.
View 2 Replies
View Related
Aug 8, 2012
I have a report that i want to print from excel. There is 25 pages one for each of 25 different city markets. I would like to print from Excel to PDF. I have Adobe Standard so i can go file print and change the printer to Adobe but each sheet i print it makes me type in the file name that i want to save it. I repeat the process multiple times throughout the month so i would like to create a macro or something that when i can run and every time i print page 1 it saves it in a certain folder as the name Report #1, and so on is that possible?
I have created a macro to print the reports in order but i have been having to type in the name of the file for each report.
View 1 Replies
View Related
Dec 26, 2012
how do i make a bar chart on Excel! 2010
Basically i have these figures
Male : 21
Female : 18
I want to make a bar chart, When i use Excel and try to make it - i get a chart which shows the right column height but the Male and Female bars are BOTH IN 1 Colour. How do i make it so that male bar is blue and female is pink.
View 3 Replies
View Related
Sep 19, 2013
My situation is as follows:
1. I have one sheet with all the information about my customers, such as customer name, address, mobile number and email. I have also added customer reference no...... this could act like a primary key in databases...... This is SHEET 1.
2. my other sheet, lets call it SHEET 2.... is basically a template of my quotation where at the top I need to enter the customer details such as customer name, address, mobile number and email.. Sometimes I have returning customers and I need to enter their details again and again.... it is time consuming.
Initially I would like to enter all my customers detail into SHEET 1.
When I have to create a quotation in SHEET 2, I would like to enter a customer reference number and it should bring all the data from SHEET 1 about that customer and place it into SHEET 2 (quotation template)...
View 3 Replies
View Related
Oct 17, 2008
I have 1 sheet where in sheet 2 i have two type data and that is 1 level service data and 2 level service data. In sheet 1 i wanted 2 buttons that is 1 level service button and 2 level service button. and i wanted that if i will click on 1 level service button it iwll give me the 1 level service data from sheet 2.
View 9 Replies
View Related
Sep 21, 2009
I've used some code from another thread on the forum to create an Outlook Appointment and email this as an attached .ics file from an Excel spreadsheet. Everything seems to work fine. The email is sent and the attachment when double clicked opens in Outlook with all the correct information, but when the recipient clicks 'Save and Close' it doesn't save in their calaendar....
View 9 Replies
View Related
Nov 26, 2012
I have an excel workbook that serves as a master workbook. I have to create 30 copies of this workbook, 1 for each site. Each workbook will have small differences in the data held. This is because I will refresh the sheet before saving it. There is a dropdown list on the 1st tab of the workbook that contains the names of the sites. The sequense, I suppose would be like: select the next name on the dropdown list"calculate" the spreadsheet to enable the refreshsome sort of "save-as" with the name from the dropdown list forming the name of the file. The Master file must be kept intact.select the next name from the dropdown listcalculate the sheet ........and so on I have a few other things I will add to the script like Protect Sheet etc.
View 1 Replies
View Related
May 24, 2014
I need to create some trend analysis for Vehicle sales. I have attached a file with sample data.
There are few problems i am facing like description has all the vehicle details which are not in any particular order, even if some how i manage to separate these then too many variables are not letting me come to any conclusion for example make, model, mileage, year of registration color of vehicle, auction sold, sale price, cap (bench mark for pricing).
what i need to produce is which auction sells certain vehicles best or which color of certain model sells best.
[URL]
View 1 Replies
View Related
Dec 17, 2013
I am trying to create a simple dash board using only Excel and no VBA. What I am trying to do is I want to create dependent drop downs and link up drops downs that will pull out the required data individually or with combination of those two. For example, let's say
A column has Dates of transaction,
B column has Item name
C column has Units
D column has Month name
E column has Shifts (Morning or Evening)
I am trying to make a dash board that will pull total Sum of individual items based on
Only Date wise
Datewise + shift wise
Month wise
monthwise + shift wise
I managed to create drop down list for dates, months, and shifts but i dont know the way how to link the individual drop down lists together to pull the data based on the selection. which function i should use here and how?
View 5 Replies
View Related
Nov 11, 2010
I am trying to create a wind rose in excel. IS there a process to make wind rose in excel ?
View 4 Replies
View Related
