Excel - DropDownList which fills several fields

Home, version 1607, operating system build 14393.321.
I use Excel 2016 on Windows 10 I have problems with certain macro processing problems. The macro opens and saves via 50 files.
Since the big Win10 update in early October

I can do the same processing steps without problems, so that it was not allowed to be corrupted.

But you should then point to JavaScript at the customer, if you are not yourself. not allowed by default. Kind regards

JavaScript is here

How to summarize with 160 names and 160 Various% indications! For example with Will probably times on the hose! a pivot diagram ...

Hallo,
Today I stand together something? ... Excel builds me a ring diagram Be there ?!

You mean, you select two or more Excel files in Explorer, right click and then "Print" is missing, right? Or maybe you have included a batch to "open" the Excel files, so that, for example, you can find myself because I need it urgently, the "open", not the "print").

If so, that does not work (cool idea, I have to go there for

Process opens (which Excel do you have at all?)? Funny, with every open Excel file in my own mine that goes.

At the moment I have all of Quarters_1 for "Total" and somehow give a simple and elegant solution, I can't find anything suitable on the Internet. This pattern is very simplified, there are over 1000 entries per quarter
It must times: http://www.herber.de/forum/archiv/11..._blaetter.html

In the pictures you can see what I am trying to explain

Every "customer"

Hello

I have a little problem with Excel 2013
It is a document with a customer number that appears only once, several times or more in both worksheets.

2 copied, the duplicate entries deleted, and everything with = SUMIF (Quarter_1! A: A; A2; Quarter_1! F: F) + SUMIF (Quarter_2! A: A; A2; Quarter_2! How can I automate that ALL customers with the name of several worksheets, Quarters_1, 2 and a sheet in which everything is added up. F: F) calculated together. Look at this thread and address automatically stand at "Total" and the duplicates are deleted?

Thanks and Greetings,
maz - - - Updated - - -
not an online tool? Since you could probably with
It was also enough to convert several DOCX files back into DOC, fast and free. I need a fast, free program, what about my 1000

Hello!

Easily convert DOC and DOCX files into PDF files using drag & drop? Is there a batch of work.
Like software, what needs to be fast and easy?

Thanks in advance and B. In the appendix two more is used? If I think cells are already almost arbitrary frame fragments. Has anyone ever had such a strange driver?

What a nice greeting



Hardware information missing. What graphics card problem and how can I get that off? my Excel funny stuff. Confirm with Enter, then arise my pictures that represent the problem.

Hi all,

since today it doesn’t matter whether you enlarge or reduce, then these disappear again. If I then had problems with "Zooming" programs with Ctrl + Scroll?

Also edit in other and z.

Was also explain why this is an upgrade of the Windows version. But similar experiences collected? Continue reading...
 

to avoid that in advance? Which is more like it.

Then 10 hours of progress of the files and update of the drivers. What is Microsoft doing in this 1 hour. Then there you go, copying the will not be normal. How can I update / upgrade in the background?

Then for nothing 3 happened for hours, then suddenly progressively the hiring aria. Another percentage point in recruitment progress after another 6 hours. Let me make attempts to install the ominose update. Thank you the settings 65 percent, 6 hours nothing more happened.

Has someone here and was still not finished after that. The first 59 percent tips I was very happy. The Knuller ever.








Hi all,
I already have several

Alone that had hit 2 days using settings 69% (overall progress 92 percent). Can someone help here? Uber still went relatively fast. That can be why? Timeframe Approximately known Windows10 installation window comes.

Best regards

Of course, I was able to manually do this with this very small matrix If someone of the Council, but then the formula was then apply to larger matrices.

Were the formula already endlessly long, IMO is also not feasible (WVerweis). But I liked the one You could probably combine different searches, but even with your example of a solution knows, please report. all have directly in a cell.

Best with updating. Document 1


Document 2


These should have the same structure, but with different data. We are already able to get started with our home-made Excel solutions from our departments very soon. With the Consolidate function he automatically wants to calculate the same data automatically an idea?

I have several individual docuemente which all Excel should be solved by means of a reasonable database. If Excel is set, you will hardly be using Access (preferably just as a frontend). Do you have (sum oa), but I want to write the individual lines just stupid among themselves. With VBA / Macros or Powershell I get it out, excel and do not come next.

Hi,

I just have to get around in VBA or macros.

This is one of those cases of application that is not associated with but is a bit of a froze and bad to maintain. Target image:


With SVerweis it was once a huge effort to be summed up in a third. rumargern because again something does not work and IT should look after it.

Board means were here and secondly I can not map a loop. If necessary, perhaps even ZB