Need to move data from 14 sheets (1 pay period=14 days)(2 showing on attachment for example purposes) to time cards for each person (number of employees will vary).
Key data to move to the time card is the date of the hours, #Reg Hours, #OT hours, the ticket# and job# for those hours.(ie Chris Adams Aug 15, need Chris's Reg and OT hours (8 Reg and 2 OT) on his time sheet, and the corresponding ticket number and job number (in this case from I1, I2).
Unknown number of ticket/job numbers, but the pattern of cell entries will remain the same along the top of the date sheets.(starting at I1, then L1, O1, the next would be R1)
Unknown number of employees but they will continue filling down where the names are on the date sheets (column A). Each employee would have a time card sheet as well.
I have a workbook with the following sheets i do not want to hide called "Detailed Template", "INTERFACES", "STATUS".
I then have a number of worksheets which have their names as cell addresses i.e. "E4", "E5", "D4", "F4", "G7" and so on.
I would like to hide all worksheets (except the 3 mentioned at the top [which are sheets 1-3]) and any which contain say the value of '4'. This value is defined by a cell in the "INTERFACES" worksheet say 'A1' for example.
I want the macro to be able to automatically do this for which ever value is in 'A1'. So if it were to change to '7' it would hide every sheet that doesn't contain '7' in the name.
I am new to the post so far I love it. I am in need of a formula to help with an order book that I created in excel. In first sheet in colum A is the item number, in B is the Description, in C is the count, in D is the selling unit PK or Ea, and in E is the class code. I have sheets for every class code. I need to be able to pull information form the sheet one that matches the class code in colum E and only the items and info for a certain class code and post it to another sheet that has all the headings and formatting that I need. I need all the rows that have the same class code to be pulled excatly the way it is in sheet one. I thought I might be able to do this with vlookup or dget but can't seem to figure it out.
Firstly a confession - I've sinned - I got the code below while searchin the forum and in my excitement, I forgot to get the thread details - so I'm sorry!! So the credit for the code to a forum admin:
I want to make a spreadsheet that has codes that make items show up on another sheet but how to do this.
For example I would start on sheet 1 and on cell A2 I would type the amount $100. Then in cell B2 I would type in F (I will call this a code).
Now on sheet two I want the amount on cell A2 to show up in a column of items designated for F items. If I had typed in G instead I would have wanted it to go to a column for G items. All the values under the given code will show up in the column that is represented by them.
I have 1 source file that shows all the changes we made to the following 14 spreadsheets; essentially a change log.
I have 14 excel spreadsheet...the last tab in each of them have an object (the source file) captured, so they are all identical
Lets say the 14 spreadsheets are Makes of cars...(1 for Dodge, 1 for Ford, etc)...each time we make a change to the car, I log that change in the source file.
Lets say I have 33 things for dodge, 17 for Ford, 39 for Lexus, etc...all in the change log. Is there any possible way for the final tab of each of those docs, to ONLY show the changes that are specifc to that model?
My actual scenario is different, but this is the same concept and much easier to explain. If this is possible, I'd like to go a step further to know it is can be linked to the source file so it updates upon opening just like the object does now.
For what its worth, you can key off of column A in the source file....that is essentially my "Model" column.
I am using MS Excel 2007 and I am having to prepare a database that takes data from other sheets and places them on sheet one with a specific sequence. I'll explain, my data is in the following
form: Sheet2 A1 to A1617 (each a different value) Sheet3 A1 to A1617 (each a different value) Sheet4 A1 to A1617 (each a different value) .... .... .... .... ... ... Sheet13 A1 to A1617 (each a different value)
The result I require is so that on sheet 1 I have a database showing me this
Is there a way I could get this done automatically? I know the basics of Excel and this has been a dilemma lately. I have several databases to work in this fashion and I do believe that there must be a way to solve this in excel so that it fills automatically.
I have two workbooks open, the first is a summary, the second has new data that needs transferring into the summary. Before transferring the data I need to check that 10 specific sheets exist in the file with the new data.
I have found some code that checks for one sheet name, but really need to check for 10 specific names, if any are missing then I need a message to appear, listing the missing ones and stopping the macro from proceeding,
Dim mySheetName As String, mySheetNameTest As String ActiveWindow.ActivateNext mySheetName = "Data" On Error Resume Next mySheetNameTest = Worksheets(mySheetName).Name If Err.Number = 0 Then
I am trying to create a macro that will copy data from one sheet to four other sheets depending on some requirments in the data. I have a main worksheet that will store the data, the name on this sheet will change daily, so you cannot use a "named" sheet in your macro. The other three names of the sheets are "Esky", "Indy", "Gfld", and "Other". When copying the data, I need to copy the entire row of data to the required sheet. The data comes in such as:
Based on the FIRST TWO characters in the first column, I need to copy the data to the specific sheet. I would assume a simple LEFT() function would work for this. Here are the requirments for each sheet:
Esky - "MZ" or "51" Indy - "IZ" or "Z" or "21" Gfld - "PZ" or "22" Other - Anything else
There's one sheet that has a list of customers (this is updated very frequently). These customers are either ‘New’ or ‘Existing (as listed in a corresponding column) - would it be possible to have a macro that, when run, will place a copy of existing customers into a second worksheet (“view list – new”), and a copy of new customers into a third worksheet (“view list – existing”), with the main worksheet still listing both existing and new customers.
As the main sheet that lists all customers is updated very frequently (with customers being added and removed throughout the day), would it be possible to clear all contents of the other two sheets that each list of 'existing' and 'new' customers will be copied into, before the two lists are copied into each of the two sheets (just to ensure there isn’t any data in there from the previous time each list was copied in).
I’ve given this a go via the ‘record macro’ function - some users of this WB use excel 2000, and others use excel 2007, but it only seems to work on excel 2007 (which is what it was recorded on)…
I would like to use VBA to search a folder and copy data from tabs within the excel files there. The data will be pasted to a tab of same name in the the main file. All the files are in the same format.
So far I have only managed to list the files in the folder using code I found on your site!
I have a workbook that updates from external source and creates sheets depending on a cell range.
I have put tab 1 and tab 0 on either end of where the new sheets will be inputted, will never know how many sheets
What i need to happen is if someone fills in "complete" in A7 in my "summary" sheet then the values in row 6 in all the other sheets get hardcoded. This needs to happen from A7 down to A26, so A8 = complete then copy row 7 etc This is what i have so far
I get compile error here ........Sheets(ArrSh(1)).Activate
Also need it to work for all the other rows.
Sub hardcode() ' 'Sheets("Summary"). Select If Range("a7") = "complete" Then ' Sheets(Array("1", "0")).Select Sheets(ArrSh(1)).Activate
I'm trying to find a way to use a macro to extract data from a specific column from Sheet1 based on the columns header/title and copied into Sheet2 into the respective column with matching header/title.
For instance, in Sheet1:
Chicken Cow Donkey Pig
So the above table would be the result i'm aiming for.
NOTE, its not different workbooks. I'm looking for sheet to sheet macro.
I've attached a file as well if someone wants to have a go at it. There are no codes in it.
What im trying to do is have a macro that will open a file called Blue 1.xls in location "I:SchedulesBlue" and then copy data from cells N13:034. Then paste it into another excel file (Press.xls)on worksheet "Press Break" cell G14.
The data that is copied not always fills up the cells N13:O34 so I need it to go to the next blank cell in column N and paste the information from file Blue 2, and so on for Yellow 1, Yellow 2, YellNR, and Green.
So to summarise I need a macro to open 6 files copy data from the same location on each of the files(N13:O34) then close and paste it into a master document(Press.xls) worksheet "Press Break".
on sheet1 I have a button I need to do the following when clicked: (1) name the next 30 sheets based on cell values in sheet1 (2) for those 30 sheets, hide some of them based on a y/n input in sheet 1
To clarify: the worksheets do not need to be created, they already exist. They just need to be renamed and hidden based on that y/n criteria. see attachment with just 1 worksheet for clarification. So - The next 30 sheets are to be named by the following ranges (B7:B16), (B21:B30) and (B35:B44). For every product with a "n" in column C of sheet1, the worksheet for that product needs to be hidden.
I'm trying to search for a string and move the entire data to another sheet. For example,
Loading... 1 2 3 4 5 6 7
Loading... 3 4 5 6 4 3
Loading... 6 7 8 9 5
What I'm trying to do is to search for the string "Loading..." and move the entire data from "Loading..." onward to another sheet. So the first; "Loading..." 1234567 will be in sheet 1, second; "Loading..." 345643 will be in sheet 2 and third; 'Loading..." 67895 will be in sheet 3.
I press Shift and click on the selected sheet tabs, goto Edit> Move or Copy Sheets... the dialog box allows move or copy to a new workbook or to an open workbook. Macro doesn't record syntax for the Dialog box. This build-in function also doesnt allow me to selectively choose the worksheets in the active workbook.
I am looking for this code or a sample dialog box as I need to incorporate it as a part of my task automation macro. I would like a dialog box that allows eg. listbox to choose the individual sheets, then with option to Copy only (collectively Copy or Move are also fine) the selected sheets to a new Workbook or an already open Workbook. I am using Excel 2003.
I am having rows of data, that i will be updating from time to time. I want excel to move the latest updated rows, in any column if updated, to move to the top, to easiy know that i updated those records. It should be that when i updated more rows than one, then the first updated cell would be in lower, in order, than the latest updated cells. I do not want any cumbersome vba. I want in formula or in conditional formatting. The row no may be total not limited to some rows.
Because, you naturally would have updated the 200 th record and would have saved. It saved as it is, so when you next opens it it is there, but how can i know that that is the last row of data i edited.