#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
Where should I look for the "stupidity" ? at the beginning or at the end ?
|
#3
|
||||
|
||||
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] |
#4
|
|||
|
|||
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.)
|
|
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 |
Data from excel to word? /alternative ways? | slimhan | Excel | 1 | 11-17-2012 08:17 PM |
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 |