•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
PowerQuery and add manual data
Hi everyone,
I have a Power Query in Excel that outputs a table with [title] [date].
I need to manually add the Sprint number in an extra column [sprint] to specific combinations, aka "I will work on this this month."
The problem is every time the query refreshes, any manually entered data gets lost or misaligned.
- New rows come with the needed values.
- Row order changes.
Because this table is used by many people, I want them only to add the sprint number, nothing else, no copying data or anything.
I would like to know more about your experiences when data needs to be written infrequently but many times.
I am open to know more for powerbi options direct dashboard too.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#real-time data collaboration
#big data management in spreadsheets
#conversational data analysis
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#rows.com
#Excel compatibility
#financial modeling with spreadsheets
#Excel alternatives
#natural language processing for spreadsheets
#row zero
#real-time collaboration
#Power Query
#Excel