Register
Log In
Unanswered
Home
New Member
Power BI
Xtreme Pivot Tables
April 20, 2015
Offline
I have a form that is presently in Word that is more appropriate to be in Excel as it includes calculations.
In the past, I would consider using Excel Userforms that would compile the ten questions plus header information for the form on a separate sheet.
Can I instead have a simple Excel spreadsheet where each completed form would located in the file named Current Month. If there were twenty forms completed, I would then use Power Query to consolidate all the forms into a simple table.
- Is this as easy as it sounds?
Thanks for your insight.
Greg
July 16, 2010
Online
Hi Greg,
I'd use Excel Survey to collect your data. You can add columns to the table created by Excel survey and add your formulas in there. Otherwise I'd use Excel Forms to collect the data and put the entries straight into one table, rather than separate tables which then need to be summarised.
Hope that helps.
Mynda
Most Users Ever Online: 57
Currently Online: Mynda Treacy
16 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
sugi gunawan
janja mesec
John DiMartino
lizette acosta
eric johnson
Kim Bond
Nichelle Stevens
Manuel Rodriguez
peter wang
Amit Kanekar
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
