remove blank column

Fayaz Mohamed

• March 20, 2024 03:16

Hi,

I have linked excel file to bartender template. In the excel file first 4 lines i have to skip and from column 5 data should appear in the template.

is there any way to skip first 4 columns in bartender or write code in bartender VB?

Thank You in advance.

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • March 20, 2024 08:55

  In the Database Connection Setup use the Specify Range option starting with A4 and then most right column and how many records you need, eg A4:Q1500

  For you setup leave the First Row has Field Names ticked unlike in the image below  

  

  0
• 

  Fayaz Mohamed

  ★ BarTender Hero ★

  • March 22, 2024 06:28

  Thank You very much. It works

  0

Please sign in to leave a comment.