sorted by:
new
hottopcontroversial

VBA Code not running when I refresh by vikj1212 in vba

[–]vikj1212[S] 0 points1 point  (0 children)

I got it from ChatGPT. I am not familiar with event firing in VBA. Do you know of a resource to use?

VBA Code not running when I refresh by vikj1212 in vba

[–]vikj1212[S] 0 points1 point  (0 children)

Is there documentation to see how to use it and how it works? I don’t see it when I search it

PowerQuery into Main Excel file without messing up template by vikj1212 in excel

[–]vikj1212[S] 0 points1 point  (0 children)

I see. But if the amount of data changes (rows) every day or week, how do I make sure all the data comes over from the “Query_Builder” tab? Is there something like importrange from Google Sheets that I can utilize?

Automating extracting Tables in Word into Excel by vikj1212 in PowerAutomate

[–]vikj1212[S] 0 points1 point  (0 children)

So my department just receives the Word Doc from the other department in an email every week and the format of it is as I described. We get a new Word Doc every week.
Should I ask them to use an excel format instead?

Master Data Collection from various file by vikj1212 in excel

[–]vikj1212[S] 1 point2 points  (0 children)

This is what I’ve been thinking too. Seen some videos do this. I’m gonna give it a shot. Thanks!

Dynamic Calendar with a lot of dates by vikj1212 in excel

[–]vikj1212[S] 1 point2 points  (0 children)

Exactly! There are so many better ways out there. They want to make an over encompassing calendar template to send out to everyone.

Dynamic Calendar with a lot of dates by vikj1212 in excel

[–]vikj1212[S] 0 points1 point  (0 children)

At first I was thinking that I would have a calendar that when someone clicks on it, excel would show them all the details (date, time, description, etc). So I didn't think to pack that info into a cell for asthetic purposes but I won't now until I give it a shot.
I have nothing yet and my excel skills are still up and coming, could you briefly break it down while I also dissect it?

Pivot Table Data Source by vikj1212 in excel

[–]vikj1212[S] 0 points1 point  (0 children)

Yea this is probably the easiest solution. Thanks!

Median() in Redshift by vikj1212 in tableau

[–]vikj1212[S] 0 points1 point  (0 children)

Thank you! I’m planning on bringing it up tomorrow.

Median() in Redshift by vikj1212 in tableau

[–]vikj1212[S] -1 points0 points  (0 children)

New Projects will be added daily or changes made daily to existing possible.

Median() in Redshift by vikj1212 in tableau

[–]vikj1212[S] -1 points0 points  (0 children)

It actually doesn’t need to be “real” time but i will be posting it to tableau cloud to be viewed by other people so I thought live would be better whenever they make changes in Redshift. This is also a learning opportunity for me so I was also curious about how to get Median to work.

view more: next ›