I have a microsoft spreadsheet with 150 sheets in it labelled by the day and date, all same format just different input figures.
I need to create a master sheet which pulls specific information... about 36 figures from each sheet).
I manually selected by equation what figures I want to pull across for the first day, however I'm unable to duplicate it for the other days.
I've created a spreadsheet which has the names of each of the 150 tabs in it for ease. I've attached an example of the summary sheet. I need to be able to create a pull down so that it automatically completes when the other tabs are filled in.
Hindi Annotation Translator Needed Category: English (US) Translator, Freelance, Hindi Translator, Language Tutoring, Linguistics, Translation, Urdu Translator, Writing Budget: ₹100 - ₹400 INR
21-Jul-2025 10:03 GMT
Hindi Annotation for Documentaries Needed Category: Audio Services, Content Writing, Hindi Translator, Language Tutoring, Proofreading, Research Writing, Transcription, Translation, Video Editing, Writing Budget: $2 - $8 USD
21-Jul-2025 10:03 GMT
Logo pour entreprise Category: Graphic Design, Illustration, Logo Design, Photoshop, Web Design Budget: €8 - €30 EUR
21-Jul-2025 10:03 GMT
Art Process Video Category: A / V Design, Animation, Video Editing, Video Post Editing, Video Processing, Video Production, Video Services, Video Streaming Budget: $250 - $750 AUD
Manual Data Entry from Excel Category: Data Analysis, Data Cleansing, Data Collection, Data Entry, Data Extraction, Data Management, Data Processing, Data Visualization, Excel, Web Search Budget: ₹100 - ₹400 INR
21-Jul-2025 10:00 GMT
Freelance Video Editor Needed for Mils Media Category: Adobe Premiere Pro, After Effects, Final Cut Pro, Motion Graphics, Video Editing, Video Post Editing, Video Production, Video Services Budget: $10 - $30 USD
21-Jul-2025 09:59 GMT
Data Entry & Editing Specialist Needed Category: Data Analysis, Data Cleansing, Data Entry, Data Management, Data Processing, Excel, Microsoft Office, Word Budget: €30 - €250 EUR
21-Jul-2025 09:58 GMT
2D/3D Solar Shadow Analysis Web App Category: 2D Drafting, 3D Modelling, Data Visualization, Frontend Development, Geospatial, Google Maps API, JavaScript, PHP Budget: ₹12500 - ₹37500 INR
21-Jul-2025 09:58 GMT
Excel Expert for Data Analysis Category: Data Analysis, Data Analytics, Data Entry, Data Processing, Data Visualization, Digital Marketing, Excel, Visual Basic Budget: $30 - $250 USD