Copying Dates Into New Spreadsheet Does Not Seem To Work?
Jun 10, 2014When I copy the dates from this spreadsheet into a new one, in the new spreadsheet the copied dates are different. Looks crazy. Why does this happen?
View 14 Replies
ADVERTISEMENT
Work Out A Formula For My Spreadsheet Which I Use To Work Out Cutting Lists For Timber Frames
Jan 11, 2009i need to work out a formula for my spreadsheet which I use to work out cutting lists for timber frames. I need it to work out if the width of a job is for eg 2400mm i need to work out how many timber studs I need so the space between each stud is between 400mm and 500mm and this will need to work for a range of different sizes of frames. I have it written at the moment and it just devides the width by 400 and gives me a amount of studs but it would work much better if it could space them between 400 & 500.
View 4 Replies View RelatedCopying A Certain Range In A Work Sheet To Another Existing Work Sheet Using VBA
Dec 29, 2009I have a range of cells in a work sheet "sheet 1 " my objective is to filter this range according to certain criteria (i ve succeeded to do this ) yet what i want to do now is copy this data to another existing worksheet in a certain range .
note :the existing worksheet to which i 'll copy the filtered data has some cells out of the range that i dont want to over write ..
Simply :how to copy a selected range of cells in a work sheet to already existing work sheet in a specific range aswell .
Spreadsheet Uses At Work
Aug 4, 2007The spreadsheet has been around for a long time. Even in the electronic form, it has been around for over a quarter century. How has the electronic spreadsheet improved or changed your job?
I'm taking a course in computer applications and will be using any information I get in replies to this thread in my term paper.
Auto Copying Text (Not Data) From Cell In One Spreadsheet To Another Spreadsheet Cell?
Nov 4, 2012I wish to Automatically copy the TEXT that is written from Spreadsheet 1 cells D5 to F5 to Spreadsheet 2 cells F5 to J5 .... a similar range of cells.
Is there a formula I can use or do I need to venture into the programming side of things.
Sorting And Copying Results Into New Work Sheets
Jun 3, 2009I have a work sheet with about 35,000 lines of data. Every day I have to sort the list by product category (I use auto filter to separate) and then copy the results into a new worksheet, there are about 300 product catagories. I'm new to macros but I'm wondering if there is a macro that can automate this process.
View 6 Replies View RelatedCannot Work Out The Debug With Copying Static Date
Nov 20, 2009I'm trying to create vehicle maintenance inspection program for a mechanic at work. The trouble is the he's not fond of computer and I'm trying to make it as simple as possible. There's a debug in the line
View 2 Replies View RelatedCopying Work Sheet Into Multiple Times
Nov 2, 2008I have one Excell Book with two work sheets. The 1st sheet (Sheet Name : Data ) contains the data... and in the 2nd sheet (Sheet Name : Rekey) i have a specific form in Rekey sheet and some data in Data sheet. Now i have to copy Rekey sheet into multiple times .... with different sheet names... and the sheet name are in Data sheet from cell A2 to end.....
For e.g. in Data Sheet cell A2 contins work1 and cell A3 contains work2 and A4 contains work3..... and so on....
Rekey sheet contains some form....
I need to paste Rekey sheet multiple times with sheet name work1, work2, work3..... and so on....
Work In Spreadsheet While Userform Is Open
Mar 20, 2008Problem: I have textbox entries that are part of a Userform that opens using a macro on a speadsheet button. Once this form is open, I can no longer actively work in the spreadsheets.
Need: I need a way to minimize or "put on hold" the Userform so that I can freely move around in the spreadsheet. This could be in the form of a button on the Userform. Then, I need a way to bring back this userform to the point I was at before being put on hold so that I can continue to input entries into the textboxes (again, a buttton that could bring it back). There should be a way to toggle between both worlds.
Macro Does Not Work From Any Selected Cell On Spreadsheet?
May 21, 2014I created a very simple macro, which actually works.
There is a button on my spreadsheet, so the user can launch the macro using this button.
[ Code] .......
At the moment the user clicks on the button, the part of the macro which is hiding the rows will not take place if the cell activated at the moment of launching the macro is in the range below :
The table on my Excel sheet covers range A5:E49
If the active cell is anywhere in A6:49 or C5:D24 or C25, the hiding part of the macro will not work. Launched from any other cells on the spreadsheet it works fine.
The rest works fine and I am not getting an error.
To solve this I just need to add the line Range("G9").Select and it will work.
But I would like to understand why it does not work from the cells given above. My sheet is not protected and I unlocked the cells just ion case.
Formula- To Develop A Code To Include Into A Spreadsheet For Work
Jan 20, 2009I am having trouble trying to develop a code to include into a spreadsheet for work. It will be a live spreadsheet accessed by a few people who will have control over there own columns in the spreadsheet (2 columns are designated for one project) Each Project director is to edit the info about their project.
So my goal is to put a code in cell C3 that shows the date that cells C4-32 and D4-32 were last updated.
Excel Spreadsheet - Tally Number Of Votes For Particular Artist Work
Mar 14, 2014We want to create an excel spreadsheet that will tally the number of votes for a particular artist's work. There will be about 150 artist's works that will all be assigned an individual number from 1 to 150 on an excel sheet.
We will have about an hour to complete the counts to determine winners, so a short time frame.
Is there a way of creating a formula/macro in one cell -to just enter the number of the artist's work that was voted for- and have it placed as a tally against the individual piece?
Create A Spreadsheet That Will Automatically Increase The Work Order Number By 1?
Jun 20, 2014I am trying to create a spreadsheet that will automatically increase the work order number by 1. The cell will always be in the same place. The idea is that when the file is opened it populates the number. After being closed and reopened the number will be 1 higher than the previous.
The page will reused by various people to create and print work requests for my mechanics, I want it to assign the W/O automatically.
Work Schedule: Insert The Numbers 1-6 Into The Spreadsheet Throughout The 14 Days For Each Employee
Oct 7, 2009I developed a 14-day work schedule and I assigned each different job position a number. The different job positions are numbered 1-6 and are as follows: #1=5:30am-1:30pm, #2=6:00am-2:00pm, #3=9:30am-1:30pm, #4=12:00pm-8:00pm, #5=1:00pm-8:00pm & #6=6:00pm-8:00pm. Numbers 1,2,4,5 clock-out for a 30 minute lunch break, while the other numbers do not.
My goal is to insert the numbers 1-6 into the spreadsheet throughout the 14 days for each employee, and have Excel calculate the total number of hours for each employee in the far right column. I would also like "V" & "H" to equal 7.5 hours. This would save a lot of time instead of going through and adding up the hours with a calculator
Count Formula- Spreadsheet That Is Being Used For Tracking Work Completed Each Day In A Week
Apr 9, 2009I have a spreadsheet that is being used for tracking work completed each day in a week. Each day has 5 columns and 10 rows of data to potentially be entered, some of the data is text and some is numerical. Can anyone help me come up with a formula that will count the text and the numerical entries for each day? I tried to use a nested if statement but it exceeded the number of nestings available. The range of cells for the first group is B6:F16.
As a side question, will count work for a range of data or only one column or row at a time?
Calculate Work Days Between 2 Dates
Sep 14, 2006i have a few fields with dates in my excel sheet. I also have a field, where i want to automatically insert the business day between two other date-fields! Business date means days without the weekend and public holiday! Is it possible to do that? how?
Determine Work Days Between 2 Dates
Mar 13, 2008My workday function doesnt seem to be working correctly, it is including weekends.
My Spreadsheet is like this
A1= 01/01/2008 ( Date)
A2= 30
A3= =WORKDAY(A1+A2,0)
I am expecting the result to be 11/02/2008, but i am getting 31/01/2008.
Copying From One Spreadsheet To Another When Both Are Opened?
Nov 15, 2013How do I get one sheet to update from the other when I open both sheets. Somethign like an auto update. If I had two tabs on the same spreadsheet I would just use = but I can't use that with two different sheets.
View 3 Replies View RelatedCopying Data From One Spreadsheet To Another?
Oct 21, 2011Okay, I have data for 400 employees in one spreadsheet. I am trying to move 4 fields of data to a second spreadsheet. But I have 11 rows for each employee in the 2nd spreadsheet.
How do I copy my formula so that it is the same for the first 11 rows and then moves down a row for the 12 row?
ie)
=A1
=A1
=A1
=A1
=A1
=A1
=A1
=A1
=A1
=A2
etc
Copying Data From Another Spreadsheet
Mar 2, 2007From a destination spreadsheet, I need to be able to programmatically prompt the user for the name of a source spreadsheet (e.g., using GetOpenFilename), open the selected file, copy predefined data (i.e., identified with a named range), return to the destination spreadsheet and paste the data in a predefined location.
Does anyone have any code samples to accomplish this task? If so, can it be run with ScreenUpdating set to false so that the user does not see all of the moving around the two spreadsheets.
How To Get A Chart To Work With Irregular Dates Correctly
Jan 3, 2014I've tried for some time now to create a chart where the x-axis make up for irregular dates. Making the line between 2 points longer if it's long time between them and short if it's short time between them.
I've finally understood line charts doesn't support that and I have to use scatter graph. It seems to work but the dates, the get all messed up. I type 2014-11-11 but the x-axis in the graph shows 2283-12-12 or something like that.
Got a notion that I might have to transform it to the date value manually first but I get #VALUE ERROR
i.e. 2014-11-11 in A1, then I type in A2 =DATEVALUE(A1).
How do I get a chart to work with irregular dates correctly?
Payroll Extract To Work Only On Certain Pay Period Dates.
Feb 9, 2007I currently have an Excel payroll extract that populates a start date and end date via the calender control 11 user form.
What I have found out is I need to inject some sanity to this application. I can not have users select days that are outside of a pay period.
The users should only be able to select the first or the 16th of the month for a pay period start. Then they can only select the 15th or the 28th/31st for the pay period end.
What I am trying to do is have them select the month and the pay period start date, then the end date would automaticly be selected. But I don't want to have to create a bunch of loops to counter for the differing month end dates or leap years.
Work Days And Hours Between Two Dates & Times
Apr 7, 2008I am creating a 'HelpDesk Issue Logger' and I am trying to calculate the Network Days and Network Hours between two dates with times. I want to know how many business days and hours are between the two days to give me a TURE 'Response Time.'
I have been to several sites and forums looking for the answer, but I have not been able to find a solutions that works for me. Please find attached a 'stripped' down version of my project.
Variables:
- 'Date Received' (H11)
- 'Date Actioned.' (I11)
-'Response Time' (K11)
Constants:
Work Days = Monday to Friday
Work Hrs = 8:30 AM to 5:30 PM (no lunch break)
Public Holidays = (AC13:AC30)
Formats:
Date Received: dd/mm/yyyy hh:mm AM/PM
Date Actioned: dd/mm/yyyy hh:mm AM/PM
Response Time: d - hh:mm
If there is someone out there wiling to put me out of my missery with this one, you will have a friend for life.
Updating Spreadsheet Without Copying Values
Aug 4, 2014I am trying to copy a set of data (lets say workbook 1) into a new workbook(workbook 2). Both files are saved in the same directory.
Workbook 1 will be continually updated with new row additions and some changes in text in the rows. I want to copy these new changes (from workbook 1) without having to copy and paste the new additions into workbook 2, as it is wasting a lot of my time.
Is there a trick in excel to automatically do this?
Copying Unique Entries To New Spreadsheet
Dec 8, 2008I'm trying to write a macro to use as an auto-update feature for a spreadsheet.
I currently use Data validation on an input cell to allow the user to select from a list of product types.
I'd like the update to affect this list, so new product types are always available to the user.
However, the list of product types is in another spreadsheet and contains numerous repetitions.
I've managed to get the following code together based on what I've used before and what I've found searching so far, but it seems to have a bug in it as it wont always work. I also need the original copying of the list to be done to either the new spreadsheet of a different page in the original spreadsheet, but every time I try this it causes an object error.
PHP
Sub Macro3()
'
' Macro3 Macro
' Macro recorded 05/12/2008 by Information Technology
'
Workbooks.Open Filename:= _
"T:SSTCCDEngineeringBackthin_dataPhotolithMASK_DETAILS.xls"
Sheets("Mask List").Range("f4:f2000").AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Range("a1:a3"), CopyToRange:=Range("E1:E2000"), Unique:= _
True
Selection.Sort Key1:=Range("E1:e2000"), Order1:=xlAscending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
Columns("E:E").Select
Selection.Copy
Windows("MASK_DETAILS.xls").Activate
ActiveWindow.Close
Windows("Dry_etcher_log_B.xls").Activate
Sheets("Calc Sheet").Select
Columns("M:M").Select
ActiveSheet.Paste
End Sub
Copying Formula Referencing Another Spreadsheet?
Feb 23, 2012Im using the below formula to paste information into a new spreadsheet based on the if then statement. However, as i paste the formula down the sheet, it doesnt reference all the cells. The formula stays on the cells it referenced initially. How can I make the formula reference all the cells as i drag it down?
=IF('[All Cases ATL.xlsx]New_All_Case'!$C$2="DA1",IF('[All Cases ATL.xlsx]New_All_Case'!$T$2="A",'[All Cases ATL.xlsx]New_All_Case'!$E$2,""),"")
Copying Data From UserForm To SpreadSheet And Back Again?
Feb 21, 2013We created a database for our employees who have security items and other things we need to keep track. We created a spreadsheet where data was entered on Sheet2 (Entry Form) and then by clicking various buttons would be thrown over to Sheet1 (MasterList) and put in alphabetical order. Then last week he said lets change it to a User form where i can put all the data, be able to tab through my text boxes and make the whole process of entering information faster and more efficient.. but now hes gone and I'm left with his macros and all this stuff i don't really understand! I have been doing pretty well on my own but im stuck "Search Employee" Here is what i have...
VB:
Private Sub SearchEmployeeButton_Click()
LastName.Value = Range("A500").Value
FirstName.Value = Range("B500").Value
[Code]....
use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window.
Copying Data From Website And Entering Onto Spreadsheet
May 30, 2014Working in Windows 8 excel. I am copying data from a website and entering that data onto a spread sheet. There are certain websites where the data does not transfer on the first try. It sometimes takes up to trying 3 times before the data will download onto the spread sheet. Why is that? And is there anything I can do to get it to transfer on the first try?
View 1 Replies View RelatedCopying Filtered Data Columns To New Spreadsheet
Oct 14, 2008I have a spreadsheet with two tabs (Customer Survey Data) and (Customer Rollup). The data starts on line 5 (headers in rows 1 thru 4) and is found in columns B thru J. In column B I have dates with no blanks. In column C I have customer names - no blanks. In column J is are the customer comments - not all customers made a comment so there are blanks.
I created a macro that autofilters the data to show only those entries within a specific date range (dictated by dates found in L1 and L2 - begin and end dates respectively) by column B (no problem with this). The macro also auto removes all rows where there are no comments (column J = no blanks). This leaves me with only those surveys recieved within a specied date range that have comments.
Here is my problem: the Customer Rollup sheet is the finalized report. I need to copy only the customer names and their comments into the finalized report. The following is the macro I put in which only half works and I have no idea why. It copies the names fine...but then only copies the first comment.
Oh yea...I don't want to copy the WHOLE column...only from the first visible row down to the last. Btw...I put a lot of notes for myself...I capitalized the notes where I think the problem is...Any suggestions on how to fix it or why it just doesnt seem to work like it should?
Copying Data From Spreadsheet To List Box In A UserForm
Nov 25, 2008I must say I have learned quite a lot from this forum. So, a vey big Thank You to the folks who are managing this forum and those who are contributing possible solutions. I have a question about copying data from a spreadsheet to a List Box in a User Form (Pls see attached). First, I select the Account from the drop-down cell in the Main sheet. Then I click on the CommandButton and a UserForm will pop out with a List Box that draws relevant data from the Remarks sheet according to the Account that I have selected. The data in the List Box must be in this format : "Date1 : Remark1"; next line "Date2 : Remark2; line 3 "Date3 : Remark3"........until the last available entry.
View 2 Replies View Related