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...
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,
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...
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?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.