FirstDefinition

u/FirstDefinition




r/excel•

I work in a chain of clothing stores and my job is to control the cash flow of each store.

At the end of each month I have a task that requires copying the month's billing data to a file related to the store itself. And there are many stores.

What is the best way to automate this task?

Thank you everyone!

12

r/excel•

Hello every one!

I am having a problem with running a macro in my excel, it shows the following warning:

"The update of one or more links failed or the update operation was cancelled. Do you want to proceed with updating the remaining links?"

I tried to run the same macro in a colleague pc and it worked.

Can someone help me with this

11


r/github•

I'm learning HTML5 and CSS3. I created a repository on Github to put my small works.

However I'm having trouble activating the Github page. I've tried to google how to do it but I still can't.

From what I've researched it should be: Settings/(and then scrolling down) GitHub pages; But I have this tab as you can see in this screenshot: https://ibb.co/2NY3SgW.

Thank you.

42

r/excel•

Hello everyone!

I'm trying to create a tool to facilitate my calculations.

I have a dataset containing a lot of information about different metal profiles.

I want to find a way to isolate from the different groups considered to isolate the lines in a way that I can select the data in order to be able to automate the calculations. As shown in image 2, but in this case it is not possible to automate because the line will always be different.

I tried to create the pivot table but it didn't work.

Does anyone have any suggestions. Thanks.

[image_1]: https://ibb.co/D10Mt1N

[image_2]: https://ibb.co/tqGzTFM

12



r/vba•

I need help, please. I will try to explain the problem.

I have a list of parameters, which I will call k, to better understand the problem. I need to put each element individually from list k in a system that will generate another list x and I need to get the maximum value of list x for each individual element in list k.

Is there any method that I can use from Excel or a VBA tutorial that can help me?

EDIT_1:

Sorry for not being able to express myself properly.

-Both lists are numbers;

- I intend the biggest number in list X that is assigned to each number in list K.

I'm trying to automate this process, i took a print os me sheet in order to give a better understanding of the prob

212

r/excel•

I need help, please. I will try to explain the problem.

I have a list of parameters, which I will call k, to better understand the problem. I need to put each element individually from list k in a system that will generate another list x and I need to get the maximum value of list x for each individual element in list k.

Is there any method that I can use from Excel or a VBA tutorial that can help me?

13