▲ 13 r/vba
How many of you are in IT?
I see some of you are making Doom and Minecraft with VBA which is way beyond me but I am not a developer. So now I am curious.
u/taylorgourmet — 10 days ago
▲ 0 r/learnpython
Copy paste excel range from one workbook to another
Beginner here writing my second program after hello world. I know I can just ask AI but is there some tutorial out there I can read?
u/taylorgourmet — 1 month ago
▲ 2 r/excel
Power Query only pulls first 73 rows
Grabbing file from sharepoint folder and only the first 73 rows are pulled. Columns with formulas are null. When I save the file to a local folder and grab it that way, everything works fine. What am I missing?
u/taylorgourmet — 2 months ago
▲ 7 r/excel
Power query how to add identical items from two worksheets
Pulling two worksheets from a workbook. They share the same items. Power query creates a table on the left. How can I add each item together so it looks like the table on the right? When I groupby I only get 1 set of items because they are identical.
u/taylorgourmet — 3 months ago
▲ 0 r/excel
Formulas break when power query table refreshes
I have a power query that loads to a table. I have xlookup formulas that reference ranges in the table. When I refresh the query, one column is replaced by another and that breaks the formulas. I can't use index/match because the formulas reference rows and that will just pick up the first instance.
Month column gets refreshed and formula turns into #ref errors. Not sure how much more clearer I can make.
LOL people downvoting me for not comprehending what ranges mean in a xlookup LOLOL
u/taylorgourmet — 3 months ago