Hi!
It is general question about Excel. No certain examples i can attach.
I have 2 sheets. "Sheet 1" contains input data columns and result column. "Sheet 2" calculates result using many operations with input data. Is there any way to put data row by row from sheet 1 to sheet 2 and return results to sheet 1? See pic for more information.
Excel.png
Sorry, but if you cant describe it, how are we supposed to try and help you?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi ctpexhih and welcome to the forum,
I think you are going to need VBA code to do what you want. I think you could copy that range from sheet1 to sheet2 and then copy the result and paste it back to sheet1 using Values only. You'd have to do that many times. There might also be some trick where you would put in the row number from sheet 1 you want in your sheet2 cells and using Indirect() pull them over, but I think you'd still need to copy and paste them back. I'll think about this some more....
Maybe some smart Guru can come up with a non-VBA solution.
Last edited by MarvinP; 03-29-2020 at 12:51 AM.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There is an example of what i am talking about.
Thanks MarvinP for the answer. I supposed there is no way without macros, but maybe guru knows some tricks.
what's the formula for the "hard calculations?"
Ben Van Johnson
Hi ctpexhih,
See if the attached makes your work a little easier. I created a row on sheet1 that copies down the rows from the above table based on a single cell (C20)
You change the value in C20 from 2 to 16 and that rows numbers are copied down to row 21...
NOW - Sheet 2 numbers are taken from Row 21 of Sheet 1. Sheet does it's calculations and gives answer in cell B26.
On Sheet 1 in cell H21 is a formula that returns what is on Sheet2!B26 (Wow)
Copy and paste the value only from H21 up to the correct row in column H and you can get answers pretty fast. No VBA just playing around...
Almost Curcular Function from Other Sheet.xlsx << Click on this attached file to open and see what I did.
I wonder if some Smart Guru can come up with something better?
ctpexhih It have been already explained you here . Many of hard calculation can be done in one cell but you didn't want to show your difficult formulas. And as I see now you try to do the same mistake.
Last edited by BMV; 03-29-2020 at 02:20 AM.
Hey Ben,
He has those calcs on his second sheet. They are a bunch of different calcs from the numbers on row 1.
Got any better Ideas that what I did below? I'd love to see them.
Hi, MarvinP,
Thanks for example!
This is the best way to solve this without macros! Thanks for you help. I think I will use macros in my real application to do this stuff without copy-paste.
It would be very useful if excel has standard formula like, for example: =INDIRECTCALCULATIONS(sourceCells; destinationCells; resultCell), where
sourceCells - data should be taken from;
destinationCells - data should be inserted to destinationCells from sourceCells;
resultCell - cell the result of calculation should be taken from.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. As you are new here, I will provide the link below.)
https://www.planetaexcel.ru/forum/in...message1046900
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi, AliGW,
I have tried to add crosslink in my first message but I received a notification:
The following errors occurred with your submission
You are not allowed to post any kinds of links, images or videos until you post a few times.
Please see the last two lines of my post!
off
Yes it's true. I have had the same even I inserted link to Microsoft docs in my firsts posts.The following errors occurred with your submission
You are not allowed to post any kinds of links, images or videos until you post a few times.
By the way here I inserted link not because of cross posting but because of you on the wrong way.
Last edited by BMV; 03-29-2020 at 04:12 AM.
@BMV - you should have used the report button to report the post.
No new member with fewer than 10 posts is able to post links.
Hi, AliGW,
Of course I have read that lines. Just explain why I didn't insert the crosslink. Thank you.Please see the last two lines of my post!
Nonetheless, you should have told us that you had posted the question on another forum, even if you could not supply the link. Cross-posting should always be declared. Thanks for your co-operation in future.
It is up to the OP to comply with a moderation, not other members, but thanks for the attempt
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks