project

I have an Excel Project (Videos.xlsm - project name: videos) which references another Workbook (Series.xlsm - project name: Series). What I would like to do, is open the workbook if its not already open. Is there a way to do it without manually referencing paths or filenames? I already have a...

Years ago I did a project that I used VBA for. We were pulling data directly into excel from an ERP. I am now working on another project where I want the data from our ERP (NetSuite) to be automatically populated in Excel and cannot remember for the life of me the code/process for connecting...

I extracted some code from my project and created an Excel Add-In with it. The project now references the Add-In and everything seems to work fine, however if I completely close down Excel and try to open the project directly, Excel crashes. If I open some other Excel file or create a Blank...

I hope I can explain this well enough. I have a table that is columns A-P and with duplicate and unique values. The Data I want to match is in column I and column P. One is a name and the other is a date that has been extracted to month and year. I have one drop down list that has names and...

I am trying to figure out how I can have a drop down list to select from and have a description of the code I am selecting. For example: <tbody> Code Description 1100 Project Management 1200 Project Coordination 1300 Administration </tbody> Drop down only shows the code but no...

Hello all, I am working with a table containing a list ofprojects, project start dates, project end dates and project costs per day. Theprojects can last any number of days and end in different months than theystart (eg Project 2). This table is shown below in range A1:D5: I want to...

The current code that I have is FUNCTIONAL (thanks in large part to help from here I apologize for forgetting your @ as you were a tremendous help). What I would like to do is speed up the code that I have for future reference as I assume I will be working on this project even more now that I...

I've been using the formula for quite some time now with much success but this one got me stumped doing this project. 50% of the columns gets extracted correctly but the other I get "#REF!". The data source is from the same table, using the same headers. Any guesses why?

I have a table I am working with that has project names that are listed multiple times (along with a bunch of other data that should not be relevant here). This is in Power Query What I want to do is a running total of how many times the project name appears then start the count over when a new...

Hi There, I'm analyzing a large amount of time entry data (30,000+ rows). I'm trying to calculate the day a project started and ended for one person...in the example below I'm trying to solve for when the project started and ended for Amy (via a function). <tbody> Project # Name of Person...

I have a task where I export data from MS Project into Excel. The date comes across as text and accompanied by "day" and "time." What is the best formula in Excel that I can apply against the exported "date" data that will strip the "day/time" off and convert the date to a true julian date...

Good morning, I am trying to populate cells on a timetable document based on selections in two cells with data validation options and date/lengh and date/duration of project Can any one help? Trying and failing with conditional formatting

Hi, Thanks for assisting with this as a bit lost. I'm trying to project a dollar amount forward in a cash flow project. Key points with an example are as follows: I have a $1000 outflow to occur every fortnight. I have tabled the start date and then every 14 days the payment is to reoccur...

Good afternoon, Thanks for having a look at this. I am trying to build a "team task tracker" like the below Column B "Employee name" Column C Macro button which when pressed as a row bellow "button row" The new row has...

Hello everyone, I have been asked by my college to submit a project on excel. Being a student of nutrition I don't have much knowledge in MS Excel, only the basics! So please help me out with this project as I don't have any clue about it & how to do it! The description of d project & the...

Hi Guyz, I am working with a Pivot. That has some 1000 project each having unique alpha numerical project codes and there budgets for the entire year. I have grouped the multiple projects under Labs. So I want to filter the project codes in the pivot which in turn effects an Chart. I tried...

Good Afternoon, Please note I'm very new to Excel..! I have to create a master spread sheet that records the pallet number, the project names that are on each pallet and the serial numbers of the items that belong to each project. I'm using column A to record pallet numbers. Pallet 1,2,3 etc...

This one is really strange. In one of my VBA routines I made the newbie error of an infinite loop. The only way I could stop it was to close the spreadsheet. When I opened it again, my original project showed up twice in the project tree. One of the duplicate projects works, but if I try to...

Newbie question: In a project with a number of subroutines and functions that query and update a database, is there an advantage (or disadvantage) to having just one global database connection that is opened upon initialization of the project and stays open until the project is closed?

In a excel workbook I had written a long VBA project consisting of many forms (with their code) and various modules of sub codes. All this matter was stored in PERSONAL.XLB file and a command was set in the ribbon for rapid process activation. I made many copies with different names and...