Search results for query: *

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

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

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

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

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?

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?