Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-06-2022, 03:21 PM
Hanfrn Hanfrn is offline Alternative ways to populate a spreadsheet Windows 10 Alternative ways to populate a spreadsheet Office 2019
Novice
Alternative ways to populate a spreadsheet
 
Join Date: May 2022
Posts: 1
Hanfrn is on a distinguished road
Angry Alternative ways to populate a spreadsheet

Hi guys,



I have a problem because of my stupid manager.
She wants me to populate a spreadsheet where some columns I could use a formula to save me time. However, she locked the sheet and wanted me to do it manually.

I wonder if there is any script or macro that I could use even if I do not have the password.

The first column is the one I need to do manually. The third column is where I could use a formula, but I can't because my manager does not want it.

I need a script or macro or anything to populate the third column like that:

ID - CFSG22/30M00X/ID
1111 - CFSG22/30M001/1111
1050 - CFSG22/30M002/1050
3333 - CFSG22/30M003/3333

Thanking you in advance.
Sheet.png
Reply With Quote
  #2  
Old 05-06-2022, 03:33 PM
rollis13's Avatar
rollis13 rollis13 is offline Alternative ways to populate a spreadsheet Windows 10 Alternative ways to populate a spreadsheet Office 2016
Advanced Beginner
 
Join Date: Jan 2021
Location: Cordenons
Posts: 89
rollis13 is on a distinguished road
Default

Quote:
Originally Posted by Hanfrn View Post
[...]I have a problem because of my stupid manager.[...]However, she locked the sheet[...]I wonder if there is any script or macro that I could use even if I do not have the password.[...]
Where should I look for the "stupidity" ? at the beginning or at the end ?
Reply With Quote
  #3  
Old 05-06-2022, 10:43 PM
macropod's Avatar
macropod macropod is offline Alternative ways to populate a spreadsheet Windows 10 Alternative ways to populate a spreadsheet Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,516
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Hanfrn View Post
She wants me to populate a spreadsheet where some columns I could use a formula to save me time. However, she locked the sheet and wanted me to do it manually.
I doubt there's a locking mechanism that would allow you to input a value but not a formula.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 05-09-2022, 12:10 AM
ArviLaanemets ArviLaanemets is offline Alternative ways to populate a spreadsheet Windows 8 Alternative ways to populate a spreadsheet Office 2016
Expert
 
Join Date: May 2017
Posts: 703
ArviLaanemets is a name known to allArviLaanemets is a name known to allArviLaanemets is a name known to allArviLaanemets is a name known to allArviLaanemets is a name known to allArviLaanemets is a name known to all
Default

Create the spreadsheet using formulas. Before sending the workbook to your boss, copy the range with all formulas, and from right-click menu use PasteSpecial.Values on same range. (In case you want to keep the formulas for later use by yourself, save the workbook as 1st step, then overwrite formulas with values using PasteSpacial, and then save the workbook with different name - and send the last one to your boss.)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to access info from Excel spreadsheet and populate Word doc with text, photos, and captions henhelm Word VBA 4 06-27-2019 08:49 PM
ways to declutter 2016? Words Word 1 03-06-2017 08:55 AM
Alternative ways to populate a spreadsheet Data from excel to word? /alternative ways? slimhan Excel 1 11-17-2012 08:17 PM
Alternative ways to populate a spreadsheet Searching A Database Two Ways skoz55 Excel 3 11-10-2011 01:01 AM
How do I use an Excel form to populate and Excel spreadsheet apostht Excel 0 05-21-2006 11:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:37 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft