Ask Question Forum:
Model Library:2025-02-08 Updated:A.I. model is online for auto reply question page
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by fh_freese
at 2024-07-18 17:55:58
ModifyPoint:500 Replies:6 POST_ID:829025USER_ID:11849
Topic:
Microsoft Excel Spreadsheet Software;;
Expert,
In automating this workbook for the client, I've been ask to populate formulas from the attached worksheet to other cells in the same workbook labeled "Consolidated". The range to be populated in the "Consolidated" worksheet would be C6:U17. For example, in cell C6 the formula needs to be ''Jan 14'!B37, cell D6= 'Jan 14'!C37, cell E6 = 'Jan 14'!D37. This is the pattern for each month.
Currently, they have 15 Projects for 2014. Next year, they may want to add another year in the same work book and update the formulas in the Consolidated worksheet. Adding the next year worksheet with the correct tabs labeled has been solved. If I can get a macro that updates the months in the Consolidated for the first year as attached I know I can use that for upcoming year(s).
If I'm unclear, please advise. Thanks to all.
In automating this workbook for the client, I've been ask to populate formulas from the attached worksheet to other cells in the same workbook labeled "Consolidated". The range to be populated in the "Consolidated" worksheet would be C6:U17. For example, in cell C6 the formula needs to be ''Jan 14'!B37, cell D6= 'Jan 14'!C37, cell E6 = 'Jan 14'!D37. This is the pattern for each month.
Currently, they have 15 Projects for 2014. Next year, they may want to add another year in the same work book and update the formulas in the Consolidated worksheet. Adding the next year worksheet with the correct tabs labeled has been solved. If I can get a macro that updates the months in the Consolidated for the first year as attached I know I can use that for upcoming year(s).
If I'm unclear, please advise. Thanks to all.
Attachment:Consolidaed-with-Formulas.xlsm
Expert: test test replied at 2026-04-13 23:17:02
Author: fh_freese replied at 2024-07-18 19:03:09
thank you
Author: fh_freese replied at 2024-07-18 18:51:57
That's exactly what I'm working on now.
Accepted Solution
Expert: duncanb7 replied at 2024-07-18 18:46:39
500 points EXCELLENT
Just start small example first for 1 or 2 times Excell cell operation, and then get the recoded VBA code that will help to start your code writing easily and that also help other experts to assist your to finish your 228 time target or complete issue if you can provide some preparation work vba code, that also help on communication easily and fast during question reply and answer on this thread.
If the 1 or 2 times operation is similar to 224, you just change those variables setting
on the recorded VBA macro, for example,I think next time you will ask how to
program the workbook name as variable on VBA, that will help to narrow down the
issue and reduce your project time.
Duncan
If the 1 or 2 times operation is similar to 224, you just change those variables setting
on the recorded VBA macro, for example,I think next time you will ask how to
program the workbook name as variable on VBA, that will help to narrow down the
issue and reduce your project time.
Duncan
Author: fh_freese replied at 2024-07-18 18:26:21
I have thought of that but that would mean 228 times. However, maybe just doing three or four I could then adjust the code for the complete macro...
Expert: duncanb7 replied at 2024-07-18 18:05:03
Could you do it in manually ? If so, using Excel "Record macro" function to record all
your action that you did previously and manually. The macro recording function
will save all your action into one macro, and then you can copy the VBA code from
the macro for your reference to start your VBA macro program or writing.
It is video for Excel recording macro tutorial at
http://www.youtube.com/watch?v=nvWpFdo7EO0
Duncan
your action that you did previously and manually. The macro recording function
will save all your action into one macro, and then you can copy the VBA code from
the macro for your reference to start your VBA macro program or writing.
It is video for Excel recording macro tutorial at
http://www.youtube.com/watch?v=nvWpFdo7EO0
Duncan
