Recent content by Bilberry

Indeed! Thanks!

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 =...

@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...

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

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...

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

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

Hi Skip, yes you can add multiple date times

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...

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...

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)

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

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

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...

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...