Hello all,
I am working at an IT company and during work I have to mention many data in different excel data. Here is the thing I want to do
Suppose I have three excel data sheet saved as
A, B and C
In Excel A I have mentioned many names
In excel B I have mentioned Age
In excel C I have mentioned City name
But I want to mention all these sheets data automatically by using one excel
As every sheet different value so Can I do it from one excel sheet?
Last edited by Goti; 09-24-2016 at 04:41 AM. Reason: missing word
Attaching a sample workbook enables others to work on your problem:
To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.
Click on GO ADVANCED and click "manage attachments" to open the upload window.
View Pic
To add a file to a post
Here is my sheet That I want to do
In Excel A,B and C have differnt value to be mention automatically by mention data through Excel D
Could you just copy the columns into Workbook D?
I think you don't get my point.
I have so many data that complicated and time taking for mentioning multi excel sheet. So I have given you simple example for manage all these too much data.
Simply say that I planning for programme those data sheet in such way that when I input any data on a specific sheet then It will be mentioned automatically at another target sheet.
I want to know is it possible or not?
You need to explain it better.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks