|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Transfer data to another book based on the active cell - Specific ranges only
Hi Folks,
I need your help to automate this task based on the Excel VBA. I have the master excel workbook named as "Maintracker" which needs to be move specific data ranges (ranges are dynamic so we have to select a range based on the current selection cell) in each row (F2:G2) based on the current cell selection to another respective workbook named as "SB" and "XT" vice vara if click the specific button in Maintracker we create. I have attached the three sample files as mentioned above and highlighted in yellow. In case I have new data in Maintracker which is also needed to move respective workbook based on the Main tracker workbook "Engine Name" column value (SB or XT) when I click the button at the end of the row in the respective workbook. Additionally if try to copy any duplicate row Vb yes or no pop up will ask yo confirm. Please review and let me know. Advance thanks!!! Ganesan. G Last edited by ganesang; 03-13-2020 at 08:09 AM. |
#2
|
|||
|
|||
Hi Guys,
I have rewritten my words here more clearly to sort out a clear understanding. I need the two-way transfer/copy some specific ranges of data as follows. Maintracker to Sub-excel (SB or XT) ranges - (D:E:F) Sub-level excels to Main-tracker ranges - (A:B:C) (from both SB and XT to the main tracker) I have a master excel file (Maintracker) which has the data to be moved some specific ranges (E:F:G) to respective sub excel files (XT, SB) vice vara based on the current cursor position in master file column "E". Please refer the attached sample files for the references. Also if any range of data duplicate if try to transfer both ways the msgbox alert (yes or no) will appear to confirm based on the column B value which has some time more than one check required. Please help me out on this as soon as possible is great!!! |
#3
|
||||
|
||||
I'm afraid the second attempt isn't much clearer, but I hate seeing a question simply ignored :-). Let's see whether I can make sense of this.
You have three workbooks, named MainTracker, XT and SB. There's a button (or maybe two buttons) in MainTracker. No, wait, I don't see any buttons there; maybe you meant you will create them. If you push one button, you want certain values to be copied from MainTracker to XT or SB; if you push the other button, you want the same ranges to be copied back into MainTracker from XT or SB. You speak of the need to ask the user to confirm if there's a danger of copying duplicate information, but we'll have to save that for later; we'll do this a piece at a time. The column headed "Job Name" in MainTracker evidently indicates which workbook should be the target and source of the copies; if Job Name is "XT" then Model and Location should be copied to (or from) the workbook named XT, and the same for "SB". How am I doing so far? Is this even approximately correct? And by the way, what language are you used to? Maybe it'll be something I'm halfway familiar with, in which case we can communicate better. |
#4
|
|||
|
|||
Hi Bob,
Thanks for the reply!!! You correctly understood my concern. Based on your question, How am I doing so far? Is this even approximately correct? As I mentioned earlier, the current cursor/cell position, the respective row's data range should copy to the respective workbook (XT or SB). And by the way, what language are you used to? I hope Excel VBA is a better language for this. Please let me know if anything required. Thanks in Advance!!!! Ganesan. G |
#5
|
||||
|
||||
When I asked about languages I meant (for example) Bahasa. Or maybe Tamil? Just guessing. Neither one is among my accomplishments, so maybe we'll just have to stick to English.
Anyway, let's talk about the program: How much of it have you written so far? Which parts are working and which parts puzzle you? If you're starting from the very beginning—if you don't know even how to start a VBA program in Excel—I'll have to start explaining from the beginning too. I want to know how much you already know, and have done, so I won't waste your time. |
#6
|
|||
|
|||
Again thanks for the response!! Bob
I am completely blind in excel VBA instead of using some excel functions to automate my simple tasks. Actually, I need to transfer data from multiple excels to single (consolidate) file. So, again I have explained a very straight forward and attached sample I need to transfer the values from two kinds of excel to one consolidated excel file at the end of the row every time. From these three files, the QA tracker is static and the other two files have dynamic values or files but the naming of the excels is not changed. So, if try to get values from two dynamics excels to one consolidated file for respective columns I have highlighted in yellow in each file to identify. If there is an option to get data from two excel files to on QA tracker using Button is best for me! Please let me know if you need anything further. Thanks in advance! Ganesan. G |
#7
|
||||
|
||||
Sorry for the delay, ganesang. I take it "completely blind" means you've never written an Excel program before, and don't know anything about it. But if you want to write this program, you'll have to learn. I don't mind coaching you, but if you'd rather not do that—if you're hoping someone will write it for you—I recommend you repost your question and hope someone else will answer. I'll leave the post alone, if you do that, so other people won't see my response and think your question is answered already.
But if you want to learn to write programs, let me know and I'll teach you, one step at a time. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How can I transfer specific data from email to specific excel cells? | Mauro | Outlook | 1 | 11-11-2019 09:17 PM |
Use of named ranges based on cell content | Intruder | Excel | 12 | 02-25-2019 09:42 AM |
VBA to Insert variable rows based on a data in active cell | Marcia | Excel Programming | 4 | 07-28-2018 10:02 AM |
Ranges that Grow Based on Data | TheThack | Excel | 1 | 07-27-2016 11:36 AM |
Data Validation List based on Two Named Ranges | Rich18144 | Excel | 4 | 01-14-2016 04:37 AM |