workbook1

Hi everyone. I'm having a hard time coding this one. My objective is to select the sheet name based on a cell value from another work book. Say, in workbook1, range(a1)= d-4 Then i want sheet(d-4) opened in workbook2. The catch is, i want to dynamically do it. That is, once sheet(d-4)...

Hi! This time I am really stuck. I have two workbooks Workbook1 (main file - named: h:\dekstop\somethingneweveryday.xlsm) Workbook2 (data file - named: H:\desktop\blomst.xlsx) I do my work in Workbook1. I use a macro in workbook1 to open and activate Workbook2 and do some stuff and collect...

<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier...

Hi can anyone help with a macro to copy a range of data from one workbook to another? I have rows of data on workbook1 sheet(Data) range A2:H that I want to copy to workbook2 sheet(Data). I need the data to copy to workbook2 in the same columns as workbook1 but continue the data to the next...

How can I..... From workbook1 open the first workbook (no matter what the name is) in directory X. copy value in a1 and b6, paste it to a1 and a2 in workbook1 Open next workbook (no matter what the name is) in directory X copy value in a1 and b6, paste it to a1 and a2 in workbook1 Do the same...