"I am working on multi worksheets and managed to have a summary sheet that contains the name of each worksheet in column B.
Now i have another column F that contains specific values against all worksheets. I want these values to be auto filled on respective Worksheets in Cell location D3 of each worksheet.
i am trying to find the solution but it seems only you can help me."
Just guessing without sample workbook:
Please Login or Register to view this content.
Best Regards,
Kaper
Dear Kaper, thanks for response. please see attached sample sheet. I want values in "column E" should be copy automatically in "cell D3" of each respective worksheet which is listed in "Column B".
image file.png
so probably:
Note that the image you posted is frankly speaking: uselessPlease Login or Register to view this content.
If it had column letters and row numbers would be a bit better (I'm not sure if the value is indeed in column E - you have shown 4 columns so rather A:D - if so use offset(0,2))
But appropriate attachment for this forum is a workbook. Can contain dummy data but the structure and formatting shall be the same as real data.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks