Search results

I am trying to create a visualization of a warehouse showing areas of high volume that I want to color code, Red for high volume through blue for low volume, but I want to represent this in a 3d format so I can see a each location in its respective rack in its respective row with about 10 bin...

I am trying to scatter plot measurements of angles, I have 360 degrees listed on the columns and I have 243,000 measurements, each measurement is placed depending on the degree it falls, however, because of this amount of data, I can't graph more tan 255 columns or rows. does anyone know how I...

I have a hyperlink in my worksheet. the hyperlink goes to a website, when it goes to the website I can search for an address. I have the address 5 columns to the left of this hyperlink, I want to be able to allow the person to select the hyperlink but have vba copy the address, so when they go...

I am using a scanner to scan barcodes on a list (items I am trying to find). I created a worksheet function using case select when case = $F$2, so when the user scans the barcode when the cell F1 is selected, it will execute. every barcode I see I scan and gotes through each one, one after the...

I want to be able to put in a list of addresses, they show up as an interactive icon in a map of the USA. then I want to be able to see the icon change based on some KPIs and then click on the icon to get more information. Is this possible with VBA and perhaps google maps. I need the map to be...

I am trying to write some vba to go to this page and click the export to excel icon. does anyone know how to do that. here is the web page...

I have this code here that works when i go through the debugger and then when i run the macro it doesn't work. I have removed some titles for sensitive reasons, but the structure is intact. Sub Disseminate() Dim RefName As String Dim RefDate As String Dim Names As Integer Dim I As Integer Dim...

which is better, keeping raw data in its original format or making it into a table and why? I use these tables for crossreferencing to reports and metrics. Size of the file is also an issue.

I am trying to get the userform textbox to automatically change when the user selects a different cell on the worksheet(like an event change), and the value of the selection now becomes the value used in the code as well as being displayed in the textbox.

I have a list of Customers in column B. In column I i have an alternate name. the alternate name once given is always the same. The customer's name can appear multiple times becuase of different dates they visit, but the alternate name might appear on the 6th visit and that is all. what formula...

I am trying to convert daily hour charging into months(sometimes data goes over into different years, like December then to January) how can i have excel automatically know if there are hours charged in a certain range to automatically include all months and appropriate years? i have used the...

If memory serves correctly i believe there was a tutorial on how to create graphs and make them selectable. for example. i have a bar graph that gives me total sales. i can then click on that bar and get detailed info about what info goes to that bar. any suggestions? Thanks

I have a complex spreadsheet. i want to create back up files but without any formulas. I have special formatting and charts. how can i go about this? I have tried doing a vba savacopyas. it works however, i still have all the formulas. i then tried to reopen it and then go through the...

I have written a code to open a workbook on a network and calculate a QTY through sumifs formula with 2 criteria. I have 6000 parts and 10 products i am comparing the network file against. the network file is about 70,000 lines. i have tried looping the formula several ways. one line item and...

I want some generic code to copy a field in project and paste it into excel. I need the generic syntax and i can change to what i need. i am just lost on the initial code. Thank you, Greg

I am trying to create metrics from my project file, but i am having trouble linking to my project file for automatic updates. can someone help please. I have done a copy and paste link text but only certain columns are pasted and not everything i copied. Thanks

I am trying to count inventory. i have the product in columns F,G,H and so on. I have the parts that make the product in column B. in addition, i use multiple parts in different assemblies to make this part. meaning, i could use a part 2 or 3 times (like screws). I need to create an inventory...

how do i name shapes based on cell values? then add a connetor line to a different shape?

I heard if I use ByVal in my procedure, for example Sub Test(byVal X as long) code' end sub that my code will be executed faster. especially if I have a lot of code to go through. Is this true, if so, how can i use it on a userform button? thanks

I have a file that has a list of items. These items have a schedule. the schedule is conditionally formatted to look like a Gantt chart. This file then gets marked with a border style of when work was started and finished. If the work started a macro will put a diagonal border through the cell...

i am working on a spreadsheet that is part number based. each part number gets a work order assigned. I use Vlookup or Index/match to find the work order associated. however, sometimes they need to make a new work order and no longer use the first work order, but they need both in view and they...

i am trying to compare 2 lists that should be exact. however if they are not exact, i want excel to provide a list of the mismatches. how can i do that?

I am trying to set a conditional format based on a range that contains today's date. any one know the syntax of format conditions?

I have a file that has a lot of conditional formatting based on dates like a gantt chart. when status gets updated the logic has to be redone and i have to re-organize my tasks to match the new logic, however, all the indicators are visually seen on the gantt. I need those exact indications to...

I have a MS project file that I want to link to in excel. So if I update the dates on MS project they will update in excel. I have gone through the select the dates, paste special link, and text. I have also done the same on paste special link for excel format but after i close the files and...