started

I would like to combine 12 separate workbooks into a single Workbook but have the data from each in a separate Worksheet. Any suggestions on how to get started?

Hello all, I know there are a ton of threads on calculating time and I read a bunch and tried a bunch, but not finding anything that works for what I'm looking for (or at least that I can figure out). :) I'm trying to keep track of time a machine runs. See example below End goal is to have a...

Hey All My version of Excel 2010 has started automatically putting a single apostrophe at the start of every cell I type in except numbers and I can't work out how to stop it :-/ I've only noticed because it's started effecting code in one of my books where a cell gets a value tested and it...

Hey guys, first post here. I need a little help. Basically I have two sheets, Sheet 1 contains the dimensions of parts I have at my warehouse, and the Box Types sheet contains the dimensions of boxes we have available. I think you can see where I am going with this. I'm trying to reference Box...

Hey Everyone, I'm trying to create a graph that tracks performance by tenure week. For example, there's a group of people who started work on, say, 4/1/2018, we'll call them Wave 1. Wave 2 started on 4/31/2018 and Wave 3 started on 5/5/2018. I want to be able to track a specific metric by...

I have a really, really simple vlookup formula that has been working, but for some reason has stopped. The function is to take data validation using "Pass", "Started", "None" and assigning a value to them of Pass = 20 Started = 10 None = 0 The formula is =VLOOKUP(F35,Data!L27:M29,2)...

Hi everyone, I have a very simple spreadsheet that looks like this: <tbody> Date Started Time Started Date Finished Time Finished Hours 23/04/18 06:00 25/04/18 06:00 48 24/04/18 07:00 25/05/18 09:00 746 25/04/18 08:00 -1037168 </tbody> The hours cell contains a formula that...

Good morning is it possible to calculate the time difference between two cells below even though it has time and date? Started Date & Time Completed Date & Time 18/12/2017 16:05 18/12/2017 16:16 Thanks

Hello Experts I am new to vba and very keen in understanding it better. I have written below code around countifs Issue 1 - When i debug, i do not get any error, instead i get output as '0' even though my input file looks as below. However if i copy paste the keyword 'Walkthrough' in the code...

Hello all How can I open a PDF file please from an Access database using a button The path would be [C:\Tmp\PDF\ & then the value in the form field called "Invoice" the value would be [12345] Still trying to get my head around Access as I only started to use it last week Any help would be...

The rooms are bookable in 30 mins need an excel system where details can be put in on one tab and on the other tab if blocks out the booked room I've got a spreadsheet started but don't know where else to go regards to formula etc any help will be greatly received. Thank you in advance.

I have a sheet with dates listed in columns B:12 to C:15 in a table. Column "B" is "Start" and column "C" is "End". Column A:12 to A:15 has a drop down list with choices of "Not Started", "Started", "Completed", and "Cancelled". The sheet calculates how many dates remain for the day, week...

I think I've seen what I'm looking for but cannot find it again! I have this huge Crosstab query that shows columns for each month from Year minus 1 through Year plus 2; i.e. 01/01/2017 thru 12/1/2020. I want to gather all the field names into a new query that writes to a new table. I...

Hello everyone, Been working on an automated bidding spreadsheet to put on a tablet for quoting projects... since 2012 haha. You guys have been indispensable and I just started working back on it again for the first time in a year so use your kids gloves with me please. I've forgotten...

I have worked for a few months on a project to create a database to handle staff and equipment for my work. It was my first ever thing i built in Access and so far i really like it. Before i worked only in excel so when i started with Access i realised how much more i could do now and with...

my excel sheet contains a lot of tasks (rows), in one column the status is maintained like (dropdowlist): "", Open, Started, Closed etc... One activity consists of a lot of these tasks, so i want to determine the lowest status of the task and assign that to the task. For example task 1 Open...

Hi Everyone, I've been trying to do a simple find and replace down Column AQ but i'm running into problems because sometime the words i'm trying to replace are pearing again. in the same cell So wjay I what to do is find "What Time Started" and replace with "Begin Time". the problem is the...

HI Guys I have an excel table where I enter sales after the sale has completed I have a macro that sets the line and moves me down to the next line. This new line holds all the calculations from when the table started. But I had an error with a live feed which is now sorted but this has created...

the table contains a string that is too long for excel to display. if you edit the long value some data might be lost Does anyone know what this is? I dont know what happened, I have been building a spreadsheet for a few weeks now and everything was running smooth. Randomly during this versions...