Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Bilberry

    Create a pivot look a like without calculation, only showing some values

    I have change the code, and it looks like that i want to have such an export: Sub Macro1() Dim c As Integer c = 2 Do While Worksheets(1).Range("A" & c).Value <> "" Worksheets(2).Cells(c, 1).Value = Worksheets(1).Range("B" & c).Value Worksheets(2).Cells(1, c).Value =...
  2. Bilberry

    Create a pivot look a like without calculation, only showing some values

    @Andrzejek: Thanks for that. I could not see the machines (column B) on the first row. It should look like: A B C D E F 16-05-2014 15:47 16-05-2014 15:47 16-05-2014 15:47 16-05-2014 15:47 16-05-2014...
  3. Bilberry

    Create a pivot look a like without calculation, only showing some values

    Skip sorry for the inconvenience. Did you have a look how to handle this?
  4. Bilberry

    Create a pivot look a like without calculation, only showing some values

    Hi, It is indeed to schedule for assigning some job to a machine resource, all the other activities and enddates are done with another tool. This is only to show the data in Excel @Andrzejek, Ok tx, i have tried to fix the errors. The date time (column A and B) is only one column, so Only...
  5. Bilberry

    Create a pivot look a like without calculation, only showing some values

    Hi Skip, Thats demo data, in practice there will only be distinct dates in there
  6. Bilberry

    Create a pivot look a like without calculation, only showing some values

    Ok Skip, can we try without the time part? So only the dates...
  7. Bilberry

    Create a pivot look a like without calculation, only showing some values

    Hi Skip, Its a bit difficult to draw the results here in this post. I hope that i can describe that: The headers are: Column A: DateTime Column B: Machine Column C: Employee Column D: Status I want to put Column A as Column and want to have Column B as the row. The values should be Column C...
  8. Bilberry

    Create a pivot look a like without calculation, only showing some values

    Hi All, I want to create a macro to create a pivot-like table. I dont want to do calculation, but only want to show the values. Here is the content of the Excel file: Column A Column B Column C Column D 16-05-2014 15:47 Machine1 Peter Not started 16-05-2014 15:47...
  9. Bilberry

    sum total hours between datetime stamp

    It is possible to work in the morning for 3 hours and in the evening for 4 hours (Same day). How can i the hours worked (with start/stop)
  10. Bilberry

    sum total hours between datetime stamp

    Hi All, I have a table with the following content: Datetime | StartStop | 21-03-2014 17:40 | Stop 21-03-2014 12:40 | Start I want to sum the hours a day. How can i realisze that. I want to have: Date - Hours worked 21-02-2014 - 5
  11. Bilberry

    Group and split into seperate excel workbooks

    Hi Skip, Im still getting the same error on the same line, what does that mean? time error 1004, The pivot table field name is not valid. Here a short copy of the code
  12. Bilberry

    Group and split into seperate excel workbooks

    Hi Skip, Yes, the source workbook is send by the vendor through email. They will send it only once a month. January is the first. Normally, they should be the same. The workbook contains one worksheet. And the table is the only data on the sheet. The naming should also be the same, but i will...
  13. Bilberry

    Group and split into seperate excel workbooks

    Hi Skip I have put it in a local directory. I have changed the named range there and also the range of the cells (after deleting some records, the range wasnt set properly). I think this was the issue. I have used also a pivottable to do some calculations. Im getting a run time error 1004, The...
  14. Bilberry

    Group and split into seperate excel workbooks

    Found to place to change this part! I will keep testing, for all the others, who want to change the range name: You have to do that from the define name window. Press Ctrl F3 (Or go to Insert | Names, Define...), select the named range that you want to modify, and change the "RefersTo" box...
  15. Bilberry

    Group and split into seperate excel workbooks

    Hi Skip, You are (always) correct! Ah, i need to define the range in the SOURCE workbook. It was my mistake to check where the VBA code was located. But if i open the SOURCE workbook, there is no table link. So when right clicking, i cant find the table option. Is there another way to change...
  16. Bilberry

    Group and split into seperate excel workbooks

    Unfortunately, the default name was: Query from excel files I have tried to change the value to QR, then im getting the error: Microsoft ODBC Excel Driver The Microsoft Access database engine could not find the object 'QR'. Make sure the object exists and that you spell its name and path name...
  17. Bilberry

    Group and split into seperate excel workbooks

    Hi Skip, Im using excel 2013. When rightclicking i couldnt find table range parameters. There is a submenu called table and from there the parameters is grayed out. There is also a external data properties menu. When i click on that i can give a connection name, should i change this part?
  18. Bilberry

    Group and split into seperate excel workbooks

    Hi Skip, How can I see the names range? Is that in the upper left corner. When I click on that the whole table is selected. From the drop down list, I see the name: Table_Query_from_Excel_Files Is this what you mentioned?

Part and Inventory Search

Back
Top