Macro or Multi Row Formula
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I need some help for my calcu
I thought I can use Macro for input from and make output to All sheet. But I don't have idea how to do it one by one (per row). And is that true that I can do the calcu sheet with multi row formula?
Solved! Go to Solution.
- Labels:
- Macros
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@meitata
You are trying to create multiple sheets that is in same fashion of your "Calc" sheet?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I usually calculated it with excel's macro with that 2 sheets only.... I'll try to fill A B C D columns with calculation from Calcu sheet
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@meitata, can you provide a calc sheet containing values for A, B, C, and D related to other rows as well so that I can test it?
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@meitata, I have replicated your calc for row no 2 and 3 and updated the workflow. Try this!
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Is it possible if I calculate column A B C D with the data on row 2 and 3 in sheet All? @grazitti_sapna
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This all values of sheet A B C D @grazitti_sapna
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@meitata, I thought you are picking the values of A, B, C, and D from the Calc sheet. so that is why I asked to you enter the values of A , B, C, and D as per the format that you are currently using in the Calc sheet. Could you please try my workflow on your original dataset and let us know if it works for you?
Thanks!
